Answer Posted / jyoti ranjan samal
Update table name
set <column name>= New value
where <condition>
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can select statements be used on views in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
When do I need to use a semicolon vs a slash in oracle sql?
What is a system tablespace and when it is created?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a data dictionary and how can it be created?
What is define in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is enter substitution variable in oracle?
Explain rename?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to define and use table alias names in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
Explain user account with reference to oracle.
Explain the use of compress option in exp command.