Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5330 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nageswararao.k
update <table_name> set
(<colname> <condition>)[where<condition>];
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / irshad ahmad
SQL> UPDATE table_name SET column1=value,
column2=value2,...
[WHERE condition];
for Example:-
Sql> UPDATE customers SET address = ‘250 Azad Road’ WHERE
customerid = 4;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sudhakar
update <table-name> set column-name<condition> where <condition>
ex:
update dept set desg='manager' where deptid=111;
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain compound trigger in oracle?
What are the attributes of the cursor?
How to view the dropped tables in your recycle bin?
What is set operator oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
26. Display the earliest shipping date in the format: DD/MON/YYYY
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is clustered table in Oracle?
What is the difference between normal and corelated subqueries?
what is analyze command ? what kind of statistics does it generate?
Oracle General 
