Can we insert in sql function?



Can we insert in sql function?..

Answer / Pankaj Kumar Chauhan

Yes, you can perform INSERT statements inside SQL functions using the `INSERT INTO` statement. However, you should be careful not to make the function perform DML operations directly on tables, especially if the function is used as part of a trigger.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,


How do I view output in sql developer?

1 Answers  


Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,


Why do we use procedures in pl sql?

1 Answers  


what is a database lock ? : Sql dba

1 Answers  


what is hash join

1 Answers   NCR,


What is type and rowtype in pl sql?

1 Answers  


What are the different dml commands in sql?

1 Answers  


What is the best free sql database?

1 Answers  


how to add a new column to an existing table in mysql? : Sql dba

1 Answers  


Explain autonomous transaction.

1 Answers  


What are sql commands?

1 Answers  


Categories