Hai All, I have a function which contains a collection of select and insert statements and I am also able to handle the exception and get the...

Prince

12-20-2006 12:53 PM
Ubiquitous

"Björn Wächter" <bwc (AT) p3-solutionsKILL_SPAM (DOT) de> a écrit dans le message de news: 4ut1jhF19pl2mU1 (AT) mid (DOT) dfncis.de... You get...

Michel Cadot

12-20-2006 09:35 AM
Michel Cadot

Hi I have strange problem with password file. I'm using oracle 9.2 I have remote_login_password set to exclusive. I tried to grant dba to antother...

Mangood

12-20-2006 08:41 AM
Franck Pachot, France

I installed Oracle 9iAS on Windows XP running machine. During installation i selected "HTTP Server and WEB Server" option. But files like...

Naeem

12-20-2006 05:40 AM
What's in a namespace

I have a trigger that calls a stored proc on update for table1. When the stored proc queries table1 it can not see the new data. The user modifies...

tacrawford@adelphia.net

12-20-2006 02:37 AM
hasta_l3@hotmail.com

Hi All, I'm a newbie. I am trying to create a program to extract some entries from tables and load some others, using Pro*COBOL. The overall...

attraxion

12-19-2006 12:25 PM
Ed Prochak

database is on an highly available system. showing an alias name of the database I am trying to connect to. Is this normal? or does this indicate...

ajmastrean

12-19-2006 12:02 PM
ajmastrean

