I'm trying to enable Kerberos authentication through Advanced Security Option for Oracle9i DB (9.2.0.4). Server and client are on the same Windows...

Matthias Haslbeck

03-01-2004 05:25 AM
Matthias Haslbeck

Assuming I only have access to SQL*Plus, how would I see what values the NLS_NUMERIC_CHARACTERS is set at for: 1) a particular database, 2)...

UNIXNewBie

02-28-2004 02:39 AM
SOLSPEAKS

Dear Oracle Community Could you help me ???? !!! I have to parse different xml documents and save them in a set of tables in Oracle 9i. A person...

Miguel Lienlaff

02-26-2004 09:46 AM
IgorB

If there is a query that is actually composed of a series of selects that are grouped together with UNIONS and within each major select there is a...

kstahl

02-26-2004 07:46 AM
IgorB

select 'SUCCESS,',trim(P.account_obj_id0) ACC_OBJ,',',trim(P.DEAL_ID) DEAL_ID,',',trim(L.CC_DESCRIPTOR) CC_DESC from (select U.account_obj_id0,...

Diwakar Shukla

02-26-2004 07:17 AM
Diwakar Shukla

Hello everyone. Is there any way (system perspective) to find out if a statement modifies any table? Let's say I want to invoke some stored...

Pablo

02-26-2004 05:47 AM
Pablo

I AM SEARCHING FOR AN ORACLE OR SQL(PREFERRED) DATABASE THAT CONTAINS THE CONTENTS OF THE WORLD ATLAS. I WOULD PREFER TO HAVE THIS FOR FREE AS THIS...

Inquest750

02-25-2004 10:54 PM
Inquest750

I'm trying to configure Kerberos for use with Oracle9i Database through ASO (Advanced Security Option) and Windows 2000 Server with Active...

Matthias Haslbeck

02-25-2004 11:14 AM
Matthias Haslbeck

Am looking at an Oracle SQL reference book. They have the following SQL for ROLLUP which works SELECT 0.YEAR, TO_CHAR(TO_DATE(O.MONTH, 'MM'),...

UNIXNewBie

02-24-2004 08:49 PM
UNIXNewBie

Below is some DDL SQL taken from the Oracle documentation creating a range partioned table, partioned on TIME_ID. I tried the following DML which...

UNIXNewBie

02-24-2004 11:03 AM
UNIXNewBie

Hi, I'm using: - Oracle 9.2.0.1.0 on Linux - Microsoft ODBC for Oracle 2.573.9030.00 - Application using ADO 6.0 I have an application which runs a...

rich

02-24-2004 04:16 AM
rich

Why is it that some application will define their own users ( maintaining username and password, defining roles, etc ) instead of using Oracle...

sylvain

02-23-2004 07:47 PM
sylvain

hi is it possible to do add the value returned by a requery in a field? --create another field alter table postes add nblog integer i would like...

Marc Collin

02-22-2004 10:28 PM
VS

Hello, I have a very simple table, and want to create a trigger that updates the date column entry (with the current date), whenever a row...

M

02-21-2004 12:11 AM
VS

Hi, I have a simple java classes trying to call a function in a database. Below is the function signature. function search_pipe_out (p_matching_ids...

avinash

02-20-2004 07:31 AM
avinash

I am trying to do some analysis on customer's locality, so I'd like to extract numeric part from address. Here is how the table looks like Table...

David Chang

02-19-2004 11:22 PM
UNIXNewBie

Splitting large file by starting charcater using UTL_FILE Hi, I am trying to split a large file. Here are my criteria: 1. It should start with first...

Sanjay

02-19-2004 09:23 PM
Sanjay

The NLS_TERRITORY has an affect on the default NLS_DATE_FORMAT. I have determined that the NLS_TERRITORY for a base is set to AMERICA. Where can I...

UNIXNewBie

02-19-2004 04:13 PM
UNIXNewBie

Hve tble with date field. the query prompts the user for the dates ( inclusive): query is select name, datesold from table where datesold >=...

Bob

02-19-2004 09:37 AM
clearex@istar.ca

Hello I took a course in Oracle 8 (unfortunately, never did get to use it for work).. I have recently downloaded Oracle 9i in order to try to brush...

Terry

02-18-2004 10:10 PM
kstahl

I've got this query in the "old" join Oracle syntax. SELECT T1.C1, T2.C1,

UNIXNewBie

02-17-2004 06:41 PM
Hilarion

Hello, I am working on a project, where they use CDM for Oracle projectdocumentation. For testing I am looking for (nearly) closed projects which is...

Jack Bartholomeüs

02-16-2004 02:33 AM
Jack Bartholomeüs

This may be obvious, but I don't write many triggers so it's got me puzzled.. Row level, after update trigger is designed to perform an insert or...

Mike Stenzler

02-15-2004 11:27 AM
Raj Jamadagni

Hi, I am working in a compnay that uses oracle to manage its bussiness. I am new in it, and i thought that being an OCP would be really inhance my...

Ahmed Abughoush

02-15-2004 05:23 AM
Ahmed Abughoush

Hi all, I am trying to write a stored procedure in pl/sql to encrypt some fields in my database(Oracle 9i). I am using a java method wrapped...

David

02-13-2004 06:39 AM
David

Hi all, I am trying to write a stored procedure in pl/sql to encrypt some fields in my database(Oracle 9i). I am using a java method wrapped...

David

02-13-2004 06:35 AM
David

I am going to drop a primary key from one column and create a new column to be used as primary key in an existing database. The old column was a date...

Ken1

02-13-2004 04:20 AM
Ron

Hello Group, I am using Oracle 9i Enterprise Edition 9.2.0.1.0 on Windows XP. I am reading the book "Oracle 9i For Dummies" about objects. I...

Emad-ud-deen Richard Leiman & Eva Fithria Leiman

02-12-2004 04:40 PM
Emad-ud-deen Richard Leiman & Eva Fithria Leiman

Hi, We have a web application where we want a user to be able to change his/her password if the password has expired but we are unable to do this...

ecPunk

02-12-2004 02:51 PM
ecPunk

Hello Group, I am using Oracle 9i Enterprise Edition 9.2.0.1.0 on Windows XP. I am reading the book "Oracle 9i For Dummies" about objects. I...

Emad-ud-deen Richard Leiman & Eva Fithria Leiman

02-12-2004 11:27 AM
Emad-ud-deen Richard Leiman & Eva Fithria Leiman

Where Oracle store the Optimal parameter of a Rollback Segment OFFLINE. -The view DBA_ROLLBACK_SEGS show the parameters of all the Rollback Segment...

Bultez R?gis

02-12-2004 09:48 AM
Bultez R?gis

SQL*Net problem I tried to install Designer/2000 on Windows 98. There was no problems with Forms and Reports, but when I tried to install SQL*Net...

Nera

02-12-2004 09:26 AM
Nera

Hello, Im trying to decide if being an oracle dba is for me, I figured Id share my thoughts an seek any knowledge professional users...

Cameron McCormick

02-11-2004 07:19 PM
Chiefs_rule

We have an application that has cursors open in the database in one instance and does not have any open cursors in an other instance....

Ravi Tallury

02-11-2004 07:13 PM
Ravi Tallury

I'm trying to do some automation by placing a set of Oracle commands into a DOS batch file. The "recover database using backup controlfile;"...

Reid L Maier

02-11-2004 05:51 PM
Reid L Maier

Dear Colleagues, We would like to contribute to DBA community small and free SQL Formatter - sqlReview. Tools is designed to get unformatted...

Ron

02-11-2004 04:21 PM
Ron

Hi, I'm trying to come up with a solution to seemingly simple database query, which I'm sure could be done with Oracle9 analytical functions, but...

Yuri G.

02-11-2004 01:01 PM
VC

I've just been asked to create some "flat files" being new to this I'm not quite sure how to proceed. One of these flat files is a straight dump...

UNIXNewBie

02-11-2004 11:36 AM
Vladimir Andreev

Hi experts I want to know if there is any db hosting service available for remote access from desktop application. I have account with Yahoo but...

Shahzad Ch.

02-11-2004 05:37 AM
Ron

At the end of Oracle 9i installation, the Agent Configuration Assistant failed...

Luke

02-09-2004 09:39 AM
Luke

Hello, I'm looking for a reliable software solution for archiving a production database to a backup database. the main goal of the archiving tool...

fhoornaert@hotmail.com

02-06-2004 01:27 AM
DBA Infopower Support

Can anyone tell me the price of Oracle database for academic? Thanks, ff

f

02-05-2004 06:13 PM
Daniel Morgan

Hi All, I've reposted this as my original post never seemed to make it off my local news server, so here goes Google... I have a set of 50...

Pink Panther

02-05-2004 04:52 AM
Pink Panther

I tried running a query (t1 union t2) union t3 and I get a parse error. However if I break the query down in these lines: t4 := t1 union t2; t4...

Kim

02-04-2004 11:31 AM
Vladimir Andreev

Hi, I have a quick question. Which role/privileges are required before a user can give the statement "GRANT ALL PRIVILEGES"? Thanking you in...

Amardeep Verma

02-04-2004 06:54 AM
Amardeep Verma

Hi, I want to use the Toad interface for the database server of Oracle9i. Is it possible to download the client dlls for windows alone? I haven't...

Jesper Matthiesen

02-03-2004 12:43 PM
Chris Leonard

Hi, I am using Oracle 9i database and trying to do a recovery from my prod machine (System = SunOS,Release = 5.8,KernelID = Generic_108528-14) to...

Aravind

02-01-2004 04:23 AM
s.kapitza

I am trying to help a user tune a very intersting query presented by a user. Currently runs in about 7 seconds. SELECT * FROM ((SELECT DISTINCT...

James A. Williams

01-29-2004 03:02 PM
James A. Williams

Dear Group: Hi: The Oracle Forms Version which is available for Download on Oracle's Website is For how many Clients? The Client Available with it,...

Azhar Bilgrami

01-29-2004 10:20 AM
Jim Kennedy

Dear Group: Hi: The Oracle Forms Version which is available for Download on Oracle's Website (Free Of Course) is For how many Clients? The...

Azhar Bilgrami

01-27-2004 04:49 AM
Azhar Bilgrami