How do I insert a value in the database in upper case through Insert query?
Eq. INSERT INTO CUSTOMER_TBL VALUES ('a');
I want cappital 'A' to be inserted in the database. Please help.
Thanks,
Shruti
shrutikhungar
Last Activity: Mar 28 '07, 10:54 AM
Joined: Mar 24 '07
Location:
-
Thanks for bringing it to my notice. I have removed all the backtick character from my script file. Now also it is not working:(
Please suggest!
Thanks,
Shruti
-------------------------------------------
your reply:... -
Thanks for the reply!
I have modified the statements as per your suggesrtions:
Now it is giving some "./rulesEngine.ksh[21]: insert: not found" error. (name of the script file is "rulesEngine.ks h")
Please help!
echo "Enter the CUSTOMER ID, CUSTOMER NAME AND FM/CH:"
read cust_id;
read cust_name;
read fm_ch;
echo "**";
echo...Leave a comment:
-
Help Required: To run the attached UNIX script
Am getting this "SP2-0734:: not found" error while runnning following script. Please help.
echo "Enter the CUSTOMER ID, CUSTOMER NAME AND FM/CH:"
read cust_id;
read cust_name;
read fm_ch;
echo "**";
echo $cust_id;
echo $cust_name;
echo $fm_ch;
`sqlplus -s itm_odb/itm_odb<<EOF
set serveroutput on feedback off linesize...
No activity results to display
Leave a comment: