Hello! I have DB Link defined in my Oracle DB I work with from JSP application which uses Tomcat's connection pool. When remote DB is available,...

Dmitry Bogdanov

02-11-2006 11:03 AM
Mark D Powell

Hi All, Please correct me if i am wrong. Internally, the order of execution for a SELECT statement is as follows: FROM clause WHERE clause SELECT...

Pria

02-11-2006 10:52 AM
Mark D Powell

Hello, I have a file with one statement INSERT INTO COPS.PRODUCT_TITLES (ISBN, TITLE) VALUES ('1230512980', ' Lab Activities & Long-Term Projects,...

laredotornado@zipmail.com

02-10-2006 03:24 PM
Michel Cadot

I'm trying to run SQLPLUS from within a Tomcat CGI script. I have had no trouble running this same script on Apache and IIS web servers but in this...

durang

02-10-2006 02:19 PM
durang

Hi all, i am working with Oracle 8.1.7.0.0 and need to keep updated one table with the changes from another table. The idea i am following is...

Fabio

02-10-2006 10:22 AM
DA Morgan

Does any one know how/if you can use an Oracle Stored Procedure to run a Crystal Report?

paulhux174@hotmail.com

02-09-2006 01:36 PM
DA Morgan

How do I join two column in two tables were I only use the first three characters in one of the tables?

tuxfan

02-09-2006 01:13 PM
Mark C. Stock

I'd like to know what are the requirements of Oracle 8 and 10 (standard edition one) database licensing, specifically, 1. If we had bought a 5-user...

roy

02-09-2006 11:24 AM
HansF

Hello, I have written some PLSQL packages in ORACLE. I want to know if a PLSQL program which gives all the packages used in a package...

anonymkim

02-09-2006 10:54 AM
DA Morgan

There is a tables: create table stat -- about 2,000,000 records and 500,000 records with finish_date is null ( User_id number, Start_Date...

grrey@mail.ru

02-09-2006 07:58 AM
sybrandb@yahoo.com

Hi all. There is a table with about 3,000,000 recs in a month: create table Log ( User_id number(12), Date_time date, kind number(1) --1 for...

grrey@mail.ru

02-09-2006 06:22 AM
grrey@mail.ru

Guys: In MS SQL server, there is a utility called Profiler which can be used monitoring real time SQL traffic between the client and SQL server so...

andy zhu

02-08-2006 04:44 PM
DA Morgan

Where do I get Oracle 7 Downloads for Solaris and Windows Platform ? Thanks

Swapnil

02-08-2006 11:02 AM
DA Morgan

I have a problem while understanding the query.....I want to explain it clearly..... My Tables are 1.suppliers 2.parts 3.catalog The tables and...

Ramu

02-08-2006 03:53 AM
Ben de Boer

Hi, just made a post in the PHP group, but my feeling is I'm missing something I need that will come from oracle, and I wondered if someone in the...

DravenStone

02-08-2006 02:50 AM
Laurenz Albe

Hello In statspack report there is a "SQL ordered by Parse Call" section, does this is related to "Hard parse" or does this include Hard and Soft...

nonor

02-08-2006 02:05 AM
nonor

Hi all, I'm trying to use a custom function in a query I want to use. The custom function I've written takes two numeric arguments, and return...

ian

02-07-2006 03:02 PM
ian

Hello, I am getting the following error: ORA-01089: immediate shutdown in progress - no operations are permitted I ran 'shutdown immediate'. then it...

hanu

02-07-2006 02:52 PM
hanu

I have two tables The first one is tblItemDB has two columns (ItemID, ComponentID) The second one is tblItemInfo has three columns (ItemID,...

Vovan

02-07-2006 02:35 PM
Michel Cadot

Right I am trying to load some data using sqlldr into Oracle 9. I have a table that contains a varray, which is declared thus: type...

Kevin

02-07-2006 02:13 PM
Andy Hassall

OMNI GROUP tgugger (AT) sbcglobal (DOT) net 419-537-9447 IMMEDIATE NEED

OMNI GROUP

02-07-2006 01:12 PM
OMNI GROUP

Hi, Can anyone explain how "alter table x move tablespace y" ended up using more space in table x than was the case before the move. I'm looking in...

zarleyman

02-07-2006 11:07 AM
zarleyman

Hi guys, When we execute a select stmt in sqlplus we don't get the column headings full , it is shown according to the data in that column. So, i...

mohd.shihabuddin@gmail.com

02-07-2006 10:27 AM
mail2jerry@gmail.com

Hi, Trying to move a WAS 3.0 PL/SQL Web based application to Oracle 9.2.0.7 with Apache Web Server. I have been able to get a html page loaded, but...

Craig & Co.

02-06-2006 01:42 PM
Frank van Bortel

Is there an SQLDMO like product for Oracle? I want to be able to manage tables and views from C# code. Also, if this post is inappropriate for this...

narayan.k.verma@gmail.com

02-06-2006 01:41 PM
DA Morgan

I have a report query that current looks something like this: SELECT * FROM lookuptable, childtable where lookuptable.id = childtable.fkid AND...

bbcrock@gmail.com

02-06-2006 01:01 PM
DA Morgan

Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 10g Monitoring & Security Application (Xg). Xg...

teraknowledgesystems@hotmail.com

02-06-2006 11:20 AM
DA Morgan

Hi! I have a little database problem, and I can't figure out if there's a solution in Oracle: I have a database of...

Marco Dieckhoff

02-06-2006 07:05 AM
Volker Hetzer

OMNI GROUP tgugger (AT) sbcglobal (DOT) net 419-537-9447

OMNI GROUP

02-05-2006 09:39 AM
OMNI GROUP

OMNI GROUP tgugger (AT) sbcglobal (DOT) net 419-537-9447 ORACLE TECHNICAL FORMS & REPORTS DEVELOPER/ BOSTON AREA

OMNI GROUP

02-03-2006 05:56 PM
joel-garry@home.com

Hello, Am I wrong or under AIX 5.3 with Oracle10g the (very) old oci 7.x is not (anymore) supported ? I've searched into libclntsh.a (under...

stef

02-03-2006 08:21 AM
Mark D Powell

I know this was discussed recently, but I am still uncertain and would very much appreciate an answer. I have a vendor that needed a db created for...

Randy Harris

02-03-2006 08:15 AM
Mark D Powell

Could anyone tell me whether you have to install the complete Client (ver 9.2) in order to install the driver I have an application that only...

David Wood

02-02-2006 04:32 PM
Andy Hassall

I am new to databases and today is the first that I'm working with ORACLE. I am switching for MySQL to ORACLE and trying to decide which template to...

g_chime@yahoo.com

02-02-2006 04:18 PM
Geoff Muldoon

Greetings, A group of developers at my company are looking for a customized oracle 10g training class to be held on-site in New Jersey. They are...

josephdeveloper@gmail.com

02-02-2006 01:49 PM
josephdeveloper@gmail.com

Dear SBCGLOBAL. Your customer is continuing to ignore the charter of the usenet group comp.databases.oracle.misc and is posting commercial messages...

DA Morgan

02-02-2006 11:54 AM
DA Morgan

Hi Im trying to call a Functon in a package in Oracle 9i, from VBscript but i'm getting the following error: ORA-06550: line 1, column...

jose luis

02-02-2006 10:14 AM
jose luis

Is there any other way to get Oracle Patches (Oracle 9i) appart from metalink ? Is there any Sample Patch with Oracle installables or ORACLE_HOME...

Swapnil

02-02-2006 07:29 AM
sybrandb@yahoo.com

SQL> desc dept Name Type ---------------- ------------- DEPTNO NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) SQL> desc...

Prasath

02-02-2006 06:30 AM
sybrandb@yahoo.com

Hi, I need to set up a generic table in Oracle that allows users to enter data that can later be retrieved in reports. I was thinking of a 3 column...

anasttin@excite.com

02-01-2006 10:50 PM
Mark Townsend

Hi everybody.. I'm trying to execute a stored procedure in orecle, from my visual basic script. How can i do this? and how can i display the results...

jose luis

02-01-2006 01:03 PM
DA Morgan

Greetings, Which is better, performance wise. Using "BETWEEN" clause or using "<=" or ">=" clause. Just wanted to know performance significance,if...

pankaj_wolfhunter@yahoo.co.in

02-01-2006 12:19 PM
DA Morgan

Hello Partner, Please forward some good resumes with excellent communication skills. ATG Dynamo Developer Location: Minneapolis, MN Duration:...

swaroopa

02-01-2006 12:18 PM
DA Morgan

Hi All, I am in a dilemma where I wastoldby other developers in my team that complex stored procedures are not used for accessing oracledb where...

sb

02-01-2006 12:16 PM
DA Morgan

Using decode in Oracle I get the following (text wrapped here): DESC START_TIME SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY WATCH...

oaksong@hotmail.com

02-01-2006 12:13 PM
DA Morgan

I want to implement a simple employee, department relationship. Only condition is that an employee can belong to multiple departments. Do I go...

Prasath

02-01-2006 12:11 PM
DA Morgan

I am new to this news group and hope someone here can point me in the right direction for this question. I am trying to understand why the SQL in...

MellyGirl

02-01-2006 11:20 AM
Prasath

Hi! I'm trying to use dynamic sql to call a procedure. The procedure that is called depends on the value of a certain variable (l_source in my case)....

kwadratus

02-01-2006 02:40 AM
kwadratus

Hi all, I want to analyse a 9i table in a way that will provide me with summary information about the contents of each column, like this: col_1 :...

tarbster@yahoo.com

01-31-2006 07:21 PM
Mark D Powell

pankaj_wolfhunter (AT) yahoo (DOT) co.in wrote: Assuming the answer would be the same for every version of Oracle from 2.3 through 10.2? If you...

DA Morgan

01-31-2006 05:34 PM
pankaj_wolfhunter@yahoo.co.in