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
What is the difference between sharding and partitioning?
What is the difference between hot backup and cold backup in oracle?
What is control file used for?
How many types of auditing in Oracle?
What is Trigger in Oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are a collation and state the different types of collation sensitivity?
What language does oracle use?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is ASM (Automatic Storage Management) in Oracle?
What are the arithmetic operations?
What is oracle datasource?
Explain constraining triggers.
What happens to indexes if you drop a table?
How to use regular expression in pattern match conditions in oracle?
