Hi, I am wondering why an exp command works with Oracle 8.1.7, but not with Oracle 10.2.0.4. Here's my input file and the exp command that uses...

John L. Allen

09-14-2008 12:10 PM
John L. Allen

Hi, I'm trying to write a complicted query, maybe someone can help. Here is the table: ACTION DATE PRODUCT The ACTION column contains 2 values (A,...

artmerar@yahoo.com

09-13-2008 02:14 AM
Michel Cadot

Christine Hancock Erp Solutions Inc. misscerp (AT) aol (DOT) com Senior Oracle Apps Technical Position - Oracle Apps / Reports Lead Developer. Full...

Christine Hancock

09-12-2008 09:38 PM
DA Morgan

Christine Hancock Erp Solutions Inc. misscerp (AT) aol (DOT) com Oracle Manufacturing Opportunity We have a need for an Oracle Mfg. functional...

Christine Hancock

09-12-2008 09:34 PM
DA Morgan

Hi, I'm new to ref cursors. Please look at this: TYPE select_cursor IS REF CURSOR; v_data_crs SELECT_CURSOR; v_data_rec DATA_CRS%ROWTYPE; What...

Mtek

09-12-2008 03:56 PM
sybrandb@hccnet.nl

Hi, I'm new to ref cursors. Please look at this: TYPE select_cursor IS REF CURSOR; v_data_crs SELECT_CURSOR; v_data_rec DATA_CRS%ROWTYPE; IF...

Mtek

09-12-2008 03:36 PM
Mtek

Hi, We have some messages stored in a column in this format: AA|BB|CC|DD What we want is to replace the vertical bars with a CHR(10) for...

exec@chicagorsvp.com

09-12-2008 03:06 PM
sybrandb@hccnet.nl

Hello, I´m working in a DataWarehouse enviroment with Ascential DataStage 5.2.1 and Oracle 11g. We are trying to load information in a...

rapaz

09-12-2008 09:37 AM
DA Morgan

I'm playing with PHP and its oci8 extension and I'm facing a curious issue: numeric fields are returned as strings and, to make it worse, they're...

Álvaro G. Vicario

09-12-2008 03:13 AM
Laurenz Albe

Hello everybody, I'm working with Oracle 10g. I have a report generated by a sql script. This script runs in a windows task. I have to generate...

CenturionX

09-11-2008 06:29 PM
CenturionX

group: i have a dataset as with three variables: ID, TDD,DS. i want to create a new variable, DSend, where DSend should = TDD+DS for the first...

stathead

09-11-2008 03:58 PM
DA Morgan

Greetings, One of my clients groups want allow a different set of users to modify data. But they want the capabilitiy to accept or reject the...

Tim Arnold

09-11-2008 03:56 PM
DA Morgan

Hi, We have some messages stored in a column in this format: AA|BB|CC|DD What we want is to replace the vertical bars with a CHR(10) for...

exec@chicagorsvp.com

09-11-2008 01:18 PM
Aya the Vampire Slayer

Hi! I've got a simple problem with a create table statement: CREATE TABLE HB_ATTRIBUTE ( STRINGVALUE VARCHAR2(4000 CHAR), DATEVALUE DATE, CONSTRAINT...

Volker Hetzer

09-11-2008 01:01 PM
Volker Hetzer

Is it possible to upgrade just the RMAN from version 9i to 10g without upgrading the database? If so: 1. How do you do that? 2. What...

Sanjaydh

09-11-2008 12:36 PM
fitzjarrell@cox.net

hi, i want to import data with oracle 10g/linux (machine a). then after importing the data into oracle i want to create a dump. it is possible to...

marton.szabo@ivz.de

09-08-2008 10:04 AM
sybrandb@hccnet.nl

I have a union query that combines the results of several queries. Each of these queries has a condition to extract the row where the date is between...

AP

09-05-2008 01:46 PM
fitzjarrell@cox.net

Tom Gugger Independent Recruiter tgugger (AT) bex (DOT) net 419-537-9447 This is a career position for an Oracle Reports Developer with solid...

Tom Gugger

09-05-2008 08:03 AM
Tom Gugger

Jim Smith escribió: That's exactly the option, thank you very much. Searching for "commit" in the Preferences search box doesn't return that page, I...

Álvaro G. Vicario

09-04-2008 07:15 AM
Álvaro G. Vicario

hello, sorry for the question can i view the content of a form fmx file ? not need the code, only the view. thank's for all ask!

Xpeppe

09-04-2008 06:09 AM
Xpeppe

for statistics i need to select the number of orders per 10 minutes. So i want to do something like SELECT TRUNC(insert_date, '??'), COUNT(*) FROM...

Gerhard

09-03-2008 11:32 AM
Michel Cadot

Hi, I am trying to compress using the zip/unzip command given with Oracle in Unix. The objective is to create a zip file, for e.g. for the...

compuneo

09-02-2008 08:11 AM
compuneo

Hi, I've written a package that works with a special set of tables I'm using in different schemas (i.e. MY_WORK). Now I'd like to create it in a...

Norbert Winkler

09-01-2008 02:30 AM
DA Morgan

I have built an application using Oracle Forms and Reports and now need to install it on a couple user machines for demo/pilot. There is no...

