Run SQL*Plus Commands in SQL Developer in Oracle

Q

How To Run SQL*Plus Commands in SQL Developer in Oracle?

✍: FYIcenter.com

A

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.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 130👍, 0💬