Visit The New, Modern Unix Linux Community

Search Results

Search: Posts Made By: vikas_trl
1,480
Posted By vikas_trl
If i use your code each row will go into one...
If i use your code each row will go into one array element. But how can i know how many columns are there in the sql query actually?

For example if we consider below row, how can i select col1,...
1,480
Posted By vikas_trl
Identifying columns individually in the query to...
Identifying columns individually in the query to load into array is the problem I see here. Because I need to pick some delimiter for identifying columns. I can not choose ',' or 'AS' as they are...
1,480
Posted By vikas_trl
Thanks for your reply. Shell is the...
Thanks for your reply.

Shell is the preferred. Because we are planning to use this script to work across multiple databases. But please provide PL SQL code also if you have any.
1,480
Posted By vikas_trl
Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns
Hello All,

I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to...
Showing results 1 to 4 of 4

 

Featured Tech Videos

All times are GMT -4. The time now is 05:41 AM.
Unix & Linux Forums Content Copyright 1993-2020. All Rights Reserved.
Privacy Policy