SQL COMMANDS And Software Which Use For Performing These Commands :HOW TO CREATE TABLE ,DELETE AND INSERT DATA IN TABLES AND USE OF PRIMARY KEYS...

Writer: M.Hunain.Zahid

SQL Commands:

Software which is use to perform this commands:

Copy This Link And Past In your Google Chrome Your Downloading Is Start automatically And Install The Software in Your PC Or Laptops. 

Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c)

https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

1.TO CLEAR SCREEN  COMMAND:

SQL>CLEAR SCREEN

1.Create table:

SQL>connect

SQL>PASSWORD

SQL>create table student(S ID number , NAME  varchar2(10)  ,Address varchar2(10)  );

SQL>Table created.

2. To show table:

SQL> desc student;

3.Insert Data in table:

SQL>insert into student (this is table name) values (1, ‘JUNIAD’ , ‘ISLAMABAD’);

SQL>insert into student (this is table name) values (2, ‘ALI ’ , ‘Rawalpindi’);

SQL>insert into student (this is table name) values (3, ‘MUNEEB KHAN’ , ‘LAHORE’);

4.to show data in table(rows and colum):

SQL>select * from  student;           (->and enter press)

5.Enter data through direct command (asking to user to enter data):

1. SQL> Insert into student value (&ID , ‘&Name’ , ‘&ADDRESS);

2. SQL> insert into student(ID , Name) Value  (3 , ‘Khan’);

6.Primary Key (Null or Not DUPLICATE)

SQL>create table teacher (T ID Number primary  key , Name varchar2(10) not null , Address varchar2(15) UNIQUE );

Press enter button.

SQL>Table created.

7.ALTER (INSERT NEW OPTION IN OLD TABLE)

SQL>ALTER TABLE STUDENT  ADD (MARKS NUMBER);

PRESS ENTER

SQL> TABLE IS ALTER.

8. ALTER ID OF TWO D/F TABLE USING  REFERENCES:

SQL>ALTER TABLE STUDENT(TABLE NAME WHICH CAN YOU ALTER) ADD( T ID NUMBER(10) REFERENCES TEACHER);

SQL>TABLE ALTERED

9. ADD FOREIGN KEY IN PARENT

SQL>ALTER TABLE TEACHER ADD CONSTRAINT TEACHER_DEPT_FK  FOREIGN KEY(DEPT) REFERENCES TEACHER(DEPT);

SQL>TABLE ALTERED

10. Apply check constraint on parent table:

SQL> ALTER TABLE TEACHER ADD CHECK (DPT>=5);

SQL> TABLE ALTERED

11. ENABLE AND DISABLE COMMAND ON PARENT TABLE:

SQL> ALTER TABLE TEACHER ENABLE CONSTRAINT TEACHER_DEPT_KF;

SQL>ALTER TABLE TEACHER7 DISABLE CONSTRAINT TEACHER_DEPT_FK CASCADE;

SQL> TABLE ALTERED

12. CASCADE Primary Key (Through Drop Constraint): 

SQL> ALTER TABLE STUDENT DROP PRIMARY KEY CASCADE;

SQL>  TABLE ALTERED.

Thank you...
To Subscribe our blogspot and like,share,comments about our topic...