I have 2 pc's on my local net. On 1st is oracle (xe 10.2, win xp), on 2nd is oracle client. When I use tnsping from 2nd to 1st (to DB server), every...

buu

12-05-2008 10:24 PM
Michael Austin

Not sure if this is a good place to post, but we're trying to reverse engineer an Oracle database which has two fields for date & time. They...

Rob Nicholson

10-29-2008 05:27 AM
Phil Carmody

Table name: table_a, table_b size of both tables: ~500M case 1) select a.feld1, b.field1 from table_a a, table_b b where a.field1 = b.field1...

News.netvigator

04-24-2008 12:25 PM
News.netvigator

Let me first describe the tables I'm working with: table1 with these columns: user_id cat_id more_data even_more_data table cat_id table1 may have...

LorenzoPT

04-16-2008 05:40 AM
Tim X

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 11:17 AM
GPD

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 11:15 AM
GPD

I thought I had donw this before but cant see a way how. Am sure I once opened a table and amended some data. Anyone know if possible or how, any...

GPD

03-26-2008 11:13 AM
GPD

I am getting the following error message on my oracle database. This is a database that was created in 1999 and houses our MRP system for my work. ...

Brian

11-08-2007 03:30 AM
Lodewicus Maas

Hello, I would like to install Oracle 10g in my Ubuntu Linux. I have read in a book that Oracle needs access to /u01.../u0X. What does this mean? I...

R.A.M.

09-18-2007 10:23 AM
R.A.M.

http://www.tompall.us/TomPall.doc

TP

07-11-2007 04:16 PM
TP

Hi, I try install http://plpdf.com/index.html on Application Express 2.1.0.00.39. I can't compile plpdf package. I have error RA-06502: PL/SQL:...

Tomek

06-25-2007 09:03 AM
Tomek

How to get type of input parameter into the PL/SQL? -- Thank you, De Cool, EPE, Ukraine

Dmitry Kulinich

05-31-2007 08:06 AM
Dmitry Kulinich

I have worked a lot with dBase (version III upto version 7). Is there a lot of difference between Oracle and dBase? Programming in dBase and visual...

nospam

05-22-2007 10:52 PM
EricF

Hi guys I seem to have a problem with my DB ORACLE 8.1. Since I'm having problem with tables hanging I've made a test procedure that INSERTS A...

daniele

04-21-2007 07:55 PM
daniele

Please what's the best tool i can use to transfer data from one Oracle DB to another

Jubri

04-15-2007 01:41 AM
JP

Sorry to bother you all with whith what is a possibly simple question. I had XE-Universal installed on a CentOS server at home to do stuff outside...

Rob Bradford

03-15-2007 08:45 AM
Rob Bradford

Hello All, Does anyone know how to translate this mysql statement into oracle statement. It's about calculate binairy numbers. Where the pipe is...

Rob

03-07-2007 04:39 AM
Rob

How I can execute base synchronisation between oracle and OID?

posty

01-26-2007 05:33 AM
Johan Louwers

Hello! I would be grateful if somebody clearify me the issue described below. I don't know how is is posibble that the size of tablespace is smaller...

Marcin Hirszberg

01-23-2007 06:13 AM
Marcin Hirszberg

Hi, I am new to Oracle and wonder someone may help for the question. In Oracle Database Concepts 10g Release, it said one can close a database;...

Hong Hsu

12-09-2006 02:04 PM
Peter Jamieson

Hi, I am new to Oracle and wonder someone may help me the question. From Oracle Database Concepts 10g Release, it said one can close a database;...

Hong Hsu

12-09-2006 02:02 PM
Peter Jamieson

spare brain wrote: You are also dealing with an inability to follow usenet rules and only place your message into a group one time and...

Daniel Morgan

11-18-2006 01:12 PM
TGGA

How is this done in Oracle? Do I have to fetch all records and get the count from that or is there a better way?

Lorenzo Thurman

11-02-2006 05:38 AM
Thijs

Hi, I'm trying to produce a stored procedure or function which would allow me to fetch tree data stored in a table. Records of this table looks...

wish

10-15-2006 10:00 AM
KM

I have been searching for answers to this question ... but all I have found is other people asking the same question..but I have not found an...

riggor

10-12-2006 05:23 PM
riggor

Hi How I can do upgrade database for Oracle 8.1.7. to Oracle 9. Please help me. Thanks Slawek

slawek

09-26-2006 10:44 AM
Daniel Stragowski

