Answer / chandra shekher

truncate command will remove the table and again recreate
the table.
drop command will remove the table permanently from the
database.


Function must return a value where as stored procedure may
or may not return a value.
Function can return only one value where as stored
procedure can return multiple values.
Function can be used in sql query where as stored procedure
cannot be used in sql query.
Function is used to compute a value where as stored
procedure can be used to perform a task

Answer / rakesh

The Main Difference Between DELETE & TRUNCATE Are :-

[1] DELETE - is a DML Command & TRUNCATE - is a DDL Command

[2] After DELETE - can rollback the Records & After TRUNATE
- cannot rollback the records

[3] In DELETE Command you can give the conditions in WHERE
Clause & In TRUNCATE you cannot give conditions

[4] After using DELETE Command The memory will be occupied
till the user does not give ROLLBACK or COMMIT & After using
TRUNCATE Command The memory realeased immediately

Answer / srilekha

TRUNCATE:it will delete all the records at a time but not a
stucture.
DROP:it will delete the table permanently from database;
PROCEDUE:it may be return value,it will not used in sql
queries
FUNCTION:it returns a value,it will used in sql queries

Enlist the characteristics of pl/sql?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What are the features of pl sql?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

How can I make sql query run faster?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

How do I create an index in word?

0 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

How exception is different from error?

0 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---

What is sql profiling in oracle?

0 Answers  

---