Search Results

thanks Yoda but the second sql should execute based on the condition when satisfied else not..something like this

variable1=$ echo "set feed off
set pages 0
select status from t1 where id = 10;...

tried that ..still not working..

i am trying this but it is not working..it is only printing first sql session output.. please advise..

variable1=$ echo "set feed off
set pages 0
select status from t1 where id = 10;
exit" |...

I am writing the following script to create the file v_out.txt.

sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET...

Thanks Ravinder , solution 1st worked perfectly.

hi ,
i have a file test.dat which contains following data.

test.dat
XY|abc@xyz.com
XY|abc@xyz.com
ST|abc@xyz.com
ST|abc@xyz.com
ST|XYZ@abc.com
FK|abc@xyz.com
FK|STG@xyz.com...

V_FILE_NAME is a parameter whose value is "STG" but there are 8 question marks i.e ???????? which is a date in (yyyymmdd)..
but when i run this shell script it is looking for STG????????.dat file...

Hi,
I came across a shell script that contains a statement like,

export v_list=$( ls -1 ${AB_TEST}/ABC/${V_FILE_NAME}????????.*.dat )

what does ??? mean?

hi,

i am using below query to generate the fixed length txt file. this sql is being called from shell script.
This is supposed to be a fixed record file with the below definitions. There must be...

sorry i am not able to get your point..
i want to use this sql query inside the script ...pls let me know how can i do this..


select case when sum(case when table_row_count = input_record_cnt...

hi,

could any one tell me what is the issue with the below script.
i am gettin syntax error near unexpected token `from'
i have added the small piece of code highlighted in italics -underline...

hi ,

the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of...

If you select the text in your email client and set the font to, say, "Courier New" or "Consolas" or "Terminal" etc. then you will be able to see it properly formatted in your email body. Check the...

Sorry i am new to his forum , will take care of CODE tag next time..

i tried below query using 'colsep' and got the correct formatting in the commandline but when i receive the same out put in...

hi ,

thanks i am able to get the desired output but only issue is with the formatting below since the source_name length varies .


LOAD_DATE SOURCE_NAME COUNTS_MATCHING
01-JAN-17 SRC_14568 ...

hi ,

thanks for reply . please let me know if more info is required,

1) About the part of your logic in blue, did you mean:
a) Send an email with subject line: "warning: load counts mismatch...

hi ,

i have written below piece of code to meet the requirement but i am stuck in the logic here.

the requirement are:
1) to send the sql out put to email body with proper formatting.
2) if...