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

11 – HOW TO RETRIEVE TEXT DATA

Oracle provides one default table and named as DUAL, It has got only  one column as DUMMY and data type is varchar2 (1), This table will be used to handle memory variables, temporary calculations and non-stored data of regular tables, Developers will use this table for testing much syntax, We shall try to use this table for testing the formatting, retrieving, various text data conversions and few of the Oracle functions etc,

Let us assume there are two data such as 'cash account'  and 'sales account'  are stored in the table of LEDGER-MASTER under the column of Ledger-name, How it can be stored in the table will be seen in the later chapter,

"select" is the key word to be used for picking

data's    as   "create   command"   a   followed   with

<<column-names>> (the data needed against column names) and the location need to be specified as "From" and the database obJect, The syntax is