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 are stored procedures in mysql?

763


What is the default isolation level in sql server? : Transact sql

753


when MSQL8.0 is in market

1774


Explain correlated query work?

792


what are the types of subquery? : Sql dba

768






What is trigger types of trigger?

720


What is the difference between inner join and left join?

735


Can we insert delete data in view?

726


What is nvl?

790


What does (+) mean in sql joins?

739


What is a dynamic query?

762


What is foreign key in sql with example?

681


What is a loop in sql?

744


What is sqlerrm?

713


Is ms sql is free?

712