How can I return data from dunction in store srocedure ?
I cannot do it with following.
CREATE OR REPLACE PROCEDURE S1.SP1 (cur1 in out PACKAGE_CUR.tcur
)
IS
BEGIN
open cur1 FOR sel...
I running an application in windows which connects to a oracle database residing in Unix machine. The unix machine is in a remote server. Hence am using VPN to connect the same. The applciatio...
Hi
The script below does not return all of the data, some of the columns has null data in, how do I include this data please?
Thanks
Rebecca
SELECT DISTINCT
BRI.BRI_BR...
In the init.ora on my UNIX box, I don't see the parameter "DB_FILES" for the limit on the total number of files associated with the db instance. database. I assume the default is 1022 (V7) a...
Hai !
i want to rebuild multiple indexes at a time.
I know alter index < index name > rebuild; but is there anyway to rebuild multiple indexes at a stretch?
Dear experts,
Recently I have been asked in an interview for the online conning procedure in oracle. can some one advice the procedure on this. I spent quite some time on net, couldnt able...
Q # 1.
I have a dmp file from oracle 9i (release 9.2.0.x) and want to imp into oracle 9i( release 9.0.1.x). what are the possible ways to do that.
Q # 2.
If the answer is no for above...
I get this error when run under system user:
SELECT COUNT(0) FROM eor_dulles.carrier_piece_count
WHERE run_sequence_nbr IN
( SELECT run_sequence_nbr
FROM...
Hi,
According to my Entity Relationship Diagram, I have the Student,Module,Registration tables with appropriate relationship.There is a data requirements called "Students can take only five m...
We installed Oracle 9i database, and post it on internet, when we use sql-plus to access it, it works fine. But when we add a firewall, the we can not access the database successfully anymore....
DATE DIFFERENCE - ORACLE 9I - SQL QUERY
I want to calculate TOTAL SUSPENDED time by a CALL_ID - excluding Bank Holidays (business hours only - 8am to 6pm) - IS THIS POSSIBLE?? - example tab...
Hello,
I am looking for a database command to describe the relationships in an Oracle Database. I know the describe statement is used to list the fields within a database table, however, I...
TABLE: PROJECT_DIM
Project_Key Project_Id
100 1430
101 1500
102 1270
103 ...
Hi,
There is a server which had the Oracle client installed however there were 2 missing components...
1) Oracle Objects for OLE 9.2.0.4.4
2) Oracle Provider for OLE DB 9.2.0.1.0 ...
Hi I'm on a Unix Solaris box and I would like a step by step in detail way of cloning a Oracle version 9.2.0.8 database to another database on the same box. I've looked at other solutions and ...
My ORACLE version is 9.2.0.6.0 on SunOS . I did an import with index =N and constraint =N .
Now I am creating indexes using the script generated in indexfile .
But I am getting follo...
Hi
In oracle how do I view the error logs? how many logs available for DBA view compare to sql server
I created a user and granted resource and create session... I created a bunch of tables, seq, etc... as the new user.
Verified all objects existed and the owner was my new user as SYSDBA us...
Hi,
I have a question about GLOBAL_NAME of the database. All i understood from documents is that GLOBAL_NAME of a database is a combination of its DB_NAME and DB_DOMAIN (db_name.db_domai...
i have created a workspace managed table in my workspace 'TEST'..THE TABLE NAME IS RELATIONSHIPS_LT--- COLUMNS (X........Primary key, STATUS)
Now after versioning the table ..finally i hve fo...
I downloaded and install oracle 9i and did the install steps, one it was all done I could not log in because I did not know the login id. is there a default Id that is used when you first inst...
Getting error messages in the trace file: What does this mean?
No bind buffers allocated
***************** dump of cursor xsc=6662c04 **********************DEADLOCK DETECTED
Current SQL...
I was doing installation on Oracle 9i,
I was wondering if I was in sqlplus doing the installation do i need to run the following scripts in sequence?
@$ORACLE_HOME/rdbms/admin/catalog.sq...
hai !
while running the daily jobs some days the database is working fine but sometimes i am encountering the below error and database is getting down. Can i know the reason.
ERROR:...
In the attached query, limiting the dates to >= 6/30/08 does still returns all the dates.
I need to pull form >=6/30/08
if either PRIM_EXP_CARR = 'AIR'
OR PRIM_GRND_CARR = 'AIR'
OR PR...
