|
|
Re: Is it possible To declare a variable dynamically? [message #304139 is a reply to message #304135] |
Tue, 04 March 2008 04:26   |
rangan.s
Messages: 75 Registered: February 2008 Location: chennai
|
Member |
|
|
I AM HAVING ONE TABLE WITH TWO COLUMNS ONE IS CONTAINING THE NAME OF THE TABLE ANOTHER IS CONTAINING CORRESPONDING COLUMNS USING COMMA SEPARATED I WANT TO SPLIT OF THOSE COLUMNS FOR THE REPECTIVE TABLE
WE I HAVE ONE FUNCTION TO SPLIT THE COMMAS NOW I WANT TO WRITE INTO TEXT FILE.
I AM USING FIRST CURSOR TO SPLIT UP
SECOND CURSOR TO WRITE INTO FILE
FOR THE SECOND CURSOR I NEED TO GET COUNT OF VARIABLE FROM THE
FIRST CURSOR AND I WANT TO DECLARE ALL VARIALRES AS VARCHAR2(4000);
|
|
|
|
|
Re: Is it possible To declare a variable dynamically? [message #304357 is a reply to message #304144] |
Wed, 05 March 2008 00:15   |
rangan.s
Messages: 75 Registered: February 2008 Location: chennai
|
Member |
|
|
I have one table say tab_det having two columns
Tab_det
---------
Tab_tablename varchar2(50),Tab_tablename varchar2(50)
Select * from tab_det;
Tab_tablename ---> Tab_tablename
-----------------------------------------------
Emp ---> empno,empname,dept
Emp_acct ---> empno,accno,accname,age
I want to split the each column name from <Tab_tablename > because it contains all the
Column name with comma separated and as a single value
I want to split the column name for each < Tab_tablename> Corresponding to
< Tab_tablename>
And I want to pass the column names dynamically and the output need to be written into the File
The Required Output In File
Empno empname dept
1 aaa cs
2 bbb ec
3 ccc ec
Empno accno accname age
1 12 aaa 34
2 13 bbb 36
3 14 ccc 38
4 14 ddd 40
|
|
|
Dynamic Variable Declaration how to do ? [message #304358 is a reply to message #304133] |
Wed, 05 March 2008 00:17   |
rangan.s
Messages: 75 Registered: February 2008 Location: chennai
|
Member |
|
|
I have one table say tab_det having two columns
Tab_det
---------
Tab_tablename varchar2(50),Tab_tablename varchar2(50)
Select * from tab_det;
Tab_tablename ---> Tab_tablename
-----------------------------------------------
Emp ---> empno,empname,dept
Emp_acct ---> empno,accno,accname,age
I want to split the each column name from <Tab_tablename > because it contains all the
Column name with comma separated and as a single value
I want to split the column name for each < Tab_tablename> Corresponding to
< Tab_tablename>
And I want to pass the column names dynamically and the output need to be written into the File
The Required Output In File
Empno empname dept
1 aaa cs
2 bbb ec
3 ccc ec
Empno accno accname age
1 12 aaa 34
2 13 bbb 36
3 14 ccc 38
4 14 ddd 40
|
|
|
|
|
|