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

its given in pl sql block.what will hapen?

Answer Posted / manoj

It will fill the default value through out that column
by null

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the built in functions of sql?

757


Do prepared statements prevent sql injection?

691


What is Materialized View? In What Scenario we Use Materialized View?

8941


How to display the records between two range in Oracle SQL Plus?

870


How do I view stored procedures?

739






What is composite primary key in sql?

710


What are the types of join and explain each?

773


how to drop an existing table in mysql? : Sql dba

758


What is error ora-12154: tns:could not resolve the connect identifier specified?

826


What is sqlexception in java?

732


Differentiate between % rowtype and type record.

923


what is “go” in t-sql? : Transact sql

810


What are crud methods?

736


Is sql similar to python?

717


How many triggers can be applied to a table?

782