Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

img3.png Login  to  APEX  usin workspac 1 schema 1 password

img3.png      Click SQL Workshop

 

img3.png      Click SQL Command

 

This will display a new page and it may be called as SQL Command Editor. The SQL command editor horizontally split into two portions. Upper portion is used for giving SQL Command and the bottom portion will display the results derived out of SQL Statements 1 commands.

Having created a table from excel data, if we want to see the structure of the table and the contents, give command as DESCRIBE << table name >>. In our case we have already created Account_Head_Master,

hence

 

Describe account_head_master

 

Or

 

desc account_head_master

 

may be given SQL Prompt or in the SQL Command window. If we use this command in  SQL Command Window, our  sql commands need not be ended with semi-colon (;) otherwise generally sql command should