Answer Posted / pramod janjirala

Two are same.Once the procedure is created and compiled ,it
is stored in database permanently.That's why it is called as
stored procedure.

What is error ora-12154: tns:could not resolve the connect identifier specified?

824

---

Is sql similar to python?

715

---

what is the difference between truncate and drop statements? : Sql dba

743

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6588

---

what is a control file ? : Sql dba

759

---

---

Can you have more than one trigger on a table?

707

---

define join and explain different type of joins? : Sql dba

736

---

What are the different types of constraints?

742

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

722

---

Why cross join is used?

824

---

What are the ways on commenting in a pl/sql code?

671

---

discuss about myisam index statistics collection. : Sql dba

695

---

What is pl sql collection?

694

---

What are the advantages of normalization?

788

---

What are keys in sql?

724

---