l

08-29-2008 03:33 PM
Shakespeare

ORACLE: I want a trigger to get fired when my application’s connection to the database gets disconnected abnormally. I plan to monitor the Server...

shilpa

08-29-2008 10:52 AM
sybrandb@hccnet.nl

After moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many...

mh@pixar.com

08-29-2008 09:50 AM
Mark D Powell

10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on...

klabu

08-28-2008 06:02 PM
noobuntu

After moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many...

mh@pixar.com

08-28-2008 03:19 PM
fitzjarrell@cox.net

I am an engineering student in final year pursuing Computer Science. I have always been fascinated with Oracle. Can you suggest me ways on how...

Jyoti Sharma

08-28-2008 03:09 PM
mh@pixar.com

I'm really just curious. when you define default parameters from within RMAN like we have below, does RMAN remember it? Where does it store that...

exec@chicagorsvp.com

08-28-2008 02:36 PM
exec@chicagorsvp.com

Tom Gugger Independent Recruiter tgugger (AT) bex (DOT) net 419-537-9447 Miami, FL W—NW sub POSITION # 1 PL/SQL Oracle Application Developer/...

Tom Gugger

08-28-2008 09:31 AM
Mark D Powell

Hello, I have been told that something like: create trigger triggername before update of ROW on TABLE for each row when (old.ROW = a and new.ROW =...

Dirk Wendt

08-27-2008 07:44 PM
joel garry

MySQL has this function, was wondering if this can be done with Oracle. Basically a query which uses the LIKE method, but is able to rank...

Mtek

08-27-2008 05:26 PM
joel garry

Hi, I'm searching for a way to access oracle (and in future other DB systems) using ODBC on a 64bit linux machine. I found unixODBC, but the oracle...

Ronnie Brunn

08-27-2008 01:24 PM
Troy Meyerink

Hi %, I've a question about 'leading' the optimizer. To make it not too simple, it should work from 9.2.0.4 up to 11.1.0.6. I'm selecting from a...

Peter Kallweit

08-27-2008 12:54 PM
Aya the Vampire Slayer

Dear Experts, We met an issue with Oracle client, and hope you could give us some advice. On our Windows 2003 64 bit servers, currently we have...

P.L.

08-26-2008 05:33 PM
joel garry

Hi all, I would like to know how it is possible to escape double quotes in a format string in the control file. I explain the problem. I have a...

boscardin.marco@gmail.com

08-26-2008 11:03 AM
boscardin.marco@gmail.com

There are 60 Named User Plus licenses for Oracle Enterprise Edition 11g in the company. All these users use a production instance on a server with 1...

ek_2277@yahoo.com

08-26-2008 03:02 AM
ek_2277@yahoo.com

I have need to do something like this: if tablename = 'FOO' insert into foo ... else if tablename = 'BAR' insert into bar ... (exact same...

mh@pixar.com

08-25-2008 03:06 AM
Carlos

Hi, I have a question about DECODE. I know that I can return a 1 or 0 using DECODE: SELECT (DECODE...,1,0) FROM <table name> WHERE........; My...

Mtek

08-23-2008 12:09 AM
DA Morgan

Hi, I have a question about DECODE. I know that I can return a 1 or 0 using DECODE: SELECT (DECODE...,1,0) FROM <table name> WHERE........; My...

Mtek

08-22-2008 07:18 PM
Malcolm Dew-Jones

Dear Oracle users: I have a very simple test.sql file shown below: ============ set echo off set feedback off spool C:\test.log select* from

Xu

08-21-2008 09:08 PM
Malcolm Dew-Jones

I have a table MASTER_DEF_TBL and would like to replicate its definition (including constraints, indexes, comments, etc) to several tables such as...

mh@pixar.com

08-21-2008 04:34 PM
mh@pixar.com

I'm at a total impasse. I have a stored function that returns a SYS_REFCURSOR. It works fine, I can call it in SQL*Plus and see the data that's been...

Tim Slattery

08-21-2008 11:16 AM
Laurenz Albe

Hello everybody, Is anyone able to give me some indications about how to develop an Access interface for an Oracle database ? I dispose of Access...

Gloops

08-20-2008 04:13 PM
Gloops

Project management resources: templates, samples, articles, software, lecture notes on software & general PM. Project Management Topics to Beginners...

spyder

08-20-2008 07:49 AM
spyder

Hello, what does the datatype NUMBER(0) mean? Is it the same as NUMBER, which can be seen in turn as FLOAT? Thank you, Norbert

Norbert Pürringer

08-19-2008 12:59 PM
Mark D Powell

Hi, I am a SQL Server / PostgreSQL developer and am fairly new to Oracle. I'm starting out using Oracle XE 10g with the web based client that comes...

grantschulte@gmail.com

08-19-2008 11:28 AM
gazzag

Hello everybody, I should be very interested to know if anybody has already seen such messages. When I launch a FindFirst on an OraDynaset from...

Gloops

08-18-2008 10:43 PM
Gloops

I have no problem spooling files to directories like C:\myfolder. But in Windows, I use "My Documents" folder alot and that directory name has spaces...

sasworks

08-18-2008 06:55 PM
sasworks