Answer Posted / chand
THE BELOW QUERY DELTES A ROW BASED ON A CONDITION
DELETE FROM <TABLE_NAME>
WHERE <COL_NAME>=<CONDITION>
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the use of full option in exp command.
How to create a new view in oracle?
What is a tns file?
what are archived logs?
How to retrieve the count of updated rows?
Differentiate between function and procedure in oracle.
How would you change old and new values in an insert, delete and update triggers?
How to best split csv strings in oracle 9i?
In what script is snap$ created? In what script is the scott/tiger schema created?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Can group functions be used in the order by clause in oracle?
What are the roles of dba?
What happens to the current transaction if the session is ended?