And for your Information, Oracle is going to have LIMIT version of MYSQL (and some other DBs ) in the for of OFFSET .. ROWS clause form the next...
Is it SQL/PL SQL specific question. If not move to the corresponding section.
The Decode also works fro the same situation. Try with with rec as ( SELECT 94 no,'CP' lvl,'Chemistry' subject from dual union SELECT...
Re: Need help with a cascading case when clause inside a merge inside a stored proced Also you can get nice example HERE on using multiple CASE...
It is slightly difficult to understand, but still achievable. try the following code. SQL> select * from xtest; X Y XSTR ---...
No need for PL/SQL routine, just group by will do the trick. SQL> SELECT * FROM REVENUE; REP_CODE T_DATE REVENUE OFFIC ----------...
Welcome to Club Oracle !!! Btw, I was there in Peru (your neigbouring country) for one of our telecom project. It was one of the nicest place I...
Coool. Could you please post your working script here so that people facing the same issue can refer your script in future. That is what the this...
Also please find this link to know how to deal with sys refcurcursor returned from the called procerdure.
Re: Using a Record, nested table and table by index as Parameter to a Procedure The following code explains how to pass the nested table to...
@ Hamza, Index is just one of the many things you have to take care to solve the perfomance issue.
This can be using the sys refcursor also as given below. CREATE OR REPLACE TYPE AS OBJECT ( EMPNO NUMBER (4), ENAME VARCHAR2...
Nice explanation, David . Hats off :hurray
Pivot query in Oracle 11g might help you. somthing like below (not tested) with rec as (select to_date('01012012','DDMMYYYY') dt...
OP wants the "99999" in COMPANY and OFFICE is always first through columns are ordered in ascending order. Though the expected pattern is...
Btw, Why do yopu want to run the report from PL/SQL? I think , it will better if you schedule the job in Unix directly or using some...
Just have a look at this article . And you can even think of cursor with parameter
This can be done with LAG() also. WITH dummy AS ( SELECT 'N123456' AS Id, 30 AS units, 45 AS dollars FROM DUAL UNION SELECT...
Dwanil might have intended as below. WITH dummy AS ( SELECT 'N123456' AS Id, 30 AS units, 45 AS dollars FROM DUAL UNION SELECT...
There is another query without using Regular expression. SQL> with yr as ( select 2012 yy 2 from dual ), 3 dt as (select...