Tuesday, July 30, 2013

Oracle Pl / SQL View Table Structure


SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 30 16:36:06 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> CONNECT
Enter user-name: sakib
Enter password:
Connected.
SQL> DESC EMPLOYEES;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 EMP_ID                                             NUMBER(5)
 LASTNAME                                           VARCHAR2(20)
 FIRSTNAME                                          VARCHAR2(20)
 ADDRESS                                            VARCHAR2(200)
 CITY                                               VARCHAR2(15)

SQL> DESCRIBE EMPLOYEES;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 EMP_ID                                             NUMBER(5)
 LASTNAME                                           VARCHAR2(20)
 FIRSTNAME                                          VARCHAR2(20)
 ADDRESS                                            VARCHAR2(200)
 CITY                                               VARCHAR2(15)

SQL>

No comments:

Post a Comment