Hi Does Oracle Ship any odbc drivers as part of their installation on UNIX (solaris,linux,hpux,aix) (or can it be downloaded from their siter) As far...

famsmith@hotmail.com

01-09-2006 08:32 AM
Mark D Powell

Hi, When I execute 'select '*' || to_char(33,'0009') || '*' from dual I get '* 0033*' instead of '*0033*'. Does anybody know what might be wrong?...

Günther De Vogelaere

01-09-2006 08:17 AM
Günther De Vogelaere

Please specify the perfect compatible VB-ADO constant (for example adChar, adVarChar,adVarWChar) for the following datatypes in...

sameer75@gmail.com

01-09-2006 05:56 AM
sameer75@gmail.com

hi all i have a procedure like this (in package CORP_REPORT): PROCEDURE Confronto ( IN_IDREQUEST IN NUMBER, CUR_1 IN OUT...

roberto galbiati

01-09-2006 04:39 AM
roberto galbiati

Dear All Many of our esteemed MNC clients are looking out for Oracle professionals with multiple positions opening. Please go through the list below...

sandhya

01-09-2006 03:27 AM
sandhya

Is any way to use regular expressions on 9.X Oracle databases, and how? Or it is 10g feature???

T

01-09-2006 02:19 AM
T

This message is cross-posted to 2 groups because of making comparsons. When I review SQL Server 2005 functions, and get to know languages called...

dino_hsu_1019@yahoo.com

01-08-2006 10:13 PM
aaron.kempf@gmail.com

Hey, what are the best Oracle OCA test question/answer collections? There seem to be a lot around the net, Transcenders, TestKing, Self-Test, etc......

Rob Glasnos

01-08-2006 08:57 PM
Rob Glasnos

hi all i am new on oracle and this group do anybody know why i cannot see updates from my asp code which added with isqlplus. i see the rows after a...

MadeOfRose

01-08-2006 06:17 PM
MadeOfRose

hi i am so new on oracle. My problem is i cannot delete rows from a table.Look like deleted but it is not :D i am working on web application which...

MadeOfRose

01-08-2006 07:02 AM
MadeOfRose

Is there an SQL command that will tell me who I am logged in as right now? Thanks for any tips! Dean

dean

01-08-2006 02:30 AM
Mark D Powell

Hi, I'am using ORACLE Server + Client 9.2.0.4.0. While creating triggers within SQLPlus* I get the message: Warning: Trigger was created with...

Zephyr

01-06-2006 01:37 PM
Andrew Allen

I have a problem with a function: function getOrder (in numberOfOrders) return refCursor ( select sequence.nextval into tag; -- we get number value...

Sadys

01-06-2006 11:02 AM
DA Morgan

Hi all. I'm trying to configure a listener between a couple of servers and am having all sorts of issues. I'm quite new at this and was...

Ben Bowen

01-06-2006 10:30 AM
Ben Bowen

Hello, I'm trying to install Oracle 10g linux client (10201_client_linux32.zip). The target machine is an Intel Pentium III machine running CentOS...

google-groups@jonze.com

01-05-2006 01:20 PM
Frank van Bortel

DA Morgan wrote: Thanks Dan. Ed "the fool" Prochak 8^)

ct witter

01-05-2006 12:47 PM
DA Morgan

CREATE TABLE "UPD"."SELECTED_NODES" ("SEQ_I" NUMBER NOT NULL, "NODE_I" NUMBER NOT NULL, "LABEL_S" VARCHAR2(1 byte), CONSTRAINT "PK_SELECTED_NODES"...

dean

01-05-2006 12:41 PM
dean

I have a table which contains a column date_operation declare as date when I do sql as "select date_operation" from a_table, I got as...

blackdog

01-05-2006 07:43 AM
blackdog

Hello, I'm trying to install Oracle 10g linux client (10201_client_linux32.zip). The target machine is an Intel Pentium III machine running CentOS...

google-groups@jonze.com

01-05-2006 06:43 AM
google-groups@jonze.com

Hello all, I am running Oracle 9.2.0.5 Personal Edition on Windows2000 (client), and following the steps for "Adding New Master Sites Without...

J.A. Cooper

01-04-2006 01:33 PM
Frank van Bortel

I currently use Waters' Millennium HPLC software, which has an embedded instance of Oracle 8i. Recently the hard disk crashed, and hosed...

Bruce Coryell

01-04-2006 01:17 PM
Frank van Bortel

"Marcin Bia³ek" <bialyglbialygl_skasuj_ (AT) poczta (DOT) onet.pl> wrote Forms has built in search functionality via the Enter Query menu option...

Mark C. Stock

01-04-2006 07:12 AM
ejunkmail@planet.nl

Hi, I have Oracle 9i, IAS 9.0.4, and I use Web PL/SQL. I have a only connect user from database and a role with permissions to object access. For...

jatix

01-04-2006 02:09 AM
jatix

I was hoping someone might be able to help me with this one: I tried to: alter table "sapr3"."b0000153001" modify...

Vince Laurent

01-03-2006 01:57 PM
DA Morgan

Hello As I must run an audit on a DB with 30Tx/sec (mainly update, insert) I need to know if the fact to set TIMED_STATISTICS to TRUE involve an...

Sylvestre

01-02-2006 03:28 PM
Sybrand Bakker

Hello, I have a strange behaviour in our production database (9.2.0.7). In a method inside a package a cursor is used to iterate through the...

Thomas Blankschein

01-02-2006 02:32 PM
Sybrand Bakker

Hello everyone, I frequently want to display query results in SQL*Plus, but they come out poorly formatted because the default length of the columns...

Jeff Calico

01-02-2006 04:44 AM
Maxim Demenko

Hi, I am using Linux with Oracle . I heard that we can access the Windows XP desktop via Linux. Someone tolld me that there is a technique available...

marjina98@hotmail.com

12-31-2005 06:59 AM
Frank van Bortel

Back in the days of Oracle 7 when they used to send you a complete manual set every time you upgraded, or even just requested a patch, the RDBMS...

Jim Smith

12-31-2005 06:12 AM
Mark C. Stock

it occurred to my that for some whose native tongue is not english, the names of these two functions might seem a bit odd, as would the...

Mark C. Stock

12-30-2005 08:39 PM
Mark C. Stock

Hi, As far as i know there is no NET managed provider to connect from VB2005 express editions to the new Oracle XE. It only talks to Sql Server...

andreas.vandenberghe@gmail.com

12-30-2005 08:37 PM
Jim Kennedy

Hi. Sorry for another newbie question. The log switches were too frequent during normal operation, so I resized my redo files from 30 M to 100 M each...

Gerard Lacroix

12-30-2005 02:52 AM
Frank van Bortel

I would like to find the average temperature combining a number of locations where the record overlaps. for a particular month I could use...

Dave

12-30-2005 12:00 AM
Dave

Hi, Our application uses a dblink to connect to a different database (Oracle 9i). We have been facing issues with the dblink going down due to...

raghu

12-29-2005 02:43 PM
Mark D Powell

Hi. Sorry for another newbie question. The log switches were too frequent during normal operation, so I resized my redo files from 30 M to 100 M each...

Gerard Lacroix

12-29-2005 10:53 AM
Gerard Lacroix

While I run following scripts -------------------------------------------------------- Declare myFile sys.utl_file.File_type; path ...

Aray

12-29-2005 09:48 AM
Giridhar

Hi there, I'm trying to solve an update, and simply can't find a way. It updates 1 table, that has a 3 column PK. See it here: update (...

xcure2k@gmail.com

12-29-2005 06:40 AM
xcure2k@gmail.com

How can I avoid ORA-12899, value too large for column error? I have a database and program which are not made by me. I have sources, so I could make...

Arto Viitanen

12-29-2005 03:46 AM
Michel Cadot

what could be the error... SQL> begin 2 DBMS_SCHEDULER.CREATE_JOB ( 3 job_name =>'create_dir_test', 4 job_type =>'executable', 5 job_action =>...

Muthu Kumar G

12-29-2005 12:39 AM
Sybrand Bakker

Hi I'm using Pentium IV 3.0 GHz (HT enabled) with Windows XP (SP2) as my home pc. I was able to install Oracle 8.1.5 Enterprise Edition for Windows...

venugopal.sistla@gmail.com

12-28-2005 10:15 PM
Jim Kennedy

Hi, does anyone has any 'how to" about migrate PostFix Mail to Oracle Collaboration Suite 10g. I´d like help to export users and distributions list...

William

12-28-2005 10:43 AM
William

Hi all, I'm searching a complete help on Oralce Hints. All the syntaxes and rules avaible. Can U help me ? (Google doesn't ;)) Thx all. Julien (FR)

Julien

12-28-2005 10:39 AM
Julien

Hi, I want to partition existing two large table and one index on the oracle 9i database because query response time on the tables is very high...

Zafer Gedik

12-28-2005 07:21 AM
Zafer Gedik

Hi, a collega used frequently a begin, select ... and exception when no_data_found. I am used to use a cursor with %notfound to check is a record is...

ron.van.der.zwaag@abp.nl

12-28-2005 04:47 AM
Michel Cadot

Converting from vb to SQL: Below is my orginal logic: Select Case Weekday(Date, vbSunday) Case Is = 1 ' We are at a Sunday so we need to go ' to...

ct witter

12-28-2005 04:26 AM
ChrisF

Hello !! I've got a problem with a query,I would like to select some data from " TbOrder" table where the period date is from the 01/04/(current...

gab

12-27-2005 05:43 PM
William Robertson

Friends, Checkout this new tool that helps in database administration and development. It's called Guggi-Oracle and is available for free download...

OracleUser

12-27-2005 04:17 PM
joel-garry@home.com

Hello! Wondering if someone can help educate me on the design on query that i would like to run. Table A Table B ID ...

inlove22@hotmail.com

12-27-2005 04:16 PM
Mike Enarson

Hi all, First I used this query: SELECT DISTINCT Field1, Field2 FROM Table; The results was distinct records. So far so good. Note that Field2...

SunScreen

12-27-2005 09:44 AM
Ed Prochak

I have used an existing vb process to supply dates, but I am switching over to a pure SQL. Below is the previous logic. Select Case Weekday(Date,...

ct witter

12-27-2005 08:36 AM
Mark C. Stock