All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
86 views

Different output when executing script manually and via cron/jenkins job

I have a shell script which opens sqlplus and select some data from db containing chinese characters. When I execute it manually, the output contains those characters. When I do it via cron or jenkins ...
0
votes
1answer
249 views

unable to spool through shell(ksh)

I've written a shell script in which i've defined variables : Last_Month,last_date and first_date and i'm trying to execute the below sql from the shell : /app/oracle/product/10.2.0/bin/sqlplus -s ...
-1
votes
1answer
37 views

Pick Values From A Oracle Select Query

I have executed the below command (Part of a 2 step procedure required for password reset when we face the error ORA-28007). SQL> select USER#,NAME,PASSWORD FROM user$ where name='TESTUSER'; ...
4
votes
2answers
3k views

SQLplus and Oracle, bad UTF-8 display

I have set export NLS_LANG=Italian_ITALY.UTF8 db is on UTF-8 SELECT * FROM NLS_DATABASE_PARAMETERS NLS_CHARACTERSET |AL32UTF8 But sqlplus ...