what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / guest
Truncate command cannot be rolled back while Delete can be
| Is This Answer Correct ? | 178 Yes | 18 No |
Post New Answer View All Answers
Explain the process of recievables in oracle financials. : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
What view would you use to determine free space in a tablespace?
How to clone the database using RMAN back
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is Tax Categories?
What is the sql query to find the employee who has Nth maximum salary?
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is an Oracle database Partial Backup?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
How do you create a credit note against an invoice? : oracle accounts receivable
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