Answer Posted / mohana sundaram

create or replace procedure p_name(p_no in out number)
is begin
{
executable statement
}
end p_name;
/

How do you write a complex sql query?

1006

---

Define concurrency control. : Transact sql

1102

---

How do we use distinct statement? What is its use?

975

---

What is data control language?

946

---

What programs use sql?

940

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

---

How do I create a sql database?

947

---

What is the difference between drop and truncate commands?

996

---

What is function and procedure in pl sql?

969

---

How do I run a program in pl sql?

950

---

What has stored procedures in sql and how we can use it?

1013

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

---

What is sql and how does it work?

1086

---

What are the two characteristics of a primary key?

926

---

What is meant by truncate in sql?

1002

---