What is different between TRUNCATE and DELETE?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > Oracle > General

✍: Guest

The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas DELETE is a DML statement.

2011-08-30, 3665👍, 0💬

What is the difference unescape() and escape()?
What is the difference unescape() and escape()? These are similar to the decodeURI() and encodeURI(), but escape() is used for only portions of a URI: <script type="text/javascript"> var myvalue = "Sir Walter Scott"; document.write("Original myvalue: "+myvalue); document.write("<br />e... 2011-08-23, 4620👍, 0💬

What is the difference of decodeURI() and encodeURI()?
What is the difference of decodeURI() and encodeURI()? Many characters cannot be sent in a URL, but must be converted to their hex encoding. These functions are used to convert an entire URI (a superset of URL) to and from a format that can be sent via a URI. <script type="text/javascript"> v... 2011-08-30, 4307👍, 0💬

What's Prototypes for JavaScript?
What's Prototypes for JavaScript? Objects have "prototypes" from which they may inherit fields and functions. <script type="text/javascript"> function movieToString() { return("title: "+this.title+" director: "+this.director); } function movie(title, director) { this.title = title; this.direc... 2011-08-23, 4242👍, 0💬

What does break and continue statements do?
What does break and continue statements do? Continue statement continues the current loop (if label not specified) in a new iteration whereas break statement exits the current loop. 2011-08-16, 4162👍, 0💬

How to create a function using function constructor?
How to create a function using function constructor? The following example illustrates this. It creates a function called square with argument x and returns x multiplied by itself. var square = new Function ("x","return x*x"); 2011-08-16, 4128👍, 0💬

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? 1000000 2011-09-05, 3947👍, 0💬

What is an UTL_FILE? What are different procedures and functions associated with it?
What is an UTL_FILE? What are different procedures and functions associated with it? The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files. It provides a restricted version of standard OS stream file input/output (I/O). Subprogram -Description FOPEN function-... 2011-09-13, 3762👍, 0💬

What is different between TRUNCATE and DELETE?
What is different between TRUNCATE and DELETE? The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas ... 2011-08-30, 3666👍, 0💬

What are between database triggers and form triggers?
What are between database triggers and form triggers? Database triggers are fired whenever any database action like INSERT, UPATE, DELETE, LOGON LOGOFF etc occurs. Form triggers on the other hand are fired in response to any event that takes place while working with the forms, say like navigating fr... 2011-09-13, 3461👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.