//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:
Post a Comment