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
List out the components of logical database structure of oracle database.
How to use subqueries with the exists operator in oracle?
What is null value in oracle?
How to convert characters to numbers in oracle?
How do I recompile a procedure in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is the usage of analyze command in oracle?
Can we write insert statement in function in oracle?
How to assign data of the deleted row to variables?
What are the uses of synonyms?
How to create lov dynamically at runtime & attach to text field?
How to rename an existing table?
What is a nvl function? How can it be used?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is set verify off in oracle?
