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 left join example?

494


How can I get the number of records affected by a stored procedure?

565


What do you know by pl/sql cursors?

556


write an sql query to find names of employee start with 'a'? : Sql dba

573


Can we perform dml on view?

548






define data blocks ? : Sql dba

540


What is the purpose of normalization?

531


What is cursor and why it is required?

548


Why do we use joins?

558


What is multiple columns?

567


How many types of primary keys are there?

524


how can we know the count/number of elements of an array? : Sql dba

566


What is parameter substitution in sql?

519


Does asenumerable execute the query?

591


What language is oracle sql developer?

502