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

its given in pl sql block.what will hapen?

Answer Posted / selvan

It shouldn't occured any error.
It'll update but value is empty(i.e columns having empty
values)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a record in a database ? : Sql dba

566


Explain cursor types?

578


What does where 1/2 mean in sql?

529


What is the difference between function, procedure and package in pl/sql?

557


how to include numeric values in sql statements? : Sql dba

557






What is a left join?

508


Where is pl sql used?

516


What is anonymous block in sql?

638


What is sap sql anywhere?

535


What is the advantage of index in sql?

536


Is sql better than excel?

517


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

553


How do I turn a list into a table?

505


What is the process of debugging?

549


What are the two types of exceptions in pl/sql?

543