The following query will return 3 word in 3 "TABLE COLUMN", How can I modify the query to return "NO 3 words are the same"? the following Table will...

Carl Forsman

02-28-2009 05:29 AM
Maxim Demenko

Hi, Hoping someone can help me here. I have an Oracle package which contains a lot of SQL and I can view the top SQL using apex but it does not show...

Martin

02-27-2009 06:07 AM
Martin

This is interesting. Say I have a package with a function in it. The function is local to that package only and is not called from...

Mtek

02-27-2009 04:23 AM
Bobby Z.

Hi, ManyDesigns announces that there is new open source web framework that runs with Oracle. This framework is ManyDesigns Portofino. ManyDesigns...

Angelo

02-26-2009 09:13 AM
Angelo

Hello, what is the size of the Oracle datatype NUMBER in bytes? Thank you, Norbert

Norbert Pürringer

02-25-2009 03:54 PM
Mark D Powell

Hi Gang I have a table that has the following. Part Revision AA1234 1 AA1234 2 AA1234 3 BB8877 1 BB8877 2

Andy

02-25-2009 02:05 PM
Michael Austin

The following query will output 2 word that's close in position, but how can I output 3 word that's close in position instead of 2 word? the query...

Carl Forsman

02-25-2009 02:56 AM
CarlosAL

Hello, Can you have a select statement that returns a literal AND normal query results without a UNION? Say I have a parameter, like and employee...

mrdjmagnet@aol.com

02-24-2009 08:45 PM
Michael Austin

Hi, I am new to Oracle and I was wondering if someone could help me with a query. Basically, what I want to know is how to return all the columns...

Pete

02-24-2009 08:26 PM
jgar the jorrible

Why the following query does not work? select a.Word, b.Word a.Document from data where ABS(a.Position - b.Position) < 3 and a.Document =...

Carl Forsman

02-24-2009 07:33 AM
Álvaro G. Vicario

Here's a question from a coworker. The data type is a video timecode, which is a standard used in video cameras, video editing programs, and video...

mh@pixar.com

02-24-2009 05:32 AM
Laurenz Albe

Is there any client setting to abort queries that take longer than X seconds? I'm developing web apps written in PHP 5.2 running as Apache 2.2...

Álvaro G. Vicario

02-23-2009 07:38 AM
Álvaro G. Vicario

Sheesh, how hard can this be: IF p_code IN v_code_list THEN v_query := v_query || ' AND p_code IN v_code_list'; END IF; Does not like that. The...

Mtek

02-21-2009 06:49 PM
William Robertson

Hi, I have a .NET application which gets back a CLOB from the oracle database. I'm using OracleParameter("name", OracleType.Clob) for the parameter...

stas1979@msn.com

02-19-2009 10:26 AM
Vladimir M. Zakharychev

(paypal payment)(www.king-trade.cn ) Electronics Vertu Mobile New iphone Mobile Nokia Mobile moto Mobile PSP Game & memory card Sony Mobile ...

88suwhjh@sina.com

02-19-2009 04:30 AM
88suwhjh@sina.com

Is there a simple way to use a previous result in an ORDER BY clause? I have a rather complicate query that filters, sorts and returns a series of...

Álvaro G. Vicario

02-17-2009 06:22 PM
Charles Hooper

I am getting unexpected results from a Select statement which uses Cast to tuncate strings. In the query below although I get the expected result in...

Ken

02-17-2009 03:26 PM
Shakespeare

Hi, I'm using Oracle 10g and trying to compile a package. But my PL/SQL Developer tool complains at this line: show err package body...

laredotornado

02-17-2009 01:23 PM
ddf

Hello, for some reason I need something like a "select 123 as abc from dual;" but with several result rows rather than one. The result should...

Hans Mayr

02-17-2009 04:44 AM
William Robertson

Hi all, I have a cross-reference table which stores student class enrollment info: Table Name: ENROLLMENT_XREF XREFID STUDENT CLASS ------ ...

hotima

02-16-2009 10:22 AM
Mark D Powell

(paypal payment)(www.king-trade.cn ) Electronics Vertu Mobile New iphone Mobile Nokia Mobile moto Mobile PSP Game & memory card Sony Mobile ...

jkskjfks

02-16-2009 03:27 AM
jkskjfks

Hi, I've a package that generates some table records with some random chooses (2-5%). But the steps to generates the random sample need a little bit...

Norbert Winkler

02-13-2009 05:48 PM
Gints Plivna

