Pages

ORACLE


SQL PLUS * Commands

1. Connect as sysdba  - sqlplus / as sysdba 

2. Connect to schema  - SQL> connect username/password;


3. Display Table Structure - SQL> describe  table_name;

4. Add New column to table - SQL> alter table table_name add column_name(data type);

No comments:

Post a Comment