⟩ What is sql BREAK?
BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.
BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.
What is an integrity constraint?
Where the integrity constraints are stored in data dictionary?
How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?
Difference between SUBSTR and INSTR?
What is CYCLE/NO CYCLE in a Sequence?
What are the advantages of VIEW?
Which of the following is not a feature of a cursor FOR loop?
How will you activate/deactivate integrity constraints?
If a view on a single base table is manipulated will the changes be reflected on the base table?
What happens when rows are found using a FETCH statement?