Hi Techies, Am really new with the Oracle 9i Forms and am searching for a way to perform Load Balancing in Oracle 9i Forms Application. Its not a...

yagish

07-22-2004 08:06 PM
Ana C. Dent

Hi, We need an Oracle expert to help us convert a SQL appication to Oracle for a particuler project we're working on. We have all the stored procs.,...

Steve Wells

07-22-2004 12:34 PM
Steve Wells

Has anyone created a user function to return the ordinal position based on numeric input? In other words, f(1) returns 'st', f(2) returns 'nd', ...

Terry Coccoli

07-22-2004 11:32 AM
Mark D Powell

Folks, In INFORMIX there is a default value called DBSERVERNAME that can be assigned to a column during the table definition as follows: create...

Rajiv Jhaveri

07-22-2004 10:58 AM
Rajiv Jhaveri

Hi. I have a stored procedure on a Oracle 8.1.6 database that generates a dynamic sql statement. This stored procedure has an output parameter that...

Robert Scheer

07-22-2004 10:03 AM
Robert Scheer

Very strange behavior - I ran into a scenario where the CBO (Oracle 8.1.7) actually computed a negative value for a cost of a query (and in turn,...

Kevin

07-22-2004 03:58 AM
sybrandb@yahoo.com

I need help trying to optimize a SQL query. I am using Oracle 8i. I have a table with about 1.2 million records, lets call it T1. I am doing a join...

Haider Kazmi

07-21-2004 09:03 AM
Misho

Hello there! I am trying to put together a list with criteria which are considered important for consolidating Oracle Database Servers. If someone...

Demetris

07-21-2004 01:35 AM
Demetris

I am fairly new to Oracle and I would appreciate if some one can point me to a right direction. I have store procedure that takes about 3 minutes to...

Gene Ariani

07-20-2004 09:30 PM
Bricklen

I'm posting this in hopes that it will help a few folks out when the search Google Groups. I was having the following problems with Oracle 10G: 1....

Captain Obvious

07-19-2004 11:55 PM
Captain Obvious

Hi, I'm trying to write a view that returns a historical view of records as of a certain date. The records come from a live and historical table and...

Mark

07-19-2004 03:40 PM
Wit Serdakovskij

Table A Name Score A 12 A 22 A 88 B 34 B 12 C 33 C 55

David

07-19-2004 03:28 PM
AK

Hi, I want to insert the result of a select into a procedure-variable within a while-loop. The loop works as far as I don´t insert...

bert

07-19-2004 12:56 PM
Ed prochak

I've read (and lost the reference) that when doing joins of this form: A.col = B.col and A.col = C.col It is "helpful" to explicitlty add...

bugbear

07-19-2004 11:15 AM
bugbear

Hi I want to extract some chinese data. data are stored in ORACLE 8 (DB Character Map is US7ASCII) but data are using NLS_LANG...

Dhwan Kim

07-19-2004 05:05 AM
Dhwan Kim

can not open database because of this, what I can do in this sceneiaro? complete or incomplete recovery? database was closed because of media crash....

Niy

07-19-2004 04:04 AM
sybrandb@yahoo.com

Hi, I need to access more that 1 instance, is there a way to start a new connection from a pl/sql script ? eg. inst1 has table I1 inst2 has table...

naimy

07-19-2004 04:02 AM
sybrandb@yahoo.com

Hi, I am looking for a library(j, c++, or algorithm) which can check and correct sql. For example, if I have selet * from employee where id in...

quikquic@yahoo.com

07-17-2004 10:37 PM
quikquic@yahoo.com

HI, I'm trying yo improve the performance of the following piece of code. Here I'm archiving Items that are done processing to Archive Tables. I...

Diego

07-16-2004 11:59 AM
Diego

Our client is a major bank and we have the following immediate requirements. Oracle Data Warehousing Consultant We need 2 resources with the...

Bevertec

07-16-2004 08:10 AM
Mark D Powell

Hello, I want to return multiple queries from a procedure in Oracle, I know that o can do that with REF CURSOR. But I have a problem I have a query...

Urko

07-16-2004 04:10 AM
Urko

Hello, I want to return multiple queries from a procedure in Oracle, I know that o can do that with REF CURSOR. But I have a problem I have a query...

Urko

07-16-2004 04:09 AM
Urko

I have tried to solve this on my own for a long time now, so i really need some help here... I use Oracle 10.1 and SQL *plus 10.1. How do i update...

amwi

07-15-2004 01:10 PM
Ed prochak

Hi, For Oracle 9i, the sample make file for the Oracle Pro*COBOL precompiler has a hard-coded list of programs in it. Has anyone created a generic...

VictorReinhart

07-14-2004 10:22 AM
VictorReinhart

Hi All, I 'm using Oracle 8i and i have a table table1 with two columns: COL1 not null COL2 DEFAULT 'N' if i make an insert : insert into...

was

07-14-2004 10:21 AM
Wit Serdakovskij

Hi All, I 'm using Oracle 8i and i have a table table1 with two columns: COL1 not null COL2 DEFAULT 'N' if i make an insert : insert into...

was

07-14-2004 09:42 AM
was

Please see output below: Why is there considerably more activity on RB1 compared to the rest? Can someone please explain the stats to me, or at...

David Brent

07-13-2004 09:11 PM
Ana C. Dent

Hello -- I am trying to optimise a JDBC connection and an Oracle 9i database for reading millions of records at a time to a 1 Gig PC running...

Howie Goodell

07-13-2004 08:40 PM
Jim Kennedy

Hi, On my first oracle instance, I have a global type 'productarray' (CREATE OR REPLACE TYPE productarray AS TABLE OF VARCHAR(30)), I have a package...

Steph

07-13-2004 11:43 AM
Mark D Powell

when i run the statement: SQL> select rowid from student_semester; ERROR at line 1: ORA-01445: cannot select ROWID from a join view without...

tracy

07-12-2004 11:55 PM
kaapie

I have a web page that connects to oracle 8i via .net and get a "could not resolve TNS service name" when I try to connect. what am I doing wrong? to...

nadsie

07-12-2004 08:06 PM
nadsie

I have talked to Oracle customer support and they tell me that i cannot order un-supported software anymore. I have even searched on Ebay to see if...

Ali Zaidi

07-12-2004 12:20 PM
Ali Zaidi

New to oracle, but I'm coming from the sybase side. I took over one of our oracle production databases (1.5 Tb) while the regular dba is out. I got...

gecho

07-12-2004 10:28 AM
Mark D Powell

Hello, I am using Oracle 10g and have configured OEM grid control. I am searching for some tool like Capacity Planner which was present in Oracle 9i...

Shailesh

07-12-2004 05:46 AM
Shailesh

in Ingres I can do this update table1 from table2 set table1.field = table2.field where table1.id = table2.id is there an equivalent in Oracle...

michael newport

07-12-2004 02:07 AM
michael newport

Hi, I have installed oracle9i(9.1.0.1.0) in win2000 (single pc). I want to create a new database manually . If anyone willing to help me it will...

oracle

07-11-2004 11:19 PM
Hans Forbrich

bsc7080mqc (AT) mylxhq (DOT) com wrote: Have you looked at Oracle's Workflow functionality? That shows a number of tricks, especially related to...

Jack Parker

07-11-2004 06:07 PM
Hans Forbrich

A weird issue...though hopefully not for everyone... I am trying to connect to a 10g database on a Red Hat Linux server from my 9i client on a XP...

Chris

07-10-2004 10:16 AM
Chris

Hi guys - I have a weird condition here I'm trying to get resolution on, and unfortunately I'm not getting anywhere with my friends at Oracle. I'm...

Dan Loomis

07-09-2004 10:22 PM
Dan Loomis

Hi, I have a question about how to retrieve the information of the calling instance, such as instance name, in an external C procedure. Thank...

Carlo Chung

07-09-2004 07:59 PM
Mark D Powell

Hi! Where running Oracle database 9.2.0.1.0 on Sun Solaris 8 7/01 (SPARC platform). I'm trying to use the OS authentication method for a user owning...

Christian Eriksson

07-09-2004 06:14 PM
Christian Eriksson

Hi All, I am suddenly in a position where I need to learn to be my own Oralce DBA. I have limited experience with Oracle and haven't ever...

Diana

07-09-2004 12:01 PM
Diana

It is the innovative way of keeping all your Favorite URLs on the web. http://www.linkmemory.com You come across many new websites each day. You...

LinkMemory

07-07-2004 10:58 PM
LinkMemory

Hello, I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code of the PACKAGE BODY. Currently the only means I know of is TOAD's...

george lewycky

07-07-2004 05:30 PM
Chris

I'm having problems with the output of the following script (I've simplified it):- select a.section,a.user,count(b.number),null from table a, table...

Chuck100

07-07-2004 12:37 PM
Chuck100

I'm trying to perform this insert in a non-procedural environment: INSERT INTO table (column1, column2) SELECT :col1value, MAX(column2) +...

Elliott

07-07-2004 12:12 PM
D Rolfe

What are the best tools/apps for creating spreadsheet reports generated using an Oracle database? Considerations include cost, simplicity of use,...

Joe Powell

07-06-2004 08:29 PM
Hans Forbrich

Please let me know how I can Load a packed decimal date coming from a file from mainframe be loaded into a Oracle table date column? Any help will be...

tamrakar

07-06-2004 06:53 PM
Davis

Hi. We had a PC that had Oracle Client 8.0.5 and 8.1.7 installed in Default_Home (c:\orant) and Default_Home1 (c:\oracle). A third party package,...

John

07-06-2004 11:08 AM
Mark D Powell

Hi. I have a number of batch jobs that are ran nightly on our Windows 2000 based Oracle 8.1.7 (soon to be 9i) server. I have these designed just...

John

07-05-2004 11:22 AM
doug