⟩ Explain an Integrity Constrains?
An integrity constraint is a declarative way to define a business rule for a column of a table.
An integrity constraint is a declarative way to define a business rule for a column of a table.
What is the difference between GL date and GL posted date?
At what stage is the subledger data posted to GL?
In GL there is no org id. So how do we differentiate the data from different operating units?
Explian rowid, rownum?what are the psoducolumns we have?
What is difference b/w stored procedures and application procedures, stored function and application function?
what is the starting oracle error number? what is meant by forward declaration in functions?
In a Distributed Database System Can we execute two queries simultaneously? Justify?
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
State the difference between implict and explict cursors?