Check list of table on your sql database


SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
BONUS
DEPT
EMP
SALGRADE
SQL> describe emp;
 Name                                     Null?   Type
 ----------------------------------------- -------- ----------------------------
 EMPNO                                    NOT NULL NUMBER(4)
 ENAME                                             VARCHAR2(10)
 JOB                                               VARCHAR2(9)
 MGR                                               NUMBER(4)
 HIREDATE                                          DATE
 SAL                                               NUMBER(7,2)
 COMM                                              NUMBER(7,2)
 DEPTNO                                            NUMBER(2)
SQL>Â
- sql_command's blog
- Login or register to post comments
- 318 reads
- Email this page












