Can we call procedure in select statement?
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of <> sql?
What are stored procedures used for?
Can We write bulk collect statement in triggers?
What is sql*plus?
What is inner join in sql?
What is sql indexing?
How do you rank data in sql?
define data blocks ? : Sql dba
Is drop table faster than truncate?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What is a stored procedure in sql with example?