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

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

Question Posted / pgnath

4 Answers
9782 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.

Is This Answer Correct ?

6 Yes

0 No

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

Answer / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?

7 Yes

2 No

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

Answer / meher

If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

More SQL PLSQL Interview Questions

how to retrive only second row from table?

31 Answers IBM,

What is orm in sql?

0 Answers

how to get enames with comma seperated values by deptwise on emp table?

8 Answers

What is different between union and minus?

7 Answers Accenture, TCS,

how to create a database in oracle?please gve anser with example

1 Answers

What is the maximum rows in csv?

0 Answers

Can we interchange parameters in procedure while calling

1 Answers TCS,

What is a dynamic query?

0 Answers

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers IAS,

Can we join tables without foreign key?

0 Answers

what is External tables? explain with examples

2 Answers TCS,

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers TCS,

For more SQL PLSQL Interview Questions Click Here