Posts

Showing posts with the label SQL

Create table using SQL.

Create table using SQL. SQL > connect Enter user - name : pandey121 Enter password : Connected . SQL > CREATE TABLE COLLEGE_STUDENT1(ID NUMBER , NAME VARCHAR( 20 ) , GENDER VARCHAR( 6 ) , STATE VARCHAR( 10 )); Table created . SQL > DESC COLLEGE_STUDENT1; Name Null ? Type ----------------------------------------- -------- ---------------------------- ID NUMBER NAME VARCHAR2( 20 ) GENDER VARCHAR2( 6 ) STATE VARCHAR2( 10 ) SQL > SQL > INSERT INTO COLLEGE_STUDENT1 VALUES( 1 , 'SHRADDHA NAND PANDEY' , 'MALE' , 'JHARKHAND' ); 1 row created . SQL > INSERT INTO COLLEGE_STUDENT1 VALUES( 2 , 'ARYAN' ,