How To Run SQL*Plus Commands in SQL Developer?

by **Micheal** Tue Jan 19, 2010 8:26 pm

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:
Go to SQL Worksheet - SQL statement area
Enter DESCRIBE USER_USERS
Press F9 to run the command
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.