if a table is getting updated what happens if a function is
called from sql query?

Answer Posted / sumit

No function can be called from a sql query if the function
has dml statements inside.

Is This Answer Correct ?    16 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you do multiple joins in sql?

728


What are commit, rollback, and savepoint?

738


Is foreign key mandatory?

714


how many sql ddl commands are supported by 'mysql'? : Sql dba

702


What is the difference between inner join and outer join?

712






How do I count rows in sql query?

688


how tsql statements can be written and submitted to the database engine? : Transact sql

712


how to return query output in html format? : Sql dba

850


Can we use views in stored procedure?

705


How do you exit in sql?

815


Can we write ddl statements in functions?

796


What are all types of user defined functions?

736


What are aggregate functions in sql?

839


What are the triggers associated with image items?

794


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

781