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 06: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 02: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 02: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 03: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 03: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 06: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 04: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 04: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 04: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 04: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 12: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 02: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 09: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 07:43 AM
Vladimir M. Zakharychev

I would like to convert a date value in a select statement to the session timezone. I know I can use NEW_TIME with the timezone abbreviations, but...

marty

04-29-2006 07:10 AM
Vladimir M. Zakharychev

I have a table with three fields: f1, f2, f3 1 a 432 2 b 323 3 a 345 <-- so 3 has an a and b entry 3 b 345 <-- so 3 has an a and b entry I need all...

mBird

04-29-2006 01:14 AM
Michel Cadot

Why would a query of all_constraints cause 7 million consistent gets and take nearly two minutes ? On a similarly configured instance it only...

mike

04-28-2006 04:41 PM
AT

Hello: We are looking at hiring contractors for a specific area in the i-receivables with in Oracle 11.5.9 application, specifically with...

Itsme

04-28-2006 09:23 AM
Itsme

Hi All, I can't get this sql to work properly. I would like to update the FSA.RESOURCESTRING with FSA.ART_DATA.ID || "-" || FSA.ART_DATA.ISSUE based...

AT

04-28-2006 08:40 AM
AT

Hi all, Went back to a package for the first time in a couple of weeks to make some tweaks and all of a sudden the package hangs if i try to...

SirDrinksalot

04-28-2006 08:35 AM
SirDrinksalot

Hi I'm writing an app that will be a simple server communicating with my pl/sql procedures via tcp/ip (utl_tcp package). How can I cause the app to...

schw

04-28-2006 08:18 AM
Brian Peasland

Hi I am loading data using sqlldr. My table has two columns: a number, and a varray: What I want to do is multiply each element of the varray by 10...

Kevin

04-28-2006 06:04 AM
Kevin

Hi All I am not sure if I'm correct but it's possible to set up many oracle databases on a single machine each will be accessed through...

schw

04-28-2006 05:22 AM
schw

Hello everyone, I have a text file populated with hundreds of id numbers(one entry per line). Now I want to execute against a database a query in...

Muggle

04-27-2006 11:51 AM
Rauf Sarwar

Hi! I would like to find an application which allows me to read data from a database (object-relational database schema), display it visually,...

timoomit

04-27-2006 06:00 AM
Mark C. Stock

Hello everybody, i'm quite a newbie in Pro*C. I have a Pro*C program that calls a stored procedure. I would like to trace to debug my stored...

Laurent Kloetzer

04-27-2006 03:57 AM
Laurent Kloetzer

I have a table with about 180,000 rows and 50 columns, and another table which has an identical structure but is empty. The source table has no...

Don Del Grande

04-26-2006 03:38 PM
Don Del Grande

delete from ASSORTMENT where ASSORTM not in ( select min(ASSORTM) from ASSORTMENT group by ASSORTM2 ) This query is teking too musc time to...

Kuldeep

04-26-2006 11:08 AM
gazzag

I've got some problems with passing an Array as parameter to a PL/SQL stored procedure in C++. The usage below allows me to pass the array as a...

AT

04-26-2006 10:13 AM
AT

We are running into large numbers needing to be stored in some columns. Does increasing the precision of a NUMBER increase the storage size? What...

AT

04-26-2006 08:12 AM
Brian Peasland

Gentlemen, this is the official page about thtead safety : http://oraclesvca2.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci09adv.htm#456379 I...

Herode

04-26-2006 07:48 AM
Amogh

Greetings, I have a table as table1 ID INTEGER NAME VARCHAR2(50) DOJ TIMESTAMP ...... I want to create another table (table2) with the same...

AT

04-25-2006 11:50 AM
Brian Peasland

Hi, Our P and A department has raised a query about one of their reports They use windows SQLPLUS ( Release 9.2.0.1.0 ) to execute the query. The...

mich \(at work\)

04-25-2006 07:25 AM
mich \(at work\)

Gentlemen, I have an OCI-based code making all the Oracle calls for the main application. All that stuff works, except in one specific...

Herode

04-25-2006 06:39 AM
Amogh

Hi, Currently we are using OracleAS 9i Release 2( 9.0.2 ). We are moving to J2EE 1.4, so the Oracle AS we have to use is the 10g Release 3 which was...

Warren

04-25-2006 12:57 AM
Warren

I have two ways of setting session variables in SQL+, one is using var(iable) and the other is using define. Can anyone tell me if they have had any...

dean

04-24-2006 11:30 PM
dean

my id kuldeepchitrakar (AT) gmail (DOT) com

Kuldeep

04-24-2006 06:56 PM
AT

HI I've got a simple structure like the following: DECLARE TYPE LOGON_PACKET IS RECORD( szUsername CHAR(256), szPwdEnc CHAR(256));

schw

04-24-2006 10:18 AM
Maxim Demenko

hi, are there any encrypt and decrypt functions available? In particular, I'm looking for 3DES encryption library. thanks

schw

04-24-2006 10:07 AM
Mark D Powell

Greetings, Can anyone provide me some links or docs that covers the Oracle PL/SQL Coding Standards to Follow. I have been to tahiti.oracle.com and on...

pankaj_wolfhunter@yahoo.co.in

04-24-2006 08:43 AM
Ubiquitous

Hi I'm writing a package in PL/SQL with few functions and one of them logs in to my server using defined login credenitals. How can I hide...

schw

04-24-2006 08:21 AM
Brian Peasland

Hello all, Do disabling of the NULL BASE queries in the Oracle LDAP server will influence on Oracle SSO ? Thanks.

AT

04-24-2006 07:24 AM
AT

I need to write "binary" data, specifically a record separator byte (x1E), to a file. When I do so using...

spambox1@mindspring.com

04-21-2006 08:37 PM
G Quesnel

Hi, I am very new to Oracle. My customer has a requirement, where in I need to generate the XML scripts for the data that we are appending with...

Rohit Arora

04-21-2006 04:45 PM
joel-garry@home.com

Please tell me the syntax for inserting a calculated column into an Oracle 10g database. The SQL Server ALTER TABLE code won't work. A simple...

biggs@trilliant.com

04-21-2006 02:10 PM
biggs@trilliant.com

Hi, I'm getting an "ORA-00932: inconsistent datatypes: expected - got -" message with the pl/sql code at the bottom. This is just an...

Dale

04-21-2006 11:29 AM
Dale

create procedure tab_rows IS tab_name varchar(50); declare cursor all_tabs is select table_name from user_tables; begin create table temptab (rowc...

Kuldeep

04-21-2006 10:52 AM
Sybrand Bakker

Hi, Suppose: - you have a table that has only a few colums and one of them, an integer column, is used as an index; - rows in this table are only...

aehven@gmail.com

04-21-2006 10:19 AM
aehven@gmail.com

Hello everybody, I have a problem with the output of my query in Sql*Plus. Hopin for an answer... My output looks like: ID_XXXX...

patrick

04-21-2006 08:59 AM
Brian Peasland

Greetings, I have been working with a group who has a web application that queries a 4 field table. One field data type is a long. The attachments...

Robert

04-21-2006 07:23 AM
Vladimir M. Zakharychev