New answers tagged sqlplus
What OS are you using? Check what the environment ORACLE_SID is set to. Change it to the existing one and you won't be needing to specify the connection string anymore.
It is likely that your to_char() date format doesn't match your database default format so it can't automatically convert it back to a date during the update. Try something like the following: update subs_change set valid_to=to_date('$last_update_time','mm/dd/yyyy hh24:mi:ss') where sub_id='$1' and value='$issue_rate_plan'; This will explicitly convert ...
You should not put SET and SELECT in the same line, they are seperate commands. For example this works: $ alias db='sqlplus -s user/password' $ db <<< 'set heading off set timing on set echo off select * from dual;' X Elapsed: 00:00:00.00 If you insist on using a one-liner, you could try this: $ echo -ne 'set heading off\nset timing on\nset ...
Top 50 recent answers are included