Inserting Into Table2

//use  & to display domain name
SQL> insert into student_register values(&Rgno,'&name','&Class','&remarks');
Enter value for rgno: 001
Enter value for name: xxx
Enter value for class: 3rd-A
Enter value for remarks: good
old   1: insert into student_register values(&Rgno,'&name','&Class','&remarks')
new   1: insert into student_register values(001,'xxx','3rd-A','good')
1 row created.
// use / to run the query again 
SQL> /
Enter value for rgno: 002
Enter value for name: yyy
Enter value for class: 2nd-B
Enter value for remarks: talkitive
old   1: insert into student_register values(&Rgno,'&name','&Class','&remarks')
new   1: insert into student_register values(002,'yyy','2nd-B','talkitive')
1 row created.
SQL>  select * from student_register;
    REG_NO NAME             CLASS                REMARKS
---------- ---------------- -------------------- ---------      
         1 xxx              3rd-A                good
         2 yyy              2nd-B                talkitive
SQL> 

No comments:

Related Posts with Thumbnails