Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Run SQL*Plus Commands in SQL Developer

By: FYIcenter.com

(Continued from previous topic...)

How To Run SQL*Plus Commands in SQL Developer?

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.

(Continued on next topic...)

  1. What Is Oracle SQL Developer?
  2. What Operating Systems Are Supported by Oracle SQL Developer?
  3. How To Download Oracle SQL Developer?
  4. How To Install Oracle SQL Developer?
  5. How To Start Oracle SQL Developer?
  6. Is Oracel SQL Developer written in Java?
  7. How To Connect to a Local Oracle 10g XE Server?
  8. How To Connect to a Remote Server?
  9. How To Run SQL Statements with Oracle SQL Developer?
  10. How To Export Your Connection Information to a File?
  11. How To Run SQL*Plus Commands in SQL Developer?
  12. How To Work with Data Objects Interactively?
  13. How To Get a CREATE Statement for an Existing Table?
  14. How To Create a Table Interactively?
  15. How To Enter a New Row into a Table Interactively?
  16. What Is the Reports View in Oracle SQL Developer?
  17. How To Get a List of All Tables in the Database?
  18. How To Get a List of All User Accounts in the Database?
  19. How To Get a List of All Background Sessions in the Database?
  20. How To Create Your Own Reports in SQL Developer?
  21. How Many File Formats Are Supported to Export Data?
  22. How To Export Data to a CSV File?
  23. How To Export Data to an XML File?
  24. How To Create a Procedure Interactively?
  25. How To Run a Stored Procedure Interactively?
  26. How To Run Stored Procedures in Debug Mode?
  27. How To Assign Debug Privileges to a User?
  28. How To Set Up Breakpoints in Debug Mode?
  29. What Do You Think about Oracle SQL Developer?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...