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 |
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
How do I view output in sql developer?
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?
what is a database lock ? : Sql dba
what is hash join
What is type and rowtype in pl sql?
What are the different dml commands in sql?
What is the best free sql database?
how to add a new column to an existing table in mysql? : Sql dba
Explain autonomous transaction.
What are sql commands?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)