Hi,
I am writing a dynamic query in a procedure.
the query returns a set of rows and cols..since its dynamic the no of columns keep changing
thats why i cannot store the result using INTO.
Can anyone help
khushbubhalla
Last Activity: Apr 4 '07, 09:37 AM
Joined: Mar 1 '07
Location:
-
output of dynamic query
-
Dynamic queries
I am writing a procedure in which i am using dynamic queries.
I am assigning the dynamic query to a variable and then executing the query .
but as in when the query grows i can t keep it in a variable.
so how shud i execute the query
another problem is the result set is a set of records , how can i get the records
My proc as of now
Create or replace procedure datacompare
(tab_name1... -
Prasing the column names
Hi I actually want to take the column names as input from the user.
column names wud be eneterd as a string seperated by commas n then i want to get each column name in a seperate variable. Please help me with this
Declare
TYPE t_char80array IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
Cols t_char80array;
ColNames Varchar2(10);
PosNext Integer;
Pos Integer;
Length Integer;
... -
Just An algo of wat i want to do and am not really sure how
Proc(tablename( to be compared) , columnnames(tha t need to be compared), Business keys (or saythe unique indexeshere its col2 and col3))
1) Do a record matching analysis
Find the no of records matching based on Business keys
that ll be done by putting a join some wat like this
select l.col2,l.col3,r .col2,r.col3,'T est' as TableName from testa l, proda... -
i want to make a procedure which takes the tablename,colum nnames as input.
from the system tables we somehow find the unique index on the table and then have generic joins on the same
i am not quite sure as to how will i come up with such a generic procedure.
I want a specific result set.Leave a comment:
-
The query that u have given gives me a very generic result.
I want a procedure which takes the table name and the column names as input
and the out put is more like a report from where i can identify wat is the problem
If i list all the columns in the query it will give me the entire record set
this doesn solve my purpose...Leave a comment:
-
Hi
I dont want a generalised result , the minus query lists out al the differences.
here say if i have
table a (Test)
col1(Pk) col2(Businesske y) col3(Business key) col4 col5
1 ABC XYZ 1 2
2 BCA XXX 5 6
3 AAA YYY 3 3...Leave a comment:
-
Hi
I dont want a generalised result , the minus query lists out al the differences.
here say if i have
table a (Test)
col1(Pk) col2(Businesske y) col3(Business key) col4 col5
1 ABC XYZ 1 2
2 BCA XXX 5 6
3 AAA YYY 3 3...Leave a comment:
-
Tables on which view is made
Is there a way to find the list of tables on which a view is made using system tables in oracle -
compare data between tables in test and production
how to compare data between tables and views row by row , column by column in the test and production environment
No activity results to display
Leave a comment: