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;

How subquery works in sql?

1126

---

Is primary key a clustered index?

1008

---

What are hotfixes and patches?

986

---

What is embedded sql what are its advantages?

1106

---

What is sql stand for?

1033

---

Can we insert in sql function?

1139

---

What is record in pl sql?

1138

---

How many primary keys can a table have?

1053

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2317

---

what is top in tsql? : Transact sql

1171

---

what are myisam tables? : Sql dba

1077

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1114

---

how to include numeric values in sql statements? : Sql dba

1145

---

What is db journal file?

1152

---

How much does sql certification cost?

1134

---