cursor c_supplier(no number) is select p.pid,p.pname,c.qty,p.unit_rate,(c.qty*p.unit_rate) "Total Price" from parts p,catalog c,supplier s where p.pid=c.pid and s.sid=c.sid and s.sid = no; ...

Can you chip in? This year we’ve reached an extraordinary milestone: 1 trillion web pages preserved on the Wayback Machine. This makes us the largest public repository of internet history ever ...

Hi, I am writing a rest api to call a PL/SQLstored procedure which returns a nested cursor. I am able to fetch the outer cursor very quickly using quertyToStream(). Can someone please help me in ...

I have a somewhat challenging SQL insert I need to accomplish in Oracle. The schema set up is not mine and it is a little weird. Here's a schema break down:<BR><BR>Table: agent<BR>agnt_id ...