vadlo (www.vadlo.com) - great search engine and borwser for biology methods and databases, but the best feature is countlessly crawled powerpoints...

Rb

08-17-2008 06:10 PM
Rb

Hi All, I have a task to insert employee data into a oracle table using dbms_ldap, Could someone show me some pointers on how to achieve...

janu

08-16-2008 10:15 PM
Malcolm Dew-Jones

hello friends, i have oracle 10g installed on my pc running on windows xp. i tried to log into isql*plus as dba. i took the help provided...

K Gaur

08-15-2008 02:04 PM
K Gaur

Hi I have a table T with two columns NAME (VARCHAR2) and POS (NUMBER). I want to write an UPDATE query, which updates the column POS such that its...

digory

08-14-2008 03:58 PM
Shakespeare

Hi all I want to find all the objects that reference a given table. Can anyone please provide the SQL query to do the same? Thanks Saravanan

Saravanan

08-14-2008 12:56 PM
DA Morgan

Hello, I would like to spool an Oracle SQL script. Now, if I have started a spool in SQL Plus, each statement and its result is going to be...

Norbert Pürringer

08-14-2008 11:52 AM
gazzag

Hi, I'm trying to trace the caller of a procedure. I used that WHO_CALLED_ME procedure, but unfortunately for me it only returns 'anonymous block'....

Mtek

08-13-2008 04:11 PM
DA Morgan

I'm converting a Sybase database to Oracle. Part of this involves stored procedures. I have a number of very simple Sybase SPs that consist of a...

Tim Slattery

08-13-2008 04:10 PM
DA Morgan

I’d need to generate SQL dumps to store in a version control system. I’m not asking for advanced features like upgrade/downgrade scripts or the like....

Álvaro G. Vicario

08-12-2008 04:37 PM
joel garry

I cannot seem to find any good documentation on this: We have a user logging in and executing a procedure which creats some data to be inserted into...

artmerar@yahoo.com

08-12-2008 01:49 PM
Mark D Powell

I have an Oracle database containing several tables with LONGs - not LONG RAW, just LONG. These tables were accessed by a VB application using ADO...

Spiggy Topes

08-11-2008 01:58 PM
fitzjarrell@cox.net

Hi, I am fighting with PL/SQL and loosing... I have a database that changes on a regular basis and has over 200 columns... and the data needs to be...

bpfh

08-11-2008 10:48 AM
Aya the Vampire Slayer

Hi, We have a 10g service that is load balanced between 2 RAC nodes. We noticed that query runs about 3x slower if the service is load balanced on...

mike

08-09-2008 12:31 PM
Mark D Powell

Hi Oracle license says, that standby node does not need a license if its not used for more then 10 days per calendar year. How can i obtain this...

fiedzia

08-07-2008 07:21 PM
DA Morgan

Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED

artmerar@yahoo.com

08-07-2008 02:33 PM
DA Morgan

Hi there. We're running: Oracle9i Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production "CORE 9.2.0.8.0 Production" TNS for...

Adam Cameron

08-07-2008 12:53 PM
Adam Cameron

Hi, how correct is the following diagram showing modules of a DBMS ...???? http://i529.photobucket.com/albums/dd339/aarklon/5.jpg

aarklon@gmail.com

08-07-2008 11:01 AM
Mark D Powell

Hi, someone could help me? I have a database link to a SQL Server 2005 that is used to insert data from Oracle to SQL Server Database. When I try to...

Oberdan Nunes

08-07-2008 09:53 AM
Oberdan Nunes

Hello, is it possible to set the elements of a VARRAY in a loop instead of initializing it in one step? Does anyone have a sample for me? Is it...

Norbert Pürringer

08-07-2008 03:46 AM
metzguar

Hi, I've been looking at REGEXP_LIKE to help me come up with a way to check the syntax of an email address. Basically I need to make sure that is...

artmerar@yahoo.com

08-06-2008 06:26 PM
Malcolm Dew-Jones

I'm currently looking for an example on how to code this, but maybe I can take a shortcut and someone will do it for me. LOL Anyhow, I need a...

artmerar@yahoo.com

08-06-2008 03:56 PM
artmerar@yahoo.com

Hi All-- I have a machine running 9.2.0.6.0 on Windows 2003. I would like to confirm whether it is Standard or Enterprise Edition that...

jeffbam@yahoo.com

08-06-2008 03:23 PM
fitzjarrell@cox.net

We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no...

BobsGTalk@gmail.com

08-06-2008 03:19 PM
BobsGTalk@gmail.com

I have two tables: "Old" and "New". Both table have the same primary key name and type: "PKEY", NUMBER. "Old" table has a column called...

JBond007

08-06-2008 12:04 PM
Mark D Powell

Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the...

