Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66336 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / tripurari
truncate id ddl command .so it can't store data into redo log files, so it can't be rollback.
Delete is dml command so it contains data into log files so it may be rollback.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
What is an Oracle database Partial Backup?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
8. Supporting AP, AR and GL?
which one is currently in used software cmpanies.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Explain the payment term in ar. : oracle accounts receivable
can u give guidance abt packages of plsql
What is the difference between conversions and interfaces? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
