If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
4 8717Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
TCS,
1 2490Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
3 7983
What is the usage of nvl function?
Do stored procedures prevent sql injection?
How do I truncate a word?
What problem one might face while writing log information to a data-base table in pl/sql?
How to convert comma separated string to array in pl/sql?
Why join is faster than subquery?
Write a query to find the names of users that begin with "um" in sql?
How to select 10 records from a table?
what is the difference between nested subquery and correlated subquery?
Why stored procedure is better than query?
How many triggers can be applied to a table?
What is compiled query?
What is difference between procedure and trigger?
How do you change a value in sql?
How to add a column ‘salary’ to a table employee_details?