Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is the difference between rename and alias?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
What is mutating trigger?
i don't want the message as 14 rows updated just it should update what it will do
What is dynamic query?
what are all the common sql function? : Sql dba
Why select is used in sql?
What is the difference between functions, procedures, and packages in pl/sql?
What is a 'instead of trigger'?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
What are different types of triggers?