![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| sqlplus: command not found | Tlg13team | HP-UX | 4 | 01-24-2008 08:57 PM |
| How to check sqlplus command is successfull or not in HP UX? | plaban.rout | HP-UX | 5 | 11-20-2007 06:48 AM |
| editing sqlplus id@passwd in multiple scripts, users and directories | Helmi | UNIX for Dummies Questions & Answers | 8 | 05-09-2007 01:02 AM |
| SQLplus in Shell scripts | trupti_d | Shell Programming and Scripting | 12 | 03-16-2007 09:46 AM |
| Use sqlplus command | Nel | Shell Programming and Scripting | 3 | 09-12-2006 02:22 AM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
sqlplus and sh scripts (to_char command))
Hi evrybody!!!!
I have a problem with this shell script INICIO=$(sqlplus -s user/user@db1 << END | awk '{printf $1}' set head off set feed off select to_char(min(create_dt) , 'HH24') from table_name where trunc(create_dt)=trunc(sysdate-2); END) I want to recover, in INICIO, the min time from a group of records but the problem is I am using the to_char command with (') symbol, as you see in the example 'HH24'. With Oracle it works OK, directly by sqlplus. But with sh scripts it doesn't. I tried with '' double single quoted or " double quoted and \' but the problem continues, could somebody have an advice to solve the problem? Thanks José |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|