if we give update table_name set column_name= default.
what will happen?

Answer Posted / kolla radha sri seshu

In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is user defined functions?

746


what are the join types in tsql? : Transact sql

755


What is difference between group by and partition by?

688


What is query optimization in sql?

723


Is full outer join same as cross join?

694






What are reports usually used for?

762


Name three sql operations that perform a sort.

789


how to rename an existing column in a table? : Sql dba

695


Can we delete column in sql?

767


Why having clause is used in sql?

726


What is rownum and rowid?

760


What is the difference between local variables and global variables?

800


What is %rowtype in pl sql?

693


How do you modify a trigger?

695


What is a constraint? Tell me about its various levels.

839