Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5508 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 |
What types of joins are used in writing subqueries?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
what is query and types of query
Does facebook use oracle?
How to write text literals in oracle?
What is self-referential integrity constraint ?
Explain joins in oracle?
How do I start tns listener?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what's query optimization and without use of IN AND Exist can we get another way data from query
Oracle General 
