Is it possible to remove child records without removing master table records...the two having pk,fk relationship?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between rename and alias?

0 Answers  


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  


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?

0 Answers  


i don't want the message as 14 rows updated just it should update what it will do

4 Answers  






What is dynamic query?

0 Answers  


what are all the common sql function? : Sql dba

0 Answers  


Why select is used in sql?

0 Answers  


What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  


What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,


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?

1 Answers  


What are different types of triggers?

0 Answers  


Categories