1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / pgnath

Answers were Sorted based on User's Feedback



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

Answer / mano chinna

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

What is numeric function sql?

0 Answers  

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,




how do you know if your mysql server is alive? : Sql dba

0 Answers  

what is a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers  

how to see the create table statement of an existing table? : Sql dba

0 Answers  

What are different methods to trace the pl/sql code?

0 Answers  

What is varray in pl sql?

0 Answers  

How do you bind variables in pl sql?

0 Answers  

Explain the commit statement.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories