What are pseudocolumns ROWID, ROWNUM, NEXTVAL and CURRVAL used for?
What will be an ideal response?
ROWID – to get system-generated address for a row that contains its exact location.
ROWNUM – to get row numbers of rows sorted by inline view.
NEXTVAL – to generate next sequence value.
CURRVAL – to view last generated sequence value
You might also like to view...
A good practice is to use the period (.) in places of spaces in a filename
Indicate whether the statement is true or false
A ________ is a prebuilt chart format that applies an overall visual look to a chart
A) chart layout B) chart style C) chart design D) chart template
The ____ quantifier specifies that zero or more of the preceding characters can match.
A. (&) B. (*) C. (#) D. (?)
A(n) _____ is a data validation rule that should be applied to mandatory data items.
A. sequence check B. range check C. asynchronic check D. existence check