the below did work fine:
execute immediate 'select hospital_id||to_char(trnx_date,'||'''||mmddyyyy||'''||')||patient_case_type from SJHS_ADT_ACT_TRXMST_BAK2 ' into x;
this executed successfully with teh MMDDYYYY format however, the result seems to
be strage with a single pipe:
The result is:
Actually the pipe should not be there, it should be: SJHS09102004ER
what couldbe the reason.
David Sharples <firstname.lastname@example.org> wrote:
the semi colon goes after the final ' in the
Plus that query is a little silly anyway
On 1/24/06, raja rao <email@example.com> wrote:
when the below is run i am getting the error. can someone help me :
execute immediate ' select sysdate from dual ;'
Ring in the New Year with Photo Calendars
. Add photos, events, holidays, whatever.