Hello, an external process writes several files into a directory on a windows file system. This directory is linked to a 10g database as a...

Thomas Blankschein

03-24-2008 01:28 PM
Thomas Blankschein

languages Have the complete details regarding programming languages. A-Z about programming languages like Java J2EE, C++, code implementation guides...

Santhosh1992

03-24-2008 12:52 AM
Santhosh1992

I am looking forward to some reference about how to write the control file used by sql*loader. Is there any official or inofficial references of that?

Jimmy

03-22-2008 07:41 AM
Robert Klemme

Hi everyone, Is it ok to post questions about oracle Hyperion here? If not, do you know of a suitable forum? Thank you. -- Chris Val

Chris ( Val )

03-22-2008 07:21 AM
Chris ( Val )

Hi list, we have some 11g and 9i servers and I want to transfer data from an 11g to a 9i one. Using the exp from 11g naturally fails, because the...

Christoph Schwerdtfeger

03-21-2008 04:19 PM
Christoph Schwerdtfeger

Hi, These are the requirements currently open. Req. ID: Req-030420081047 - Business Objects (Project Manager) Primary Skills: Business Objects...

craig

03-21-2008 03:53 PM
DA Morgan

Hi, These are the requirements currently open. Req. ID: Req-030420081050 - Oracle Technical Consultant Primary Skills: Oracle Techno functional...

craig

03-21-2008 10:30 AM
craig

On 19 mar, 19:52, Jim Smith <usene... (AT) ponder-stibbons (DOT) com> wrote: Thanks Jim. You're right, it works with "select...

anvi777@gmail.com

03-21-2008 01:38 AM
ssmagin@activedbsoft.com

I am not sure if I can word this right. But I am trying to explore the best way of loading data into about 40-50 oracle tables. We have collected the...

Anoop

03-19-2008 05:00 PM
Gints Plivna

Hi All, We area migrating Oracle database from Oracle 7.3.4 to Oracle 10g R2. Currently all the applications are connecting Oracle 7.3.4...

Dipankar

03-19-2008 12:05 PM
fitzjarrell@cox.net

I am trying to get Georgia font to Oracle 10g PDF reports. The system does not acknowledge the existence of the font and replaces it with...

Erkki Aalto

03-19-2008 07:17 AM
Erkki Aalto

Hello all, I've been doing some research but haven't come up with some solid answers and I'm hoping you can lend a few minutes to help me out. I'm...

Andy

03-18-2008 10:26 PM
Michael Austin

Hi, If I send an Update like this: UPDATE MyTable SET Field1 = value WHERE Field2 = value2; there is a way that Oracle make a commit...

PowerOne

03-18-2008 12:21 PM
Mark D Powell

Oracle 10GR2 - How can I get custom PL/SQL to be invoked upon every redo logfile switch?

Ana C. Dent

03-17-2008 06:21 PM
joel garry

we are doing a clean install of 11.5.10.2 on a win 2003 server. it is a a multi-tier installation with a single DB node and a single apps/etc...

batman

03-15-2008 02:11 PM
Shakespeare

A quick and simple question. If I have a query like: SELECT * FROM table NUM = 31 Now for reasons irelevant to my question the number provided...

nivS1978@gmail.com

03-14-2008 10:09 AM
nivS1978@gmail.com

We are migrating an application from Oracle 9 to Oracle 10. The application uses several sequence objects for user visible sequences. For some reason...

Flash Gordon

03-12-2008 06:52 PM
Flash Gordon

