A
Q. In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.
The INSERT,UPDATE,DELETE statements have the out bind variables. They are bulk binded with the RETURNING BULK COLLECT INTO clause of EXECUTE IMMEDIATE.
You must be Logged in to update hint/solution
Q. STRICT_ALL_TABLES turns on stricter checking of data values.
Q. Which statement upgrades the database directory name encoding?
Q. What is the size of the BIT type?
Q. The functions in Perl DBI called?
Q. Which privilege must be given to the database to create a stored function or procedure?
Q. Which of these is a stored program associated with a schedule?
Q. Which of the following is not a numeric function?
Q. Which clause is used to “Filters out unwanted data”?
Discusssion
Login to discuss.