Open SQLPLUS from CMD and type following credentials username: system password: akbar123 Or else type following command in CMD or RUM prompt sqlplus / as sysdba Example: How to create a table name "student" CREATE TABLE student( id NUMBER, firstname VARCHAR2(40), fathername VARCHAR2(40), surname VARCHAR2(40), class NUMBER, address VARCHAR2(50) ); Example: How to insert the new students records INSERT INTO student(id, firstname, fathername, surname, class, address) VALUES(101, 'Aleena', 'Akbar', 'Bagwan', 7, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address) VALUES (102, 'Aliza', 'Akbar', 'Bagwan', 5, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address) VALUES (103, 'Alishba', 'Akbar', 'Bagwan', 0, 'Mumbai'); INSERT INTO student(id, firstname, fathername, surname, class, address)VALUES (104, 'Dibyanka...
Comments
Post a Comment