 Related Questions Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled Latest Answer : DELETE is a logged operation on a per row basis. This means that the deletion of each row gets logged and physically deleted. You can DELETE any row that will not violate a constraint, while leaving the foreign key or any other contraint in place. ... Latest Answer : Hi All,INSTR function finds the numeric starting position of a string within a string.As eg.Select INSTR('Mississippi','i',3,3) test1, INSTR('Mississippi','i',1,3) test2, ... Latest Answer : Can anyone tell me the diffrence between CHAR and VARCHAR2(1)...why do we use char when we can give it as varchar2(1)..????Thanks in advance.. ... TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database Latest Answer : Truncate is faster than delete as it does not generate rollback segment. ... INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character Latest Answer : substr is used to get a part of given string,instr is used to search a charcter in the given string.select substr(ename,1,3) three_charename, instr(ename,'A',1) a_present_at from emp; ... What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ? CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2. Latest Answer : Inner jon Or equi join is The query that retrives the rows that exact match using (=) sign in where clause ... Latest Answer : View is a subset of data derived from tableupdate of data in table we can see in in viewbut update in view can not see in table. ... Latest Answer : materialized view is physical duplicate data in a table view is logical representation of table ... Latest Answer : Commit to like making all the changes permanently in the Server...But in case of GO statement which is available In SQL Server(TSQL), the set of steps before the GO statement is complied at once and sent to server...I mean from the beginning of the script ... Read Answers (5) | Asked by : Manu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
