create table acct_to_print_bak as select BILL_DATE,ACCT_NO,STATUS_CODE,floor((ROWNUM-1)/N)+101 BP_PARTN_NUM,SYS_APPL_ID FROM ( select T1.BILL_DATE,T1.ACCT_NO,T1.STATUS_CODE,T1.BP_PARTN_NUM,T1.SYS_APPL_ID,T3.N from acct_to_print t1,inv_acct_bill_addr T2 ,(select ceil(count(*)/20) N from inv_acct_bill_addr) T3 where t2.bill_date='19-FEB-07' and t2.bill_date=t1.bill_date and t1.ACCT_NO=t2.ACCT_NO order by T2.postal_code ) T4; commit; truncate table acct_to_print; insert into acct_to_print (select * from acct_to_print_bak); commit; drop table acct_to_print_bak
*
ERROR at line 1:
ORA-00911: invalid character
The error show for semicolon,
its still not go to new line afteruse the command you give,any suggestion
bro thanks bro,
its works find,
acuatly i put the /g same line after i put in new line it works
thanks man
but i not much understand the sed commands,i new in it
will learn soon with your help
thanks man
hi bro need your help again,
this path /rnmucdr/ednms05/ken/template/xMNBDF070_Script.sql
set echo off;
set head off;
set feedback off;
set pagesize 0;
spool $OUTPUTFILENAME;
select to_char(bill_date,'yyyymmdd')||rpad(acct_no,14)||withhold_code||to_char(withhold_qty,'fm009') from invoice where sys_a
ppl_id = '$SYSAPPLID' and bill_date = '$BILLDATE' and withhold_code is not null and withhold_qty > 0;
spool off;
exit;
since this have pipe | is there so i added pipe as bellow
i want replace all the variables, the i want the file as it is,i dunt want the [database] and [parameters] join in one sentences
can u help me,i want go to new line after found new line but now it go to new line after found ;
can you help me thanks
[/code]
is there any other way like tht day you teach me using eval
because if some other user edit the template files there, i need they only put variable and not the command line
maybe they add ${BILL_PERIOD} in templete
so this excuteable file they just need to add
BILL_PERIOD=01
something like that
can i do like that,so if we know how to get to new line for that variable i think problem solve..
Keep your variables in a separate file and use the following code to create sed command. Make sure that variables in rnmucdr/ednms05/withold_accts/template/FNBDPCF2 are enclosed in braces
str="sed '"
while IFS="=" read x y
do
str=${str}"s,\${$x},${y},;"
done < file
str=${str}"' rnmucdr/ednms05/withold_accts/template/FNBDPCF2 >test"
echo ${str} | sh