Answer Posted / madhav

create or replace procedure proc_in_out
(p_empno in number,p_ename out varchar2)
as
begin
.......
.......
end;
execute proc_in_out(7369,p_ename)--out parameter can't
like this

declare
v_ename varchar2(10);
begin
proc_in_out(7369,v_ename);
end;

What do you think about pl/sql?

948

---

What is self-join and what is the requirement of self-join?

1088

---

Is a foreign key always unique?

883

---

What is a pragma statement?

1201

---

How do you identify a primary key?

1011

---

What is meant by truncate in sql?

1004

---

Write the alter statement to enable all the triggers on the t.students table.

1067

---

How do I clear the screen in sql plus?

982

---

What is the difference between clustered and non-clustered index in sql?

957

---

Is nosql faster than sql?

970

---

What is the default isolation level in sql server? : Transact sql

962

---

How do I send sql query results to excel?

1005

---

What are the query optimization techniques?

886

---

What are predefined functions in sql?

977

---

What is the command used to fetch first 5 characters of the string?

1334

---