Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
2answers
29 views

Creating a trigger on Oracle 11g (beginner question)

I need to create a trigger that updates another table whenever the trigger table has an insert into command, or an after insert trigger. I need to pull the id that's being inserted into the table in ...
-1
votes
0answers
10 views

Update Open Query for Oracle linked server [on hold]

I return an open query for updating table data in oracle.whether i can use condition (CARD_NUMBER=tb3.cardno) inside openquery..?below is my query update openquery(link,'select ...
1
vote
0answers
12 views

Cannot Enable DTC For SQL Server to connect to oracle by linked Server

i've SQL server database 2005 and oracle database each one located in separated server . both databases have 1 table with the same structure i need to make sure that when a record added to the sql ...
0
votes
1answer
18 views

How to view the original script that built a materialized view and that was created by another user?

In the Oracle database server use, another user (called MIMIC2DEVEL) created a materialized view and made it public. How to view the original script that was used to built it? Here are the grants on ...
-2
votes
0answers
11 views

Pointing SOA10g to OUD [on hold]

We were using OID, but have changed to a LDAP OUD server. When we follow the documentation we don't find our fix. Does anyone know the process to make this change?
2
votes
1answer
30 views

Regular expression in a SQL case statement

I have records formatted as such: CBS405/505 Fourth Week(Wtr Qtr) BR 404-504-604 Fifth Week(Fall Qtr) AP490-QB-09 Weekly Sessions(Spr Qtr) APR501 Fourth Week(Wtr Qtr) MP 300 Fourth Week(Wtr Qtr) ...
3
votes
0answers
53 views

How to track DML events ocurred in the current day

I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, TIMESTAMP AS ...
-1
votes
0answers
22 views

clarification of union, intersection, and or, xor [on hold]

I am confused about this question. It seems some questions are redundant (1) Find the driving licence numbers and full names of all who used the truck PKR3344 and those who used the truck WWF1155. ...
0
votes
1answer
31 views

How to select a column to compare two values in it with AND [on hold]

How to select a column to compare two values in it with AND select distinct c.reg#, a.fname, a.lname, to_char(b.L#) as "L" from employee a, driver b, trip c where a.e#=b.e# and b.l#=c.l# and ...
0
votes
1answer
18 views

Query DML code to determine source and target data

I looking to scan all of the procedures in our database in order to save off source and target table information for our data loads. I'm thinking there should be some sort of dba table which will give ...
0
votes
1answer
16 views

How to select data out of an Oracle collection/array?

Due to needing some complex data manipulation and not being able to use PHP, I crafted a procedure (not stored, it's just run when we run the query) in Oracle to manipulate the data and store it in an ...
0
votes
1answer
30 views

Oracle SQL Complications With Multiple Triggers

Hey all so I am creating a DB that is used going to be used for managing utilities of a system. My DB has 3 tables: Users, Utilites, and Files (leaving Files table out because question shouldn't ...
0
votes
2answers
41 views

inner join select - group by?

I have 2 tables (Oracle database): ANEXA2A_TABEL1: id fk_id_anexa pet1 pet2 alt1 alt2 1 123 10 1 20 2 2 321 11 2 10 3 ...
0
votes
1answer
40 views

Proper use of extract function? [on hold]

I am trying to select names of employees who were born in 1985. I am doing this but it is giving me an error. SQL> select fname, lname, count(E#) as "total" 2 extract(year from date, dob) as ...
0
votes
1answer
20 views

How to exceute view without DBLink in oracle server

I have 2 views, example V1 from Database DB1 , V2 from database DB2, these 2 database server are remotely configured, I can able to execute these views separately without database link in the ...
1
vote
1answer
23 views

Load file based on line number in sqlldr

I am trying to load header and detail records from a file. The only way I know the difference between the header and the detail records is the line number. The first line is always the header and the ...
0
votes
2answers
35 views

Set Oracle Home (install Oracle Home) for Toad 12.6

I had Toad 11.5 and I'm trying to install Toad 12.6, to connect to Oracle 11g on a 64-bit Windows 7 machine. No matter what I try, when I start Toad 12.6, I get the error: "No valid Oracle clients ...
-1
votes
0answers
14 views

Connecting to Oracle Database on Port other than 1521

I have two machines on the network and on one Oracle 12 c is installed on port 1521. I need to connect to this Oracle database from my other machine but for some reason I need to connect from port ...
0
votes
1answer
27 views

Call trigger during SQL Loader insert

I'm trying to insert data from a file into an Oracle table using SQL loader. The primary key is populated by a sequence where the nextVal is called from an insert trigger. When I try using sqlldr, it ...
0
votes
1answer
25 views

phpmyadmin like interface for Oracle [closed]

Is there any phpmyadmin like interface for Oracle? Currently most of my work is on a remote machine, and SQL Developer is really heavy and slow on it. It would be nice if there was web interface that ...
0
votes
1answer
53 views

How to view the latest entries in all tables in an Oracle DB? [closed]

I wanted to examine a running Oracle instance on one of our servers, but nobody knows, if there's still any data of interest stored in the database. Unfortunately our last Oracle admin has left our ...
-4
votes
0answers
32 views

**Homework/Research** for future Database Administrator [closed]

Considering I am pretty new to software development/programming I decided to do a technical writing report researching what programming languages are best suited for students wanting to pursue a ...
0
votes
1answer
21 views

ORA-01722 Error when running stored procedure

I am trying to run a stored procedure however when I run it with an a valid Number it gives me an ORA-01722 error. I checked to make sure that the columns in the where clause where the parameter is ...
1
vote
1answer
32 views

trigger or check constraint insert values based upon existence of others

For simplicity (and since it captures the essence of my problem), suppose I have a table with data. CREATE TABLE my_practice_table ( my_id NUMBER(12), field_2 VARCHAR2(20), field_3 ...
0
votes
0answers
15 views

Dmp file import create triggers error

I've taken a full database backup from one server to be moved to another using the following command (both using Oracle 11g): exp SYSTEM/password@db1 full=y grants=y rows=y file=backup.dmp And now ...
0
votes
0answers
11 views

write data on multiple storageNodes in oracle NoSQL

I'm using oracle NoSQL on ubuntu (newbie to both) and created 3 storageNodes (with 3 RN on each) in one computer on different ports (5000,6000 and 7000) in a store named mystore. Now I need to write 1 ...
2
votes
1answer
23 views

Re-import packages in Oracle

I'm aware of options to re-import data to tables using table_exists_action and can give options like skip,append or replace for the data. But is there an option to re-import packages (re-create) into ...
-2
votes
0answers
20 views

Calculate percentage of a column group by 2 columns in pivot table format using oracle 11g sql [closed]

I would like to request help displaying count of a column and respective percentage of a column as in pivot table. I tried several options of which I yielded 18 rows when used kind of select first ...
-1
votes
1answer
22 views

Connect to Oracle remote Database by only installing a client on my laptop?

Is it possible to connect to remote oracle database from my laptop if I only install instant client, without installing oracle database? I have the tnsnames.ora and listener.ora files in ...
0
votes
1answer
24 views

How connect by is really working? How is it multiplying rows?

I know (on high abstract level) how hierarchies in Oracle works, but this one I do not understand. When issued following query: select rownum-1 as num from dual I've got one row as result. The ...
1
vote
0answers
17 views

(VS Comm./VB6) How to Select from 2 different data sources/formats in one query?

I have two working TableAdapterQueries in my project, one selects from a MySQL database on a virtual server I own, the other is an Oracle PL/SQL database on a separate server. The data (and ...
2
votes
1answer
29 views

Oracle 11g hash join vs nested loops question

I'm using Oracle 11g and working on a legacy system. I have two tables, A and B. A has ~40M rows and B ~4M rows. A has a foreign key on B (B is the parent of A). A query does essentially this: ...
-2
votes
1answer
35 views

Generate create table DDL from any arbitrary select query? [closed]

Is there a way, given any arbitrary select query like: select myfavoritenum, myfavoritetxt from tablewithmanycolumns and magically receive a create table statement: create table justmyfavorites ( ...
0
votes
1answer
28 views

Oracle Conditional sum

This question was born in my mind looking at this kind of code: select sum(value) into positive from my_table where value > 0; select sum(value) into negative from my_table where value ...
1
vote
1answer
33 views

cluster_database TRUE/FALSE what does it mean in Oracle RAC?

I have 3 databases on an Oracle RAC (two nodes) one database which is running with CLUSTER_DATABASE=TRUE on both nodes, the other two runs on each node with CLUSTER_DATABASE=FALSE what does it mean ...
0
votes
1answer
31 views

Strategies to import big data into oracle

Which strategies are available to import very larg amount of data from an external system which is delivering about 500 million small transactions every day? Oracle becomes very slow with high ...
1
vote
1answer
26 views

Delete Old Archivelogs from missing database

We have deleted a database but the archive logs remain. We need to delete these as they take a lot of space: Since the database is deleted, it is not in the rman catalogue so I cannot use delete ...
3
votes
1answer
51 views

dbms_datapump API exclude statistics during import

We are using dbms_datapump to copy data between different servers or to setup new schemas quickly. However importing statistics usually takes ages and has the additional disadvantage that schema ...
0
votes
1answer
40 views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
0
votes
0answers
37 views

WHENEVER OSERROR suppresses error messages

$ sqlplus <connstring> 2>&1 <<! WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; SET ECHO ON; @nonex.sql; ! Produces SQL*Plus: Release 11.2.0.1.0 ...
0
votes
0answers
49 views

How to downgrade Oracle Database from 11gr2 to 10g?

In certain situation i have to downgrade from 11gr2 to 10g but coudn't find right way to downgrade. Can you please give a right direction and possible causes to Database.!
0
votes
1answer
34 views

Oracle: How to AUTOTRACE in my program

You can display the results of EXPLAIN PLAN with explain plan for select * from foo; select * from table(dbms_xplan.display); How can I similarly display the results for an AUTOTRACE in my program? ...
0
votes
1answer
50 views

Oracle: Am I on a RAC?

What query can I perform to determine if I am running on a RAC system? If I'm on a RAC, I need to query from GV$* rather than V$*.
1
vote
1answer
57 views

Oracle: guaranteeing unmodified database state with queries?

If the first word of a SQL statement is either WITH or SELECT, is the statement guaranteed not to change the state of the database? i.e. is this loop "safe"? read SQL string if string begins with ...
0
votes
0answers
49 views

Error PRVG-11322 while atempting to install ODAC 12c release 3

I've been trying to install the oracle developper tools with ODAC update 3 (because I need it to work with Entity framwork 6) but the Unified installer bring me a PRVG-11322 Error. It seem to be ...
1
vote
0answers
24 views

How can you re-synchronize oracle streams automatically?

I have noticed that when a process of oracle streams (e.g. capture/apply/propagate) is stopped or disabled, and at the same time, changes are made to the source and/or destination ...
0
votes
1answer
34 views

jdbc connection string ORACLE , integrated security

we are trying to configure Spotfire to use JDBC connection to ORACLE. We would like it to use integrated security (I call it Active Directory, TIBCO seems to like integrated security). Here is the ...
0
votes
0answers
30 views

Oracle MODEL clause: Carry yesterday's leftovers to today

I'm new to the MODEL clause. I'm trying to track volume of worked/unworked to-do items over time. What I HAVE is: work_date born (# of new to-dos per date), robo (# of computer-closed to-dos ...
-4
votes
0answers
38 views

Oracle to SQL Server query conversion. Getting “Argument data type int is invalid for argument 1 of substring function.” error

I tried to convert a SQL query from Oracle to SQL Server. Oracle query: SELECT T@o_NUMBER(T@o_CHAR(GETDATE(),'HH24')), T@o_NUMBER(SUBSTR(T@o_NUMBER(T@o_CHAR(sysdate,'MI'))/15+1,0,1)) INTO ...
-4
votes
1answer
22 views

From keyword not found? [closed]

SET ECHO ON SET HEADING OFF SET FEEDBACK OFF SELECT * FROM GLOBAL_NAME; CREATE TABLE CAR(REGO CHAR(8) NOT NULL, MAKE VARCHAR(20) NOT NULL, CONSTRAINT CAR_PKEY PRIMARY KEY("REGO")); INSERT INTO CAR ...