diff between DELETE and TRUNCATE?.
- 14 Answers
- 19797 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / manoj.oracle
Delete command is a dml command
truncate command is a ddl command
Delete command has a where clause.
truncate hasn't where clause.
Delete doesn't release memory space(means we can rollback
the deleted rows)
truncate releases memory space(means we can't rollback)
By using synonym we can delete a rows(Delete command).
By using synonym we can't delete a rows(Truncate command).
| Is This Answer Correct ? | 29 Yes | 0 No |
Post New Answer View All Answers
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are the execution control statements in oracle?
How to create a stored program unit?
Explain parameter file in oracle.
What is proxy method?
Does oracle database need java?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Is postgres faster than oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is index in Oracle?
When do we use group by clause in a sql query?
What is using clause and give example?
How to see free space of each tablespace?
How to view the data files in the current database?
