copy files
Using SQLPLUS how do you copy files from one location to another
Answer Question
| May 12 2008 1:09 PM GMT
| asked by
Ga80071
SQLPlus
Embedded SQL in a Cobol program using a sub-select in the select clause
The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = ...
View Answer
| May 5 2008 6:58 PM GMT
| asked by
Warpmail
COBOL, Embedded SQL, SQLPlus
oar-01033
ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba.When I do this, sqlplus is returning the error message:ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as...
View Answer
| Apr 21 2008 8:21 AM GMT
| asked by
Maitreya
ORA-01031, Oracle error messages, SQLPlus
Subquery?
I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same.I have 3 tables.customer generalcustomer detaillocationI have used a join to list all the required customer...
View Answer
| Apr 17 2008 3:25 PM GMT
| asked by
MizzGail
Oracle, SQLPlus, Subquery
