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, 5273👍, 0💬
Popular Posts:
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statement...
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...
How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...