Answer Posted / deepu

functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.

What is truncate oracle?

971

---

What is a cognitive schema?

961

---

What is system tablespace?

1094

---

How to convert raw data type into text in oracle? Explain

993

---

In the oracle version 9.3.0.5.0, what does each number shows?

1297

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---

What is a trigger oracle?

1084

---

what is the scenario where you take the database to NoArchivelog mode?

2329

---

How to retrieve data from an cursor to a record?

1102

---

What is an anonymous block?

1241

---

What is not equal to in oracle?

996

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

---

What is a sub query and what are the different types of subqueries?

1124

---

How to commit the current transaction in oracle?

1119

---

What are the attributes of the cursor?

1002

---