Hi all, the following query attempts to produce the total salary per the number of 'A's in employee name (scott/tiger) and it works. select...

vezerid

11-29-2007 11:24 AM
vezerid

While writing a query to do some editting i wanted to use CHR(10) to have a query do some formatting. It seems that whenever it is used, it adds an...

Brian Tkatch

11-29-2007 11:11 AM
DA Morgan

Hello, we are planning to move our mails from local clients (like Thunderbird) into the database. We experienced long search times with the local...

Marten Lehmann

11-28-2007 01:18 PM
Frank van Bortel

hello, I want the pro*c program to call the stored procedure that will return VARRAY of RECORDS. Is there a way to recieve in the pro*C program an...

sukhen

11-28-2007 08:43 AM
sukhen

Hello all, I have the following task: I have a table with two fields, ISBN (NUMBER 9), TITLE and PERIODICAL_OWNER (NUMBER 9). I am trying to create...

mowinom@hotmail.com

11-28-2007 08:41 AM
fitzjarrell@cox.net

Hi, We are having problems restoring rman backups. Sometimes. If a single backup is made then restored it works. Subsequent (or possibly just older...

Nick Keighley

11-28-2007 04:57 AM
Nick Keighley

I have a design question I've been tossing around, but can't seem to come up with a good solution. Basically, I have a work item. Each work item...

meislerj@yahoo.com

11-28-2007 02:01 AM
Malcolm Dew-Jones

I have a database with many user defined types. Sometimes I want to drop them all, without the tedious work of dropping in the correct order. So I...

Siv

11-24-2007 06:30 PM
Mark D Powell

Does anyone know how to solve this: We have a metadata repository on a database server (10g rel 2), and a separate OID server (AS10g rel 2 on SLES...

shakespeare

11-24-2007 03:11 PM
shakespeare

Hi, I am creating a attendance sheet software for inhouse use. my data is like...

Bhishm

11-23-2007 02:14 PM
Charles Hooper

Hi We would be interested in starting a discussion with anyone building or evaluating Semantic Web technologies - building a semantic layer "over"...

igoldsmid

11-22-2007 02:20 PM
igoldsmid

I have a task that is undoubtedly common, simple, but not trivial. I have a number of tables with minor variations, but basically what happens is...

Malcolm Dew-Jones

11-22-2007 03:24 AM
DA Morgan

BismillahirRehmanirRahim Hi All, I am using logminer of Oracle 10g for audit purpose to get the insert,update or delete statement for a...

Salman

11-21-2007 11:45 PM
Salman

Hi All, I have a question about data validation. I have been reading some articles that indicate that data validation should be done at...

Vijai Kalyan

11-21-2007 09:08 AM
Brian Tkatch

The technical and logical challenges of data preparation and data transformation can differ greatly from project to project. Also,...

Robert

11-20-2007 04:51 PM
Mark D Powell

Hi all, I cannot find the solution to the following problem after a several hours of googling. I am using Oracle 10g and trying to export...

Charity

11-20-2007 04:00 PM
DA Morgan

Hi FUNCTION gst.ala(al_id_up => :al_id_up, as_p => :as_p, as_s => :as_s); al_id_up IN as_p OUT as_s OUT

gstoch@gmail.com

11-20-2007 08:57 AM
DA Morgan

http://oracle-programming.blogspot.com

gopiumesh8@gmail.com

11-19-2007 10:45 PM
Ed Prochak

Hi, I try to use java to write "import oracle.xml.parser.v2.domparser and import oracle.xml.parser.v2.xmldocument" but i can't find the jar file for...

Krista

11-19-2007 04:29 PM
shakespeare

hello, I have to replace old and slow RDO in Visual Basic Application. What is the fastest and most effective way to do this ? Is oo4o a good...

abdoul85

11-19-2007 11:38 AM
DA Morgan

daoudamjad (AT) emailmiser (DOT) com wrote: The only thing cracked is you. Get back on your medication. -- Daniel A. Morgan Oracle Ace Director &...

DA Morgan

11-19-2007 02:31 AM
DA Morgan

Hi I am an oracle newbie. Also an intermediate in mysql. In the past I've used a method in PHP to prevent injection: function _escape ( $sql...

AlexCook

11-19-2007 01:59 AM
DA Morgan

I connect to Oracle and close the connection in my code every time. Dispite that sessions remain idle showing following: ALTER SESSION SET...

jobs

11-18-2007 07:42 PM
Mark D Powell

Hi every one: i'm kind of new in Sql*plus and Oracle and i have some problem in Update the value in one of the table.I want a Write an...

Rosh157

11-18-2007 05:02 PM
Ruud de Koter

Hey guys, We are on Oracle 9i and not sure if we will migrate to Oracle 11g. I am wondering, if any of you folks have upgraded to Oracle 11G and if...

mark_smith

11-17-2007 06:03 AM
Frank van Bortel

I got this error while performing an ado.net call to an oracle procedure that returns a dataset. Exception of type...

jobs

11-17-2007 01:32 AM
Michel Cadot

Björn Wächter wrote: Oracle version number. DDL would be helpful. Information such as the number of rows being returned useful. Is there a WHERE...

DA Morgan

11-16-2007 07:57 PM
DA Morgan

I am getting completely different results with the following query: SELECT scanA.* FROM SCHEDWIN.LOCSCAN scanA WHERE scanA.SCAN_TIME = (...

athaung@gmail.com

11-16-2007 07:55 PM
DA Morgan

When doing complex data transformation ( data preparation, data manipulation, etc. ) , perhaps when preparing data for statistical analysis, or...

Robert

11-16-2007 02:21 PM
Mark D Powell

We're using Oracle 10g and 11g on Windows. We have a client-server app written in PowerBuilder. We do logic on the PBuilder side and with...

Luch

11-15-2007 02:26 PM
Frank van Bortel

Maybe too broad a question. Is RAID 10 pretty much now the rule of thumb? Hope things are going well, Bill

Bill

11-15-2007 10:41 AM
Brian Peasland

(AP) Increasingly application developers are required to include flexible and extensible reporting options within their core product sets. This is...

test

11-15-2007 07:17 AM
test

Employee Rights Employees have the legal right to refuse to be tested (or to enter rehabilitation), but this will usually result in their...

33223

11-14-2007 09:19 PM
33223

Is there a way to disable all contraints and triggers in all the tables in a particular schema? Either through toad or sql.

Sean Nakasone

11-14-2007 07:26 PM
array7@inbox.com

If you are going to chose and buy the motherboard, the important things is, first see what kind of CPU you have. Or probably to get a new motherboard...

Rosh157

11-14-2007 01:34 PM
Frank van Bortel

What are the commands to drop a schema you are logged in to (or is this even possible?) and recreate it? All of the tables need to be dropped and...

ddog

11-14-2007 09:50 AM
fitzjarrell@cox.net

Hello: i'm kind of new in Oracle and now learning how to use the Sql*Plus. i have question about Single functions and i hope that somebody can help...

Rosh157

11-14-2007 06:57 AM
Frank van Bortel

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time I have a Web Service, written in C#, published on a Windows XT Web Server...

Temporary

11-13-2007 11:18 PM
Temporary

I have four databases located all around the world and I would need a function which will return GMT time. Any tips? Cheers hh

Beginner

11-12-2007 10:22 AM
Jerome Vitalis

Does Oracle have anything comparable to the data transformation procedures in SAS/BASE? In particular, the SAS datastep? ( SAS/BASE is for preparing...

Robert

11-09-2007 04:27 PM
joel garry

Oracle 9.2.0.8.0 1) Oracle has a precision on TIMESTAMP with a default precision of 6. Selecting 9 always returns three more zeroes. Why? 09:45:35>...

Brian Tkatch

11-09-2007 12:34 PM
Brian Tkatch

Hi, I want to build an application with .NET Framework C#/ and Oracle as Database, or with Access as Frontend for Oracle. What are the advantages...

SePp

11-09-2007 12:00 PM
Mark D Powell

VAM SYSTEMS is a Business Consulting, IT Technology Solutions and Services company with operations in UAE, Qatar, USA, Singapore & India. VAMSYSTEMS...

vam

11-09-2007 02:27 AM
vam

perhaps tthis select will be very slow and terrrible, but I get invalid identifier on this line right on the function monthsfirstattempt. I know the...

jobs

11-08-2007 06:36 PM
jobs

sorry to have to ask this. How do I return last month in mm format? For example it's November 8th Today. I'd like to get 10 back. If it were...

jobs

11-08-2007 06:02 PM
Terry Dykstra

Hi, i want to make a proof of concept about handling "binary data". Background: I want to get a binary decription (or hex etc) of a data stored in...

Micha

11-08-2007 01:03 PM
DA Morgan

DBMS_ERRLOG will not compile within a cursor loop. Depending upon where I put the semicolons, I get these types of error messages. PLS-00103:...

alexglaros@gmail.com

11-07-2007 04:09 PM
DA Morgan

hi, Database version: Oracle Database 10.2.0.2.0 OS: RedHat Enterprise 4 I find select statement with sample clause return random count...

tamsun

11-07-2007 02:24 PM
William Robertson

Strangest thing. I've got an Oracle back-end, and an Access 2000 front-end. I start a blank database. No objects except for one form, with...

wrldruler

11-07-2007 07:44 AM
wrldruler

Oracle Certifications http://educational-world.blogspot.com/2007/07/oracle-certification-programs.html

Information

11-07-2007 01:22 AM
DA Morgan