I have some very large tables divided into yearly archives. I want to run a report where the user enters the date range of the data desired. The...

MartyL

09-22-2006 02:45 PM
MartyL

http://datamining.eruditionhome.com/forum/

09-21-2006 01:44 AM

Is there a DB solution that will query a sizeable excel file with multiple worksheets. Can anyone recommend a DB program that will do this? Or is...

Felix Becerra

09-16-2006 01:38 PM
Master Blaster

Hopefully the subject said it all. I have a sales table with a row per sale and each row has a sale_date column. I want to calculate average sales...

Matthew Wilson

09-13-2006 11:32 AM
Matthew Wilson

Hi everyone I would like to know if using several views for a complicated query is slower than placing all the code in one large query. I had heard...

Jeff User

09-12-2006 01:17 PM
Acme Acmeson

Hi I'd like to known the best (reccomended if any have experience) server hardware configuration and os for install oracle database 9i. Thank you.

libre

09-12-2006 11:40 AM
Jim K

Hi All, I am trying to load a tab delimited (text file) with the help of a procedure. To access these files I have to create an Oracle directory....

anand b

09-11-2006 09:17 AM
anand b

We have a tablespace including an Oracle sequence. One of our sites is required to reboot the server under certain circumstances, and sometimes when...

David Shochat

09-10-2006 04:40 PM
Acme Acmeson

Hi, I'm teacher and i want to show my students ORACLE XE. Could someone tell me is there any good free, open source, shareware, trial software for...

kiel44

09-08-2006 03:54 PM
Matthias Hoys

Hello, help me please. I have stored procedure in Oracle server. This is simple fragment: procedure ABCD() IS ora_table_name VARCHAR2(20); BEGIN

artur

09-07-2006 05:09 AM
artur

Hello Doers anyone of you know how to parametrize SQL script ? I have one in *.sql file and want to have one or more parameters in it, wich user has...

Czujnik

09-07-2006 04:54 AM
Ariel

Hi, I have a problem and would invite any assistance available. I am working on a database table, with approx 2.5 m rows, the structure of the...

gjeff@chariot.net.au

09-07-2006 04:47 AM
Ariel

I'm reversing the normal order of LIKE, with the column on the right side: SELECT domain FROM tbl_domain WHERE 'com.hotmail.subdomain' LIKE domain...

Ariel

09-07-2006 04:27 AM
Ariel

Hi how in Oracle build cross query like in MS Access in MS Access I have: TRANSFORM Sum(t1.war) AS SumaOfwar SELECT t1.id, t1.name FROM t1 GROUP BY...

t

08-29-2006 03:47 AM
t

Does anyone has sql tuning tools for oracle recommendation? thanks

abby

08-15-2006 05:12 PM
Matthias Hoys

Hello, I have installed Oracle 10g. How can I check whether everythink passed. Should I create simple database or something else? Please help Thank...

RAM

08-04-2006 10:09 AM
carlos.escobar

Hi all, I'm new to oracle programming, in fact i'm in training to become a dba where i work, my problem is, i have made a function in PHP using ADODB...

carlos.escobar

08-03-2006 06:51 PM
carlos.escobar

Hello! I am opening a form name "Martin", then I open a form "Ann" and then report "John". How to close a form Martin and Ann form while closing a...

Kamyk

07-25-2006 02:11 PM
Kamyk

hello it is possible in oracle 10g to implement history which remember which row in a table was read by a user? thanks in advance Peter

Piotr Kozak

07-18-2006 09:53 AM
Piotr Kozak

Hello, I have a little problem with configuration outpost firewall ~ oracle 10g. When I try to install database outpost do some kind of reset and...

colin

07-12-2006 04:36 AM
colin

Hi, I work with Oracle HRMS and I want to link some custom workflow to the business events. I have tried to find some documentation that explains...

PAUL MADDSION

07-02-2006 05:27 AM
PAUL MADDSION

Has anyone been able to install Workflow over Oracle 10 Express on a Windows XP pc? If so could you please give me a few pointers. Thanks, Gary

Gary

06-29-2006 03:55 AM
Robbert van der Hoorn

Hi, i have a little proble with Oracle 10g XE. In our company we have full oracle 10. Now we have to do backup server so we choose XE edition. But...

kiel44

06-28-2006 04:31 AM
kiel44

Hi, We just migrate some pc from windows 2000 to Windows XP Some of our SELECT are now very slow, even if we don"t change any parameters. When I...

tsc1

06-27-2006 09:42 AM
tsc1