Hi can any one tell me how can i call a Stored procedure after materialized view refreshes itself autometically {the next refresh attribute is given...

uday

12-19-2006 10:06 AM
uday

I am trying to show a list of invoice numbers, with each invoice total formatted as currency, then the average of all of the invoices formatted as...

ITAnnaJones@gmail.com

12-19-2006 09:40 AM
Michel Cadot

Hi, all I'm developping an application. I have a table which has a "LONG" column. I need to run such sql by OCI: SELECT "TEST_LONG"."CONTENT",...

kiluyar

12-19-2006 03:10 AM
sybrandb

I am trying to show a list of invoice numbers, with each invoice total formatted as currency, then the average of all of the invoices formatted as...

ITAnnaJones@gmail.com

12-18-2006 11:07 PM
ITAnnaJones@gmail.com

In oracle exist ON UPDATE clause in Foreign Key syntax? I've write: .... CONSTRAINT "MALATTIE_SINTOMI_FK2" FOREIGN KEY ("ID_SIN") REFERENCES ...

Mariano

12-18-2006 02:34 AM
Mariano

Do you know any tool to analyze SQL commands to verify if is there any error and suggest a change ? I use: Oracle RDBMS: 9.2.0.7.0 Oracle...

apogeusistemas@gmail.com

12-18-2006 12:52 AM
Arto Viitanen

Hi, I'm trying to create a 10g db on my ultra 10 machine which only has 640MB physical RAM & 20GB diskspace. According to 10g training info,...

lazyboy_2k@yahoo.com

12-17-2006 03:01 PM
DA Morgan

Greetings, I came across these two books for gearing up towards Oracle 10g OCA and OCP ceritifcations: (1) Oracle Database 10g OCP Certification...

pankaj_wolfhunter@yahoo.co.in

12-16-2006 05:28 AM
pankaj_wolfhunter@yahoo.co.in

I know that I can cast a long to clob using to_lob() and an insert/create table but I do not have write access to the database only read access. I...

luke.pickett@gmail.com

12-16-2006 04:41 AM
Vladimir M. Zakharychev

Hello, we have Oracle 9, and now I'm faced with this problem: I have to update an entire column from a table which contains the character ' (single...

John

12-15-2006 08:41 PM
Charles Hooper

I open up Oracle SQL*Plus and i want to change the field size for one of my columns in one of my databases. I have a generic SQL book, but when I...

BookerT

12-15-2006 06:01 AM
BookerT

Hi, I need some help in using the IN operator with Oracle 9i. The issue is I will get a data in variable (Lets say the variable is "A") with...

sangu_rao@yahoo.co.in

12-15-2006 02:35 AM
Thorsten Kettner

Hello all. I have an application that displays phone call information. The app has been working for a while but today I noticed a glitch. There are...

b_addams@yahoo.com

12-15-2006 02:12 AM
Thorsten Kettner

Hi, I would like create a network from already existing table..... How i can import this table in the network? Oracle 10g release 2

ennio

12-14-2006 03:46 PM
What's in a namespace

Is there a visual query builder tool for Oracle out there? I've tried PL/SQL Developer and while it will let you build queries graphically it won't...

ddog

12-14-2006 09:44 AM
ssmagin

How to migrate sdo_geometry to a db opengis. There is an tool for this conversion?

ennio

12-14-2006 08:57 AM
ennio

The architecture group of our company has told us to avoid using ORDER BY in our queries. Their reasons are: - In 10G, order by is incredibly...

baoqinye@gmail.com

12-14-2006 03:17 AM
sybrandb

hey guys ,, i m new to oracle and i m having a problem... how can i find out duplicate tuples and then delete them.... plz reply.......

lalit

12-13-2006 11:49 AM
DA Morgan

Hello am a new student in oracle just need to realize a big database in oracle but i dont have no subjetc so please if you have any idea,just telle me

noumian

12-13-2006 10:54 AM
DA Morgan

Hello, I was asked to create a small PHP-interface to search in an Oracle 10.1 database. A field will contain a small text, I need to search inside...

Uwe Ziegenhagen

12-13-2006 08:58 AM
Martin T.

Hi, I am getting the above error when the C++ application is executing the Oracle stored procedure. The SP contains few IN parameters and one...

sangu_rao@yahoo.co.in

12-13-2006 04:39 AM
sangu_rao@yahoo.co.in

Hi there, Forgive my bad use of terminology I've never used Oracle Portal before....... I've inherited a Java web app that runs via Oracle portal....

Lord0

12-13-2006 03:02 AM
Lord0

Hi, I am having issues with nls_sort=binary_ci, nls_sort setting is not sorting rows in case insensitive Oracle 10g R2 Linux x86 steps I followed

janu

12-12-2006 06:24 PM
joel garry

A good example of Oracle Unit Testing can be found at http://www.oracleunittesting.com Includes source code and pdf download of site.

WebCom Systems

12-12-2006 11:10 AM
DA Morgan

Hi, is it possible to restrict a select (with group) that it returns only the first 10 records of the result set (counted "after" group...

Norbert Winkler

12-12-2006 08:47 AM
Norbert Winkler

I have been asked to export some oracle tables to text files. The main problem I am having is the resulting file. The sql for the requested fields...

CriticalJ@gmail.com

12-12-2006 01:39 AM
sybrandb

Hi All, I am using Foxpro to extract data from ORACLE9i. I am connected through ODBC. One of the field in DB is number. When I retrieve the data...

beerora

12-11-2006 05:44 PM
DA Morgan

....as always, with support for Oracle and other dbs. Altova® is pleased to announce the availability of Version 2007 of its XML product line....

announce@altova.com

12-11-2006 09:30 AM
announce@altova.com

I am facing a Problem here.. For example , The Value of empl_status in job table is one character ( Active - A, teminated - T ) Here comes the...

koorisatheesh@gmail.com

12-10-2006 09:36 PM
Michael Austin

Can you show me a pl/sql procedure to see all informations about a specified concurrent request, giving your request_id number ? @c:\show_request ...

apogeusistemas@gmail.com

12-10-2006 11:50 AM
Mark D Powell

What's the NOLOGGING clause for when creating tables? Some of our tables (particularly intermediate and output set tables) have been created with the...

dean

12-10-2006 01:40 AM
sybrandb

Hi, I am curious to know why this query: "select count(*) from far_employee sample block (1);" returns zero at times and some other times returns a...

prateek

12-09-2006 05:42 PM
Mark D Powell

There is a legacy database running here at work, which I want to move to a new server. I have all the media in relation to 8.1.5.0.0 but can not see...

VB

12-08-2006 08:12 PM
Michael Austin

Hi All, I have a table (table1) with 2 columns (ID, keywords) The ID column is the PK (values 1..n), and the keywords column is varchar with words...

RJ

12-08-2006 11:08 AM
Maxim Demenko

Hi, i'm trying to run the DBMS_REPAIR check routine but i get a PLS-00302 error. Can any1 help? thks, Andy SET SERVEROUTPUT ON DECLARE...

supernova

12-08-2006 10:02 AM
DA Morgan

I have lacks of records. I want to check if the account_no is present in that table or not. In my current application i have used cursor. If i took...

varsha.gadekar@gmail.com

12-07-2006 10:11 AM
Mark D Powell

Hai everyone, Can someone tell me whats the difference using AND and WHERE in the ansi join. Its basically used to further filter the query,...

BigLearner

12-06-2006 12:58 PM
Maxim Demenko

Hello, i have a oracle 10.2 database called tdbha50_storet which i am testing from two different oracle enviroments: env_1: windows xp professional...

Yalta

12-06-2006 09:01 AM
Yalta

Can anyone help me with this problem. I'm using Oracle 9i and SQL Developer 1.0.0.15.27. Here is some test code. CREATE OR REPLACE PROCEDURE TEST...

plissken

12-05-2006 03:17 PM
plissken

Hai everyone, This is what I get from one of the sites when I searched for outer joins but my book says having + on right means outer join and if...

BigLearner

12-05-2006 12:02 PM
Ed Prochak

Hello All, After searching the web unsuccessfully for what I am looking for, I have come here. I need to generate a 6 digit alpha-numeric sequence...

kranilk@gmail.com

12-05-2006 11:50 AM
Ed Prochak

Hai everyone, Can someone explain to me how + works against right and left outer join. My book and the articles that i see on the web are...

BigLearner

12-05-2006 06:56 AM
Charles Hooper

Hi all, Oracle 10g RAC on Linux .. I have a situation with two tables, one of which holds information about an item, and the other which holds...

Geoff Muldoon

12-05-2006 12:07 AM
Geoff Muldoon