Skip to main content

Posts

Showing posts with the label Rename command

Rename Command (DDL) in SQL Oracle With Implementation

 Rename Command (DDL) in SQL Oracle With Implementation For explanation watch Video:: Rename command :: Used to change the name of table SQL> desc emp01;  Name                                      Null?    Type  ----------------------------------------- -------- ----------------------------  FNAME                                              VARCHAR2(15)  SAL                                                NUMBER(10) SQL> rename emp01 to emp02; Table renamed. SQL> desc emp01; ERROR: ORA-04043: object emp01 does not exist SQL> desc emp02;  Name                                      Null?    Type  ----------------------------------------- -------- ----------------------------  FNAME                                              VARCHAR2(15)  SAL                                                NUMBER(10)