Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vishal b. patel
1. Below SP apply for all records of the Table
UPDATE <table name> SET <column name>=<new value>
----------------
2. Below SP apply for those records which are match with
the <condition>...
UPDATE <table name> SET <column name>=<new value> WHERE
<condition>
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the use of parfile option in exp command.
Is insert autocommit in oracle?
What are the different types of modules in oracle forms?
Can you create a synonym without having a table?
How many data types are supported?
Difference between the “verify” and “feedback” command?
Differentiate between translate and replace?
How to drop an existing view in oracle?
How to create a table index in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to loop through a cursor variable?
How to start a specific oracle instance?
What is ASM (Automatic Storage Management) in Oracle?
How to see the table columns used in an index?
What is define in oracle?
