Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Run SQL*Plus Commands in SQL Developer
How To Run SQL*Plus Commands in SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECRIBE command in SQL Developer:
You will see the following output:
Name Null Type ------------------------------ -------- ------------------ USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000)
The DESCRIBE command returns you the detailed information about the specified table.
2007-04-27, 5385👍, 0💬
Popular Posts:
Is Session_End event supported in all session modes ? Session_End event occurs only in “Inproc mode”...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...
What will be printed as the result of the operation below: main() { char *ptr = " Cisco Systems"; *p...
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...