Search Results

Below Shell Script is for splitting the file.
#!/usr/bin/ksh
exec 1>/Temp/`basename ${0}`.log
exec 2>/Temp`basename ${0}`.err

SQLPLUS=""
PATH=""
no_of_rows="1"
file_name=new_file
if [ -f...

Yes ...I figured out this much. But not able to implement this logic. Could you please provide a sample code for this ..Thanks

Hi,

Consider a table column, which stores each page of a book in a seperate row.

Now, we have to save each of these rows(each page of a book) in a seperate unix file. We can use any naming...

I tried using the above script with no_of_rows = 4 for 4 output rows of sql. But it is still printing the first line of each row.

Also, in the sql file I'm using the below SET cmds, not sure...

The output file is filled with only the first line of each row. Remaining lines are not filled in the file.

Each row can be considered as a book page having multiple lines including new line character. Is there a possible way by using number of output rows as a unix script variable and then save them in...

Dear All,

I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql...