Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67114 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / bhupat
Truncate Statement:
1.Deletes all the rows from the table.
Delete Statement:
1.Delete a specific row.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between negative and positive adjustments : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
what is the link between suppliers and banks in ap module in oracle apps? And also query?
how to write customizations in po
types of receipts and detail desription about recipts and tables effected by receipts?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
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?
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.
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
Explain how to close periods in ar. : oracle accounts receivable
Can we modify approve purchase order?if yes what is navigation?
how to replace not in with not exist?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
