Explain what is a DUAL table, where is it stored, and what is it useful for? Give an example of its use.
What will be an ideal response?
A DUAL is a table with one column called DUMMY and contains one row with
a value 'X'. It is automatically created by Oracle along with the data dictionary.
DUAL is stored in the schema of the user SYS, but is accessible by the name
DUAL to all users.
DUAL is useful for computing a constant expression with the SELECT
statement. Because DUAL has only one row, the constant is returned only once.
e.g. SELECT LENGTH ('My String') FROM DUAL;
You might also like to view...
Which of the following is correct for font metrics?
a. height = descent + ascent + leading. b. The amount the character dips below the baseline is the ascent. c. The amount the character can be above the baseline is the leading. d. The amount the character rises above the baseline is the descent.
The who utility (Sobell, page 71) lists the users who are logged in on the sys- tem. Append the output (Sobell, page 142) of the who utility to the ls.out file you created in the previous step. Display the augmented ls.out file using cat.
What will be an ideal response?