Hi I know this question has been posted many times and I have gone thru all of them and tried using decode also. But I am still not able to get the...

Krishna

03-08-2006 01:50 PM
DA Morgan

If the EXECUTE IMMEDIATE mysql USING bindvariable1,bindvariable2 knows what to fire - surely there must be a way to capture the actual statement that...

centurionoftheseed

03-08-2006 11:11 AM
centurionoftheseed

Hi all, I need to compare two dates...one stored in a table and the other user generated. The table column time is of the format 08/03/2006...

Raj

03-08-2006 09:55 AM
Raj

Hi everyone, I have a table that contains duplicate records. All of the fields in these records are duplicates except for the primary key. I need to...

simpsonj@imsweb.com

03-08-2006 01:46 AM
T

Dear all, I'm currently testing the effectiveness to switching some heap tables to IOT's. The primary goal is simple: REDUCE IO. My environment is...

p_msantos@yahoo.com

03-07-2006 07:26 PM
Mark D Powell

Hi all, The documentaion states that the latest OJDBC14.JAR file from Oracle 10.2 is compatible with older releases as far back as 8.1.7, but I...

tarbster@yahoo.com

03-07-2006 10:22 AM
tarbster@yahoo.com

Hi, How to design a generalized database that is used to store datas from any other database. The thing is that the tables and datas of the source...

Baski

03-07-2006 03:19 AM
frank.van.bortel@gmail.com

hi, does anyone know where to get some oracle sql trial exams to practise ? thanks, pavlik

pavel morozov

03-06-2006 08:49 PM
ianal Vista

Anybody else getting solicitations from Nigeria with hard-luck stories from newly certified DBAs? ++ mcs

Mark C. Stock

03-06-2006 07:21 PM
joel-garry@home.com

Hi Friends , well i am new to this group, can anyone tell me about how much beneficial an Oracle certification i.e introduction to Sql will have...

chittora.diwakar@gmail.com

03-06-2006 04:42 PM
Ian M

Hi All, Can you pass a parameter to an anonymous block? We have a Unix script which will run and compile some procedures for us. For checking,...

amerar@iwc.net

03-06-2006 02:31 PM
Frank van Bortel

Hi, Can anybody tell me how to insert a Non-breaking Space (ASCII 160) in a field using SQL? I use SQL*Plus. Any comments would be...

flashguru_in@yahoo.com

03-06-2006 02:24 PM
Frank van Bortel

Hi, I am in a dilemma , where I have 2 Oracle databases . Database 1 has data which I need to join with Database 2 and create reports. My approach...

sb

03-06-2006 02:22 PM
Frank van Bortel

in order for the instant client to work, the FAQ mentions that the TNS_ADMIN variable must be set. I can get it working if I create it as an...

Luch

03-06-2006 02:12 PM
Frank van Bortel

Hi Friends , well i am new to this group, can anyone tell me about how much beneficial an Oracle certification i.e introduction to Sql will have...

chittora.diwakar@gmail.com

03-06-2006 11:25 AM
DA Morgan

I have a problem with GetRecordCount() in VC .. When I execute SP returning multiple rowset using ref_cursor, this process is succeed in excuting....

meere

03-06-2006 11:00 AM
DA Morgan

hi everybody , i have no experience on application server 10g and i got job for deploying froms 6i and reports on 10g application server release 2...

jklakra25@gmail.com

03-06-2006 09:33 AM
Mark D Powell

I have a problem with GetRecordCount() in VC .. When I execute SP returning multiple rowset using ref_cursor, this process is succeed in excuting....

meere

03-06-2006 09:20 AM
Jim Kennedy

I would like to know when exactly the implied commit takes place in a plsql block. for example: BEGIN if flag is 'Y' update table a set ...... end...

tony

03-06-2006 08:30 AM
frank.van.bortel@gmail.com

Hello, I'm using the oracleclient namespace to attempt to connect to a Oracle 8 db on a server. I have the following code: try { string...

TRW

03-06-2006 03:47 AM
frank.van.bortel@gmail.com

Hi, is it somehow possible to find all sequences known in a schema, preferably using JDBC methods but SQL-queries to find those are...

Tom Schindl

03-06-2006 12:28 AM
Malcolm Dew-Jones

Hi All, We are currently getting the following error ORA-01460: unimplemented or unreasonable conversion requested When we try to insert a...

vsabu

03-05-2006 12:59 PM
vsabu

Hi all, I have a weird problem. I am using an Oracle 9i DB and I wrote a stored procedure. The procedure works like a charm when I use SQL+: execute...

Jean marc Parmentier

03-05-2006 11:45 AM
Jim Smith

Hi frnds, I am caught up in a very crazy yet obvious situation using pl/sql. I wil try to explain the issue here in hope of gettin...

hitchhikar

03-04-2006 04:18 PM
Jim Kennedy

Hello, I have a Java class which calls the Oracle SQL*Loader to import data into a database-table (Oracle 9i). To check if everything worked fine I...

Homer Frey

03-03-2006 05:26 PM
Sybrand Bakker