hi, i run INSERT INTO test (FIELD1) VALUES ('a''a') but DBMS oracle returns this error: ORA-01401: inserted value too large for column (FIELD1 size...

Fici

03-11-2008 02:19 PM
Maxim Demenko

Hi, I work on an Oracle9 database which is loaded through sqlldr. The issue that I am facing is because of a special character known as long dash...

Sandy80

03-11-2008 05:02 AM
Laurenz Albe

Hi everyone, I haven't played with SQL for a while, but the following SQL returns ~700,000 records ( a lot of duplicates ), and I used a UNION with...

Chris ( Val )

03-11-2008 04:28 AM
Chris ( Val )

I use Oracle Application Express 3.0.1 How can I send the bind variables value when I branch one page? Thanks, Loki

Loki

03-11-2008 04:00 AM
Carlos

Hi How are you doing today? Please let me know if you have any resources with you. Position: Oracle Apps - Technical & Functional (80/20) Modules:...

Sachi Tadepalli

03-10-2008 11:05 PM
DA Morgan

Hi , I can not insert a row in a table called duct_connectivity. when I try to it says.. unique constraint prd.dctconrb `violated. not I found out...

vijaysam

03-10-2008 12:15 PM
DA Morgan

Hi, I need a batch file to lunch sqlplus and run a statement but the login must be in .par file like this: sqlplus @c:\mylogin.par START...

PowerOne

03-10-2008 10:22 AM
fitzjarrell@cox.net

I'm using a trigger like so: CREATE OR REPLACE TRIGGER TRG_SCHEMA_CHANGES AFTER DDL ON "MYSCHEMA".SCHEMA To capture all schema changes to a table I...

Luch

03-09-2008 12:16 PM
Luch

http://languages-languages.blogspot.com/2008/02/oracle-essentials.html

jammy

03-08-2008 07:39 PM
DA Morgan

I want to return multiple copies of data from a table but do not understand how to accomplish this. The following code works to return a fixed...

egnew@charter.net

03-08-2008 11:12 AM
Maxim Demenko

Hi There, I have a table with heavy select queries on it, with almost no Insert or Update. Is there a way to make Oracle keep this table or a View of...

Sam

03-07-2008 01:40 PM
Mark D Powell

Using Oracle 10.2. I'm still learning the basics, and now I'm having a problem with users I've created myself. They can't login. When I attempt to...

Gustaf

03-07-2008 12:44 PM
DA Morgan

Trying to connect to Oracle using Oracle 9.2 client - a VB6 app from windows 2003 server using microsoft odbc for oracle drivers.... (the app works...

roadwarrior

03-06-2008 01:30 PM
Mark D Powell

Hi! After having seen a lot of three tier applications managing security outside the database we'd like, when designing our own app, use the database...

Volker Hetzer

03-06-2008 10:25 AM
Volker Hetzer

In PL/SQL, is there a way to loop through column values in a record without specifying column names in advance? e.g. like using an index number in an...

dananrg@yahoo.com

03-06-2008 09:31 AM
Thomas Olszewicki

Does UTL_FILE.PUT_LINE have a limitation on the length of the string you are printing to file? I have a variable declares, VARCHAR2(4000). I print...

amerar@iwc.net

03-05-2008 02:26 PM
fitzjarrell@cox.net

Estamos buscando profissionais Junior, Senior e Pleno p as seguintes vagas: - Consultor Funcional - Developer ABAP/4 PL - Para atuar em Hortolândia...

Taís

03-04-2008 10:39 AM
Taís

I am unable to compile my Pro*C++ program when i declare any host variables/structures in header files. It seems that Pro*C++ only accepts...

vihangtole@gmail.com

03-04-2008 06:21 AM
Laurenz Albe

Hi, I need to display a number of seconds in the <minutes>:<seconds> notation, e.g. 100 seconds shall return '01:40'. Hours shall NOT be displayed,...

Jens Riedel

03-04-2008 01:35 AM
Maxim Demenko

Thanks to anyone with any clues here as to what could be wrong with my code, I'm totally new to Oracle! In my Oracle Package Body (Package compiles...

brock wade

03-03-2008 11:46 AM
DA Morgan

All, I am in need of some expert oracle advice on how to solve the following problem. Any ideas would be most helpful. What I need to do is find...

marfi95

03-02-2008 10:40 PM
Charles Hooper

If I would perform a full text search on a full document in xml field, the search escape xml markup? I have news in xhtml format that will must store...

Reny

03-02-2008 04:28 AM
Michael O'Shea

Hi, I posted some things eariler to get some opinions on using CLOBS. We have never done that here. I've been looking for a couple of hours for...

mrdjmagnet@aol.com

03-02-2008 04:28 AM
William Robertson

There are some Oracle tables from a production database that my app will link to after some enhancements are made. The enhancement consist of...

RLN

02-29-2008 09:22 PM
RLN

http://languages-languages.blogspot.com

davi

02-29-2008 06:34 PM
DA Morgan

SiSense is pleased to announce the beta release of its first product Prism - a Powerful, innovative Do-It-Yourself productivity software...

Erins.Ghost@gmail.com

02-29-2008 10:51 AM
fitzjarrell@cox.net

Hi, I need to display a number of seconds in the MM:SS notation, e.g. 100 seconds shall return '01:40'. Hours shall NOT be displayed, so for example...

Jens Riedel

02-29-2008 09:31 AM
Jens Riedel

Using Oracle 10.2. I'm a newbie user, so there's probably a simple explanation to this. I wonder why I can't access iSQL*Plus. I'm trying to access...

Gustaf

02-29-2008 04:44 AM
Gustaf

WALK IN INTERVIEW ON 1st March & 2nd March 2008 Role: Freshers, Trainees in Oracle Developer, Oracle DBA, Oracle Apps DBA, Oracle Apps Technical &...

bootstraptech2@gmail.com

02-29-2008 03:48 AM
bootstraptech2@gmail.com

WALK IN INTERVIEW ON 1st March & 2nd March 2008 Role: Freshers, Trainees in Oracle Developer, Oracle DBA, Oracle Apps DBA, Oracle Apps Technical &...

walkins for oracle job

02-29-2008 03:43 AM
walkins for oracle job

WALK IN INTERVIEW ON 1st March & 2nd March 2008 Role: Freshers, Trainees in Oracle Developer, Oracle DBA, Oracle Apps DBA, Oracle Apps Technical &...

walkins for oracle job

02-29-2008 03:42 AM
walkins for oracle job

One of our customers sent us an export dmp which we're trying to import. Their database uses a character set that is West European or MSWIN, whereas...

Luch

02-28-2008 07:03 AM
Laurenz Albe

Hello all, I'm looking for the pro's and con's for an MS Access Application which has an Oracle backend (Oracle Express). Especially how it is about...

SePp

02-28-2008 03:20 AM
DA Morgan