Search results for query: *

Thnx Guy, Instead 1st, I created local tables using opequery and then created the view with the case statement in SQL.

I am able to run the statement below SELECT * from openquery (Linkedname,'Select RPDOC AS InvoiceNumber, RPPST AS InvoiceStatus, SUM(RPAG) AS GrossAmount FROM F03B11 GROUP BY RPPST, RPDOC') But When I use the CASE ststement to filter the data further I get an eror message. SELECT *...

Mufasa, I am finally managed to make it happen :) I had to change your Matrix function a little to display the output the way I wanted. Cheers

Mufasa, In the select statement below I am not selecting the T_ROLLNO in the select statement, reason being I am only looking for the Dates and Amounts. When I do put in the T_ROLLNO in the select statement, I receive an error message. PL/SQL: ORA-00947: not enough values ------- BEGIN...

HI Mufasa, I some how got the Data to fill in a temp table. Then I used the matrix function to load the data into a local variable and displayed the info. But the ouput is as below in one single line through the variable...

Mufasa, Thanks for all the help But I am not getting anywhere with this. What you suggested, I am unable to apply to my Stored Procedure. You seem to have the knowledge but I am unable to implement the same. Lets try this one last time. In the query below the Roll No is not unique. SELECT...

Mufasa, My challenge is to run a Stored Procedure that would allow me to acess data which from the beginning has been SELECT rownum rn, Roll_NO, Amount, Due_date FROM TABLE.DBLINK where ROLL_NO = '123456' and (extract(year from due_Date)) = EXTRACT(YEAR FROM sysdate) and SUBSTR(ORIGIN,1,3)...

Hi Mufasa, Thanx for the help, It does solve half the equation. The other is to be able to extract Dynamic Query Output and store in the Table (embedded in a stored procedure). To make it simple I am running a stored procedure in which I am trying to call The select statement as below. But...

Thank you all for being so responsive to my queries. I have another one. I am trying to use a for loop to attain a single string into a local variable from a multiple rows with same Roll_NO. Is there an easier way to extract the rows to the string. I have a layout of the Table XYZ as below...

Thanx Mufasa, Thats exactly what I was looking for. I have another question Under the subject line " using For Loop to attain single string from multiple rows" Please look into that.

I am looking for a way to assign a Dynamic Output queried from a select statement with multiple rows into a Local table. SELECT rownum, Amount, Due_date FROM TABLE.DBlink where ROLL_NO = 'xyz' and (extract(year from due_Date)) = EXTRACT(YEAR FROM sysdate) and SUBSTR(ORIGIN,1,3) in...

Hey Tharg, Thanx for the concern but I got the issue related to the Parsing of a string figured out.

I have come accross a roadblock. I need to parse a string that is passed to a variable. I need to parse two seperate strings from one string to be compared. The 1st string to be parsed can have either 6,7,or 8 characters in the initial part of the string. The second is always constant to '5-4'...

I have come accross a roadblock. I need to parse a string that is passed to a variable. I need to parse two seperate strings from one string to be compared. The 1st string to be parsed can have either 6,7,or 8 characters in the initial part of the string. The second is always constant to '5-4'...