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
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What do you mean by group by clause?
How to enter a new row into a table interactively?
What is the maximum number of triggers that can be applied to a single table?
What is procedure overloading in oracle?
How do I start tns listener?
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.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Is a rollback possible to any savepoint?
How to omit columns with default values in insert statement in oracle?
What is the difference between truncate & delete command?
What are the attributes of cursor?
What happens to indexes if you drop a table?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
