I am installing Oracle10g Release2 on Solaris 9. I have Veritas Volume manager with cluster feature (CVM) enabled. I created the OCR and voting disks...

IT-Prof-Unix

05-09-2006 01:50 PM
AT

Hello, I'm using Oracle 9i on Solaris. How do I take a column of a DATE type and convert it to milliseconds that have elapsed since Jan. 1, 1970,...

AT

05-09-2006 12:46 PM
marcus.rangel (AT) gmail (DOT) com

Please do not cross and multipost to every group you can spell. And no it is not possible, not without using pl/sql and looping through individual...

AT

05-09-2006 12:23 PM
DA Morgan

Hi, I am trying to insert German and French character data into 9i database running on Linux 32 bit. We are using java "thin" driver for this . When...

ManojRawat

05-09-2006 03:58 AM
AT

Hi all I am in the process of porting an application to Oracle and have as a start downloaded 10g. I have been able to run scripts for a while, but...

AT

05-08-2006 05:49 PM
AT

In sql-server (or access) there is a db-function : IIF. i.e. IIF(A=B, <RESULT WHEN TRUE>, <RESULT WHEN FALSE>); (It should be in a select statemant...

Eitan

05-08-2006 05:39 PM
AT

How can I use ORACLE TEXT to perform full text search on multiple columns across multiple tables join? For example consdier the following 3...

AT

05-08-2006 12:51 PM
AT

Hi All, I need to create a script that can be run on different databases to create some objects. Problem is, the databases have different...

amerar (AT) iwc (DOT) net

05-08-2006 12:11 PM
amerar (AT) iwc (DOT) net

Here's my issue. We've decided to replace a very critical (without it the business would lose lots of money) departmental reporting system with a...

Larry Dooley

05-08-2006 10:54 AM
Larry Dooley

Hello, I have Crystal 9.0. Also I have Oracle 9i. (I didn't any normal newsgroup for crystal, so I ask here, please help). I want to give the sql...

Eitan

05-08-2006 09:50 AM
Eitan

Can anyone provide a comparative analysis between these two databases that are halfway objective? I have found one...

Mr Bob

05-07-2006 08:59 PM
Mr Bob

I am confused between clustered and replicated databases. What is the basic difference between them and when are they used? Thanks.

raghu

05-07-2006 12:01 PM
DA Morgan

Hi, We are planning an upgrade from 8.1.7 and 9.2.0 to 10gR2. There are few databases on Windows NT and few on Solaris. And here are some of...

raghu

05-06-2006 09:37 PM
raghu

I am learning forms with Oracle 9i and have run into a problem. The following code runs just fine in a Save Button with a WHEN -BUTTON-PRESSED...

Sykiemikey

05-06-2006 11:53 AM
Sykiemikey

Hi! For my project I need a history of all changed recordsets of one or more tables. If I change one record, the old one should be in the...

Danny Gerst

05-06-2006 11:08 AM
Brian Peasland

Dear friends, We have a financial system entirely oracle-based, using Forms10g and Database10g. There is a very big deployment on the horizon, full...

AT

05-05-2006 04:10 PM
AT

Hi, How, if at all, could I add a column to a table in Oracle 9i in which the column would record time and date, and its default value would be the...

AT

05-05-2006 02:38 PM
Mark C. Stock

Hello, I have installed java 2 SDK 1.4 on my windows XP machine. I want to connect to oracle database server (machine name - myserver) where Oracle...

AT

05-05-2006 12:58 PM
Rauf Sarwar

Hi, I have a component that uses the OCI library to do spatial index queries. The component is badly written and is based on examples. To state it...

Pieter Breed

05-05-2006 07:59 AM
Volker Hetzer

Hello, here is the setup (smal test I created): A table with a CLOB column (data) with the following content: <root> <child>Child 1</child> </root>

Thomas Kellerer

05-05-2006 05:14 AM
Thomas Kellerer

I have a client that has their oracle DB on a Unix machine with the clock set to the PST timezone and observing daylight savings changes. They're on...

Luch

05-05-2006 02:22 AM
Vladimir M. Zakharychev

We are in a dilemma whether to upgrade our database to Oracle 9i or 10gR2. Does it make sense to upgrade to 9i now? What are the factors to be...

raghu

05-04-2006 06:19 PM
DA Morgan

I can't seem to get my head wrapped around this. I have two tables: One has Daily Tansactions (compl_trxd) and is keyed on trxd_plan_num ( as well...

Alt255

05-04-2006 02:40 PM
Sybrand Bakker

What's the advantage of using SQL Plus over other tools like Toad. Its extremely difficult/cumbersom and output seems very bad. Is there anything you...

Procrastinator

05-04-2006 12:04 PM
Wayne Brown

Oracle 9iR2 (9.2.0.7.0) on a Windows 2003 platform. The Enterprise Manager's Index Tuning Wizard states in the header of its...

sphealey

05-04-2006 11:22 AM
sphealey

Hi , I have a problem with the reply from the server using utl_tcp. Everything works fine but I can't store the reply into a variable. the reply...

Ginko

05-04-2006 08:04 AM
Ginko

Hi , I have a problem with the reply from the server using utl_tcp. Everything works fine but I can't store the reply into a variable. the reply...

bestia9 (AT) hotmail (DOT) com

05-04-2006 07:55 AM
bestia9 (AT) hotmail (DOT) com

alternative to minimize software development costs, and improve the quality of your software solutions and compress software development time. We...

datagrep

05-04-2006 05:38 AM
gazzag

Hi, I'm writing a PL/SQL program to send emails. I copied a email packages from the web and it works fine. However, I have problem if I put...

AT

05-03-2006 05:47 PM
AT

Hello, I have problem. I'm trying to refresh materialized view and I have error that some pirivileges are needed but I dont have idea what more can...

AT

05-03-2006 12:14 PM
DA Morgan

Hello, I am looking for a Crystal Reports writer (version 10 a plus). I am finding however, that not all Crystal aficionados post themselves...

Emma

05-03-2006 11:58 AM
gazzag

Imagine I have a database of 10,000 trains and their ordered list of (around 2 million) scheduled locations, keyed on those trains and an order...

dean

05-03-2006 10:00 AM
dean

hello gents, i have a task of porting from sql server to oracle, i am looking for help on the following IN sql server i write ----------- SELECT...

Vinay Bhushan

05-03-2006 09:41 AM
Vladimir M. Zakharychev

This doesn't work Declare bignum number ; function sqr(n number) return number is begin return n * n ;

Procrastinator

05-03-2006 07:29 AM
Procrastinator

Hi, Is there any way to save a xml document in an oracle database by using c#? For Java etc. I have found the ORACLE XML SQL Utility but it doesn't...

AT

05-02-2006 08:35 PM
AT

Help Me respect security in Oracle and task of Audit. I only read in english (not write), sorry -- Saludos cordiales,

Felipe A. Lopez

05-02-2006 08:32 PM
Brian Peasland

Hi All, I have 4 openings for Oracle Developer - 2+ yr Project in Metro DC Skills: Oracle 10g JAVA J2EE Mid level developer with 3-5 years...

Oracledude

05-02-2006 07:32 PM
Oracledude

Not sure best way to explain this but I'll try. I have a table with some of list ids, I need to merge them together under one list id. We separate...

Aleanna10 (AT) gmail (DOT) com

05-02-2006 03:27 PM
Aleanna10 (AT) gmail (DOT) com

I am not sure how to write the following query: Simplified table structure: ID SENT DATE 123 Y 5/1/2006 124 ...

AT

05-02-2006 03:12 PM
AT

Hello, I am just starting with Oracle and I have a problem. See, I want to create a Stored Procedure that will do the following: 1. Select * from...

AT

05-02-2006 04:44 AM
AT

Gentlemen, Here is my test code : // 1 - the loop testing the leaks void TestOCIEnv::test() { for ( int i = 0; i < 10000; ++ i ) { COCIEnvironment...

Herode

05-02-2006 04:35 AM
Herode

Hi, We are using Oracle/RAC 10GR2 with ASM for disk management of diskspace used by the database. ASM requires that the disks are NOT included in...

AT

05-01-2006 07:01 PM
AT

Hi ALL Help me. I am working in oraganisation where In single server there are two database. Operating System is Unix. One disk is crashed in which...

AT

05-01-2006 05:55 PM
AT

Hi, We are using Oracle RAC 10GR2 on AIX 5.3 systems. Since RAC 10GR2 is a clustering technique that does not use HACMP anymore for...

AT

05-01-2006 05:35 PM
DA Morgan

Hi! I'm trying to create tables and either get ORA-22912 (column is not an nested table) or when leaving out the 'NESTED TABLE'...

timoomit

05-01-2006 05:33 PM
DA Morgan

Hi, I'm having a problem of architecture nature and due to time constraints and having little knowledge about Oracle I need your help. Thanks...

schw

05-01-2006 05:29 PM
DA Morgan

Why? Please use statspack or query v$sql after the statement has completed. Please do not crosspost to every group you can spell, especially if they...

sybrandb

05-01-2006 01:18 PM
AT

hi all i have got a problem about nlssort statement. i use oracle 10g r2 (32 bit on amd64) with windows 2003 server r2 (32 bit) we have special...

MadeOfRose

05-01-2006 03:35 AM
MadeOfRose

Hi All, I have a java program and I'd like to call a stored procedure or create triggers on oracle, can I use OCI for this ? thanks best...

schw

04-29-2006 10:19 AM
Jim Kennedy

I am trying to do a 'create table as select' to create a remote table, but I am getting the error "ORA-02021 DDL operations are not allowed on a...

Dan

04-29-2006 08:43 AM
Vladimir M. Zakharychev