Hi, I have the following details in a file: (ADDRESS = (CITY_DETAILS = (STREET# = 416) (STREET_NAME = UNITY BLVD.) (CITY =...

admin@rbtron.com

02-10-2009 01:13 PM
gazzag

I'm working on something for a client. The query below basically returns 1 record for the symbol he inputs. All the tables basically contain 1...

Mtek

02-10-2009 12:04 PM
Shakespeare

Hi, Well, I just thought I'd share this junk with everyone. We hired a consulting firm to assist on a project. And, well, this is one of...

Mtek

02-09-2009 02:11 PM
Shakespeare

I have a collection of text files where I've been writing down the code to create and populate my app's database objects. A typical file looks like...

Álvaro G. Vicario

02-09-2009 02:00 PM
joel garry

I have a series of VARCHAR2 columns that might be null or not. Is there a simple way to concatenate them using a separator only between...

Álvaro G. Vicario

02-09-2009 06:07 AM
Álvaro G. Vicario

Ok, dumb question. I am running Oracle trace. I want to suppress the query's output and just see the explain plan....... Can't seem to find it in...

Mtek

02-08-2009 09:12 AM
Charles Hooper

On several onsite computers all running Windows XP Pro, the 10g Net Config Assistant hangs for at least an hour when I select local net service name...

gmburns@gmail.com

02-07-2009 11:41 AM
Mark D Powell

Hello, on the database server running Oracle 9.2, I want to write to a log file. I unsuccessfully tried the following: DECLARE f...

seannakasone

02-07-2009 05:43 AM
Shakespeare

On Feb 6, 2:55*pm, seannakasone <snaka... (AT) flex (DOT) com> wrote: You need to submit your directory name in CAPS and in single quotes: SQL>...

ddf

02-06-2009 05:03 PM
seannakasone

I'm in a bit of a pickle with an XML problem I'm having and I can't seem to find any sensible answers anywhere. Below is a sample of the XML that I...

NavEEd

02-06-2009 01:46 PM
NavEEd

I'm working on a 9i database in ARCHIVELOG mode. I don't have DBA privs on the database or the SELECT_CATALOG_ROLE (tough to inspect things behind...

dana_at_work@yahoo.com

02-06-2009 10:27 AM
dana_at_work@yahoo.com

Hardware leader HP and software king Oracle has created a new technological; terror something big and...

warrioroftheweb@gmail.com

02-06-2009 03:09 AM
warrioroftheweb@gmail.com

Hello, I'm working with Oracle 10.2.0.4.0 I have an unix script that via command line executes a query $ORACLE_HOME/bin/sqlplus -silent...

CenturionX

02-05-2009 01:36 PM
CenturionX

Thanks Bro! Any more suggestions welcome! :) "joel garry" <joel-garry (AT) home (DOT) com> wrote On Feb 4, 11:06 am, "NavEEd" <naveed... (AT)...

NavEEd

02-04-2009 06:12 PM
joel garry

Comments embedded. On Feb 4, 1:59*pm, dana_at_w... (AT) yahoo (DOT) com wrote: NOLOGGING *can* reduce redo log entries, but it may not. You hit...

ddf

02-04-2009 04:42 PM
ddf

our company plan to use ORACLE ERP and we are new to this area. Does there has ant ORACLE ERP mail list ot Forurms which we can get help? Thanks.

aaa

02-04-2009 01:48 PM
George Lewycky

Hi, I've tried to create a foreign key on two columns, where the second col should be nullable to avoid a trigger for testing integrity. drop...

Norbert Winkler

02-03-2009 05:40 PM
David Portas

I have this merge statement: MERGE INTO rank_history_new zrh USING (SELECT v_id AS new_m_ticker, v_rec.z_rank_d AS new_rank FROM dual) zrh2 ON...

Mtek

02-03-2009 03:06 PM
ddf

I installed Oracle 10gR2 on Linux machine (CentOS Release 5). This machine uses DHCP protocol. I can't use EM from my PC to connect to the...

Ora_DBA

02-03-2009 02:20 PM
Ora_DBA

Hi, There is an interesting technology news here at tekwits. Thought you would be beneficial if you read this… Get the latest industry news about C...

Tekwits

02-02-2009 09:34 AM
Ed Prochak

Hi, I ve got a table named schedule which includes epg information round about 60.000 records. I would like to check if there are...

MrBanabas@googlemail.com

01-31-2009 05:46 PM
Mark D Powell

Hi All, I am getting an ORA-00600 when using a MEMBER OF condition using a nested table. If I create a list from the data in added to the neted...

Kevin S

01-31-2009 05:39 PM
Mark D Powell

I am trying to install Oracle database 10g R2 on RedHat Linux 5. The installation goes fine till the Oracle Net Configuration Assistant but the DBCA...

Ora_DBA

01-31-2009 10:09 AM
Ora_DBA

All, Is it possible to use pl/sql tables (Associative Arrays) instead of a varray when using the MEMBER OF condition? Thanks

Kevin S

01-31-2009 02:52 AM
William Robertson

A programmer colleague of mine asked if he could submit a batch of insert statements to Oracle (9i) using C#. And if there's any way to identify...

dana_at_work@yahoo.com

01-29-2009 01:46 AM
gym dot scuba dot kennedy at gmail

Hi there, I am using oracle Sql developer 1.5.3, whenever my database connection has been restored, a new worksheet is created and I have to use...

John

01-29-2009 12:03 AM
John

Hello, There has been many communication on the exists command on newsgroups, web sites... but I could not find anything close to this (below) that...

Wilfrid

01-28-2009 02:09 PM
joel garry

In my company, I am a part of a team of 15 developers and we need to work on a project to develop applications on Oracle 11i db. Each one of us...

Michelle Ryan

01-28-2009 04:48 AM
Frank van Bortel