Hi, In a few databases, the following statements results in a missing "Z" at the end? A bug? SQL> select TO_CHAR(systimestamp,...

suvinay

07-25-2006 02:06 PM
suvinay

Hi all, In one of our databases we need 1 user to reset passwords from other users. (some kind of admin function). Ofcourse this "admin-user"...

AT

07-25-2006 10:51 AM
Mark D Powell

We have an application which works with mysql and has various time datatypes. The various tables include a mysql data types datetime, date and...

martin.j.evans (AT) gmail (DOT) com

07-25-2006 03:51 AM
DA Morgan

Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 10g Monitoring & Security Application (Xg). Xg...

AT

07-24-2006 04:19 PM
meathammer

Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 10g Monitoring & Security Application (Xg). Xg...

AT

07-24-2006 02:46 PM
AT

We're running Oracle 9.2.0.6 database and Developer 9.0.4.2 on RH Linux 3.0. All the forms compile but when I run the first one I get an...

Ed_Zep

07-24-2006 09:32 AM
Ed_Zep

dilemma: using a select statement ONLY is it possible to get the results to concatenate in a string such as? select field from table; original...

AT

07-22-2006 06:50 AM
Charles Hooper

I have user joeschmo in a 10g database. I have a script that creates a bunch of tables, sequences, packages, etc. under that user...

AT

07-22-2006 01:21 AM
Michel Cadot

Hi, Possibly a daft question, but I can't seem to find the answer anywhere. If I submit a job via dbms_scheduler, and it fails (for whatever reason)...

yorky

07-21-2006 10:22 AM
yorky

Hi - I've been told to get jinitiator 1.8.1.13 First I cannot find this (but 1.3.1.13 does exist) Second question - how does versionning work ? ...

Grumps

07-21-2006 05:05 AM
Grumps

we set up a new account code and now my balance sheet is out of balance in my FSG report. the new account and balance entered is in the trial...

tonyt

07-20-2006 09:56 PM
tonyt

we are evalutating performance and so this is a query that put together; SELECT prcsname , prcstype , runcntlid, begindttm, enddttm...

Mr.Kane

07-20-2006 04:56 PM
Mr.Kane

Hello experts, I just wrote some code to email users using UTL_SMTP. Now my problem is in the body of the email I want to say "Here is your...

AT

07-20-2006 04:30 PM
Brian Peasland

Hi, Can someone tell me the difference between the following two usages of paralle hint? 1. select /*+ PARALLEL*/ * from emp; 2. select /*+...

mail2jerry (AT) gmail (DOT) com

07-20-2006 02:38 PM
mail2jerry (AT) gmail (DOT) com

Hi, using a select like: select max(date) over (partition by...) how can I retrieve a value from the same row than the max(date) ? For example,...

Billou

07-20-2006 07:36 AM
sim

Hi Experts, I have a question where in i have to get a weeknumber as follows : Week Week Ending 1 1/5/2006 2 1/12/2006 3 1/19/2006 4 1/26/2006

AT

07-20-2006 06:52 AM
Charles Hooper

Hello, here is the setup: I'm importing a text file using SQLLoader into an Oracle 9i database. As the file contains date values with...

Thomas Kellerer

07-20-2006 05:23 AM
Thomas Kellerer

I'm trying to find a way of importing ddl from oracle database into oracle designer to save me a hell of a lot of typing! I've heard it is possible....

Broons Bane

07-20-2006 05:06 AM
Robbert van der Hoorn

I really need some help. I am trying to write a procedure with one inbound parameter as associative array and return a reference cursor. I'm passing...

AT

07-20-2006 04:18 AM
sybrandb

On 8i, I have some rows that are not returning in a select query. The sql is much bigger then this, but the basic problem is.... select...

AT

07-19-2006 09:15 AM
Brian Peasland

In an Oracle function or procedure call, there can be parameters that have defaults, such as language code. If NULL is passed, this overrides the...

PhilHibbs

07-19-2006 05:51 AM
PhilHibbs

What is the current market salary range for Junior DBA (mid-size company) ? (NE US) Looking to move into DBA from development. thanks

meathammer

07-18-2006 06:10 PM
meathammer

Hi, I've been trying to get this SQL, but I just can't get it to work. It should a be a relatively simple SELECT on a single table, with 2 criteria...

Kobee

07-18-2006 04:26 PM
Ed Prochak

Hi, Has anyone used the Oracle OCI driver with Oracle 9i and WebSphere application server V 5. Here is my code: OracleOCIConnectionPool dataSource...

AT

07-18-2006 03:35 PM
AT

I'm on win2003 with Oracle 10.1 server It seems the SQL+ has a problem with spaces. I am trying to run a script that contains the Program Files...

AT

07-18-2006 12:20 PM
Brian Peasland

Good Morning, I need to arrange an export and at the same time compress the result, I want to do this in a shell script, at the moment I use...

AT

07-18-2006 09:44 AM
Mark D Powell

dugmcgee (AT) gmail (DOT) com wrote: I have not had any problems upgrading 10.1 to 10.2. My upgrades went smoothly. But no matter how *my* upgrades...

Brian Peasland

07-18-2006 08:56 AM
Brian Peasland

Hi. I have a query that uses the Like clause like that (only relevant code): .... and fl.status like (case when param1 = 1 then '%NBH%' when...

Robert Scheer

07-18-2006 07:54 AM
G Quesnel

Hello world, when I try to make Oracle Designer connect to a database, it will ask for username, password, and some strange "connect string". While...

Jens Lenge

07-18-2006 04:55 AM
Robbert van der Hoorn

Why does the statistics report in the explain plan take more time to be generated? When I use "set autotrace traceonly explain", it takes zero...

Prasath

07-18-2006 02:54 AM
Gints Plivna

I have the following hierarchical query that returns our company's organizational structure: SELECT TRIM(E.LAST_NAME)||', '||TRIM(E.NICK_NAME) AS...

Mark Petereit

07-17-2006 02:10 PM
Maxim Demenko

I'm trying to call a parameterized stored procedure in C# using microsoft ODBC .NET. Could you please give me some help or hint? Thank you very...

AT

07-17-2006 01:46 PM
AT

Hi guys.... All i want to know is if while importing schema i just want to import the ddl of my views nothing else ( no change in Data and...

AT

07-17-2006 12:13 PM
Michel Cadot

Is it possible to export the table structures(no data), packages, triggers from a schema to a flat file?

Prasath

07-17-2006 08:54 AM
Brian Peasland

Hi All, I'm fighting with the weird problem. I have a public ASP application and suddenly one user reported the problem - very slow rendering of...

gmilosavljevic

07-17-2006 07:36 AM
Charles Hooper

I have a date mydate and i want to subtract X working days off i was thinking of something like loop while x > 0 if to_char(mydate,'d') < 6 then x...

07-17-2006 06:45 AM

create or replace procedure t1 is strSQL varchar2(50); my_cursor INTEGER; begin strSQL:='create or replace procedure t2 is'; strSQL:= strSQL ||'...

AT

07-16-2006 04:38 AM
Frank van Bortel

Dear sir, Any one help me ................. I am working in oracle databse. O/S is unixware. few days ago,our server hard disk has gone bad,and...

AT

07-16-2006 01:46 AM
kishanthakker (AT) gmail (DOT) com

Hi I have somestring entries which consists only of spaces. I like to get rid of those entries but I can not "select" them. Both examples will not...

joes

07-15-2006 06:07 PM
Mark D Powell

To build OLAP cubes in Oracle 9i DB in Windows 2000 Server following are my questions:- Is most appropriate tool for building and maintaining cubes...

Naeem

07-15-2006 09:56 AM
Naeem

ORA-08177: can't serialize access for this transaction ORA-06512: at <triggername>, line 159 ORA-04088: error during execution of trigger...

AT

07-14-2006 04:18 PM
Sybrand Bakker

I have to do a XPath and XQuery Sample but there is always the same error (ORA-06553). I have the following view for Oracle's HR sample: CREATE OR...

AT

07-14-2006 10:02 AM
AT

Can DDLs be retrieved from a dump file? Or is it possible to construct just the schema without the data? Thanks,

raghu

07-14-2006 06:17 AM
Maxim Demenko

Hello, Does anybody know a reason why UTL_COMPRESS would compress to an almost 2:1 ratio? I'm looking into ways to compress LOBS in either 9i or...

Kevin Crosbie

07-14-2006 04:37 AM
Kevin Crosbie

Hi, I have to print a field called order number in all pages with some restrictions. An order Number can have multiple manufacturers and each...

Sujatha

07-14-2006 03:42 AM
Sujatha

Hi, I have a main view from where all the columns are displayed at front end. This view has 6 subqueries in it, of which in one of the view, if...

Sujatha

07-13-2006 05:13 PM
DA Morgan

Hello world, I discovered a strange behavior when renaming primary and/or unique keys of an existing table in Oracle 9i (or maybe it's rather...

Jens Lenge

07-13-2006 04:27 PM
Jens Lenge

Hello I need some advises of DB gurus. I have 2 tables with each hundert thousands of entries. The table have a 1:n relationship. IF I jon...

joes

07-13-2006 01:25 PM
Frank van Bortel

Hi! I have a problem using XA transaction. I have two database on the same oracle server. If I start two transactions with the same XID, one...

sfama

07-13-2006 11:57 AM
Brian Peasland

Hello All, We're encountering an Internal Server Error when a particular report retrieves around 10K records which displays on each page the...

Aleks

07-13-2006 11:22 AM
DA Morgan