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 data block in Oracle?
What is pragma autonomous transaction in oracle?
Explain the use of tables option in exp command.
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain index?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a data dictionary and how can it be created?
What is the difference between PFILE and SPFILE in Oracle?
Explain the use of rows option in exp command.
How do I reset a sequence in oracle?
What privilege is needed for a user to connect to oracle server?
what happened to the global index when I truncate the data in one of the partition?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Write a trigger example in oracle?
Explain the use of rows option in imp command.