Explain the difference in execution of triggers and stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
What is schema in sql?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
Which is better cte or subquery?
How do you assign Construct the where clause without concatenating Field,value pairs?
Are stored procedures faster than queries?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.
What is a schema in sql?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
Can we create view in stored procedure?
What are the different types of constraints?
What are different methods to trace the pl/sql code?