Murali

08-06-2008 11:35 AM
Mark D Powell

I'm doing some work with 9i application files and need some definitive help - what is launch.exe w/respect to a 9i installation? Is it a core...

Den.Higgins@gmail.com

08-06-2008 10:41 AM
Den.Higgins@gmail.com

Hello- I'm looking for advice on a problem I've hit with Oracle 10g spatial. I am storing a large number of rows with a feature_rectangle...

john.e.major.jr@gmail.com

08-05-2008 07:54 PM
Pedro Lopes

Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED

artmerar@yahoo.com

08-05-2008 07:28 PM
DA Morgan

Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED

artmerar@yahoo.com

08-05-2008 11:47 AM
artmerar@yahoo.com

Hi, Does anybody know Oracle AD4J? I´ve got the AD4J-Console running on Suse Linux and the agent-file upon JBoss (Suse Linux, too). The console...

marton.szabo@ivz.de

08-05-2008 10:59 AM
marton.szabo@ivz.de

hi, in windows xp when you create an oracle DSN using %SystemRoot% \system32\odbcad32.exe then by default - enable result sets - enable query...

strepxe@yahoo.co.uk

08-05-2008 10:52 AM
strepxe@yahoo.co.uk

Can anyone suggest a way of Replicating a group of tables from one database out to another under these conditions: + Source database is version...

David Gempton

08-04-2008 05:55 PM
David Gempton

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning and Oracle Data Mining options JServer Release...

Ed Prochak

08-03-2008 10:15 PM
Malcolm Dew-Jones

Hi all, BCNF the following is the definition is the definition of BCNF , which i saw in a schaum series book 1) The relation is 1 N.F 2) for...

aarklon@gmail.com

08-02-2008 07:39 AM
David Portas

In Oracle forms (10GR2, though I doubt that makes much difference). I am trying to find how to do the following, feedback appreciated. A form can...

Malcolm Dew-Jones

08-01-2008 05:53 PM
Malcolm Dew-Jones

"Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production" and forms (fmb) that come with the that version of developer. Say I have a...

Malcolm Dew-Jones

07-31-2008 09:08 PM
Malcolm Dew-Jones

I use Oracle snapshots a lot.... But often I find that they do not offer all the replication features I'm after. So I have developed a software...

David Gempton

07-30-2008 06:40 PM
David Gempton

Am trying to do restore of control file on Linux Machine 64Bit CenTOS5.2, i get the following RMAN> restore controlfile; Starting restore at...

madunix

07-30-2008 03:24 PM
Shakespeare

Hi Guys, I am trying to bild a cursor based on a select statement which returns values between a certain date range. I have read that it is...

Chris

07-30-2008 06:23 AM
Chris

Hi! Well, interesting piece of software this new Legacy7. Would it be possible to port it to use Oracle? (without sourcecode ;) Now it uses MS...

Jack

07-28-2008 02:57 PM
Jack

http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9110624 -- David Portas

David Portas

07-28-2008 02:38 PM
Jack

Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i...

ranganadh

07-28-2008 02:22 PM
fitzjarrell@cox.net

Hi, We are migrating from Oracle 6i to Crystal Reports. Oracle reports were built using Oracle 6i Data Wizard and Query Builder. How can we see the...

bang123

07-28-2008 01:13 PM
Malcolm Dew-Jones

Hi all, I read the following in a book 1) we can have several non clustered indexes on a table , but we can have only one clustered index per...

aarklon@gmail.com

07-28-2008 10:15 AM
aarklon@gmail.com

I'm setting up Oracle libraries in a Windows Server box so two PHP web sites can access a remote Oracle 10g database. I've downloaded the Instant...

Álvaro G. Vicario

07-25-2008 02:03 PM
joel garry

Hi, i have been using setString() of prepared statement. but it is giving me java.sql.SQLException: Data size bigger than max size for this...

uday

07-25-2008 10:13 AM
Laurenz Albe

I am usint 10g. I know that you can put a decode in the order by section. But I tried to see if it is possible to put a case statement in the order...

Rich

07-24-2008 10:18 AM
Gints Plivna

Hi all, I recently read the following in a book(oracle 9i for dummies by Carol McCullough Dieter) The fastest way to retrieve rows from a table is...

aarklon@gmail.com

07-24-2008 10:00 AM
aarklon@gmail.com

Hello, First of all I have no experience on Oracle. I'm simple programmer with task out of my skills. I was given task to restore database to a new...

Kake

07-23-2008 01:29 PM
Kake

hi ng, sorry for the subject, it is a difficult to write it in two words. <oracle 9.2.0.7/9.2.0.8; cost based optimizer; VMWare ESX- server;...

Andreas Mosmann

07-22-2008 02:18 PM
joel garry