Скачать или смотреть SQL with Oracle 10g XE #7 Using DML Commands!!!

hey guys in this video I will tell you about DML(data manipulation language) in oracle or sql
1. CREATE TABLE
2. ALTER TABLE
a. ADD
b. MODIFY
3. TRUNCATE TABLE
4. DROP TABLE
******************
Step 1
CREATE TABLE COMMAND
create table student(rollno number(2),name varchar2(20),dept varchar2(5),doj date);

Table Created.

Step 2
desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ROLLNO NUMBER(2)
NAME VARCHAR2(20)
DEPT VARCHAR2(5)
DOJ DATE

Step 3

ALTER TABLE COMMAND (ADD COMMAND )
alter table student add regno number(10);
Table altered.







Step 4

desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ROLLNO NUMBER(2)
NAME VARCHAR2(20)
DEPT VARCHAR2(5)
DOJ DATE
REGNO NUMBER(10)

Step 5

MODIFY COMMAND
alter table student modify ( name varchar2(25));
Table altered.

Step 6

desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ROLLNO NUMBER(2)
NAME VARCHAR2(25)
DEPT VARCHAR2(5)
DOJ DATE
REGNO NUMBER(10)

Step 7

INSERTING DATA INTO TABLE: (insert 2 Records)
insert into student values(1,'ajay','cse','15-aug-06',8082104001);
1 row created





Step 8
select * from student;
ROLLNO NAME DEPT DOJ REGNO
---------- ------------------------- ----- --------- ----------------------------------
1 ajay cse 15-AUG-06 8082104001
2 barathi ece 20-JUL-06 8083104001


Step 9

truncate table student;
Table truncated.

Step 10
select * from student;
no rows selected

Step 11
desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ROLLNO NUMBER(2)
NAME VARCHAR2(25)
DEPT VARCHAR2(5)
DOJ DATE
REGNO NUMBER(10)

Step 12
drop table student;
Table dropped.

Step 13
desc student;
ERROR:
ORA-04043: object student does not exist



I hope you will like my video

thank you so much for watching my video

don't forget to like share and subscribe

if you have any doubt please leave a comment in comment box