Top "Oracle9i" questions

Pattern Matching with Like Clause

I am attempting to use a LIKE clause in a SQL statement to match a certain pattern within Oracle. I …

sql oracle plsql oracle9i

Node.js + Oracle 9i Database

I am new to node.js and I already did my research with no success, so that is my question: …

javascript oracle node.js oracle9i

Using Partition on oracle table from a DB link

I am working on Oracle 9i my question is: can I use a partition over a table through a dblink …

oracle partitioning oracle9i dblink

How to alter index change tablespace in Oracle 9i?

I am a novice to Oracle DBMS and I have a task to change an index table space in Oracle …

oracle9i

Table,View Or Sequence reference 'SEQUENCE.NEXTVAL' not allowed in this context

I'm having this error while trying to compile the following trigger : CREATE OR REPLACE TRIGGER INCREMENTER_ID_CONSISTANCE BEFORE INSERT …

sql oracle sequence oracle9i

count number of rows that occur for each date in column date range

I have a table with data such as below Group Start Date End Date A 01/01/01 01/03/01 A 01/01/01 01/02/01 A 01/03/01 01/04/01 B 01/01/01 01/01/01 ETC I …

sql oracle plsql oracle9i

mutating, trigger/function may not see it- error during execution of trigger

CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.…

sql oracle oracle9i ora-04091 ora-04088

Query to return text if row is null from oracle db

Right now I have a query that is giving me a blank space, which is good, but what I really …

sql oracle oracle9i

Create table from select in Oracle

I would like to do something like this: create table NEW_TABLE (select * from OLD_TABLE where id=3582) And have …

sql database oracle oracle9i

How to replace/remove multiple words from string in single statement

I have a table containing full body of water names in one column. ie: Golden Lake Blue Water Lake Muskoka …

sql oracle oracle9i