Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65417 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathya
I just wanna add a point ..
while truncating a table both the structure and the datas will be removed. where as in Delete structure of the table ramains only the data in the table will be deleted.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
How to clone the database using RMAN back
types of receipts and detail desription about recipts and tables effected by receipts?
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.
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is the disk migration? what is the steps involved in oracle disk migration?
3. Steps in UAT?
where the dff data will be stored
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
what are the API of GL,PO,AP
what is the link between suppliers and banks in ap module in oracle apps? And also query?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is the difference between recovery and restoring of the oracle database?