I have an SQL which returns something like these below. Re: Oracle 9i on Windows 2000 server. select s.my_study_id as...

Harry331

03-03-2006 05:14 PM
Harry331

Hello, I have the following file (2 line) which I want to intend in an oracle database with the SQL*Loader. tommy050+3423 tom 070-0006 The file...

Michael Freier

03-03-2006 02:23 PM
DA Morgan

Total Noob questions. I've constructed the following two SQL just for testing. The idea being I prefer the row with value '1' in better, but want...

jason@cyberpine.com

03-03-2006 02:15 PM
Barbara Boehmer

I have a table with sales person id and sales region, there are multiple rows for each person. I have to create an output with person id and all...

MS

03-03-2006 01:22 PM
Michel Cadot

Is there a better way of doing the following query? SELECT TESTASMAKE MAKE, MAX(total_cnt) Total, MAX(pass_cnt)...

hilljm1974@gmail.com

03-03-2006 08:31 AM
hilljm1974@gmail.com

Hi, currently i am running a replicated link. every table that is replicated has the following trigger code "ORACLE"."REPLICATION_19" BEFORE...

steve

03-02-2006 09:40 PM
steve

Hello, when USER_B tries an INSERT INTO USER_A.TAB and some NOT NULL values are missing, he gets a ORA-01400. But in the error text the...

Thomas Blankschein

03-02-2006 07:58 PM
Thomas Blankschein

I'm using VC++ 6.0 with OLE DB to access data in Oracle 9i. The problem is calling stored procedures in Oracle that returns data. Oracle stored...

meere

03-02-2006 07:23 AM
sybrandb@yahoo.com

Anyone have sample VB code that returns set of connection strings defined in local tnsnames.ora ? thx in advance

News

03-02-2006 06:27 AM
Al Reid

Dear Oracle Experts, I'M searching for a query to find out whether sequences for auto iteration of primary key columns do exist on a table or...

Daniel Wetzler

03-02-2006 05:59 AM
Mark C. Stock

Dear Excel and Oracle Experts, I have a problem with connecting my Excel Application to an Oracle 10g r2 database on Win XP, using an ADO connection...

Daniel Wetzler

03-02-2006 04:49 AM
Dmitry Loginov

Hi, I need a query who can compare the date from one record to the date from the next record. Can someone help me with this? I better explain it...

UserX

03-02-2006 01:28 AM
UserX

I am in serious need of help ... I have a relatively simple program, written in VC 5, that I am trying to use as a CGI "script." This program...

sj

03-01-2006 10:03 PM
sj

I have a Microsoft Access2002 database that needs to connect to an Oracle Database. I need to map 2 tables from the Oracle DB to retrieve the proper...

RLN

03-01-2006 09:50 PM
Jim Kennedy

Hi, I am using sqlldr to load one data file into multiple tables. The oracle version is 9i, sqlldr version is 9.2.0.1.0. My data file has...

Naren

03-01-2006 06:09 PM
joel-garry@home.com

I want to do the below scenario: Backup my Oracle 9i db to disk. Backup the backupsets from disk to tape. Delete any older backupsets from disk. I...

dax.desai@gmail.com

03-01-2006 02:52 PM
Frank van Bortel

Hi gentlemen, I wondered why, under VC++ 6, this line compiles : OCIDateGetDate( dt, &year, &month, &day ); and not this one : ::OCIDateGetDate(...

Herode

03-01-2006 01:14 PM
Andy Hassall

I am trying to find all duplicate values in a 7-day date range so that if an item/customer combination exists more than once either 3-days before or...

is_db

03-01-2006 12:13 PM
is_db

Hi NG, as I read in the documentation, Oracle is auto-tuning its initialization parameters. When and how often does this autotuning take place? Is...

Ina Schmitz

03-01-2006 12:04 PM
DA Morgan

Please forward some good reumes with excellent communication skills. COGNOS-DATASTAGE CONSULTANT Exp: 4-6YEAR Location: Detroit Duration : 6...

swaroopa

03-01-2006 11:52 AM
DA Morgan

Possibly this is a dumb question. Can one query across more than one Oracle databases? For example, as defined in the listener.ora file, one might...

Ivan K.

03-01-2006 10:05 AM
Ivan K.

Hi frnds, I have oracle 9i database server in my system now I am going to install management server in my system .While installation I selected...

narayana

03-01-2006 08:44 AM
narayana

Greetings, I have a requirement of loading millions of data Using Sql_loader. Here I have given a script that tells the current process of loading...

pankaj_wolfhunter@yahoo.co.in

02-28-2006 10:13 PM
pankaj_wolfhunter@yahoo.co.in

I could really use some pointers. Here is the problem: I have a IBM MVS process that when complete will FTP a single row file to a Windows or AIX...

Mary

02-28-2006 05:07 PM
Mark C. Stock

Cross-posted to comp.databases.oracle.misc and comp.lang.php ... Using PHP 4.3.11 on Linux and ADODB data abstraction library. Oracle client...

Geoff Muldoon

02-28-2006 04:27 PM
Geoff Muldoon