SQLPlus

store image from a directory into oracle database using sql

i have a directory containing 1000s of photos which i have to upload into oracle 9i db. i need to use only sql plus for this. i want a simple material to upload all those photos..

How to implement oracle single sign-on with a legacy application

I have set up a user for external authentication in the database. I am able to login to the oracle database sqlplus /@dbname and it uses my windows account. But when I try to login to the application I get an error of a null password. Are there any other applications/tools that are necessary to...

Error when using SQL*Plus @@ command in SQL Navigator

When I try to use the @@ SQL*Plus command in a script I get the message "ORA-00936: missing exppression!" when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I've tried the same script in Oracle Enterprise Manager...

iSQLPlus creating packages with multiple procedures in it

Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

Get the following error when logging into SQLPlus - ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener...

ProC under Oracle 10g

Hi! I have a piece of code in Pro-C that's been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty...

ORA-03113: end-of-file on communication channel

I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am...

Oracle Enterprise Manager login password error

We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...

Oracle 10g Instance not starting Up

Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

Is there a config file to set sqlplus default to GMT?

Need help please. I need to set sqlplus to default to GMT instead of local timezone. Is there a way to do this? TIA, slee72890

SQL Plus

I have a subquery that works but I need to change some parameters. Specifically 2 fields in a different table. When I do, using aliases, it stops working, "Invalid Identifier". The first select gets all the fields from 2 tables then the subquery uses the 2nd table. Table B has some fields as well...

sql quries

i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.

ORA-1034: Oracle is not available error with SQL Plus

I had installed Oracle 9i in Windows XP Professional Edition. Whenever I start SQL plus(GUI) it says, ORA-1034 error, "Oracle is not available, Shared memory realm does not exist" In the services I saw that an associate database service is running. Thank you.

copy files

Using SQLPLUS how do you copy files from one location to another

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 = ...

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...

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 general customer detail location I have used a join to list all the required...