Hello, I have a table that contains the fields PERIOD, STOCK, NEW_UNITS, CHURN_RATE. STOCK is only available for a given start period. I want to...

Hans Mayr

08-14-2009 11:29 AM
Michel Cadot

THOMAS GUGGER INDEPENDENT RECRUITER 419-537-9447 tgugger (AT) bex (DOT) net 10 PEOPLESOFT TECHNICAL CONTRACTS----WISCONSIN To set the record...

TOM

08-12-2009 12:55 PM
Ed Prochak

I am inserting a row into a table, and seeing the ora_rowscn change for all the rows in the table. 1. Is this because all the (small) rows are in...

mh@pixar.com

08-08-2009 03:41 AM
mh@pixar.com

I am using 10g Express Edition on Windows XP. I click on Start -> Oracle Database 10g Express Edition -> Go to Database Home Page I enter my system...

Rich

08-07-2009 01:37 PM
Gerard H. Pille

Is there reasonable disagreement on what 1NF, 2NF and 3NF mean? Or is the variety of contradictory in-print definitions of Normal Forms due to sloppy...

dana

08-07-2009 12:42 PM
joel garry

I have a situation that's stumping me for some reason. I have an Oracle 9i system, with a database called abcweb. One user of it, called abcuser,...

Jonathan Schilling

08-05-2009 12:57 PM
Jonathan Schilling

Hi, Are there any differences between DELETE and DELETE FROM statements? Can they be used interchangably? For example" delete from mytable where...

Ninjali

08-04-2009 05:08 PM
David Portas

Hi, When you export a schema, are external tables and directory definitions exported also? So, when I import, it will create the directory...

The Magnet

08-03-2009 01:13 PM
joel garry

Hello all, on Friday I'll take exam 1Z0-052 named 11g Administration I. Did anyone has already taken it? Any hints? I'm studying on exam book from...

d00mfl1ght

08-03-2009 12:18 PM
Mark D Powell

About “Know CRM”: “Know CRM” is an intensive short duration workshop where we don’t just talk about CRM concepts but how they can be implemented...

iware

08-03-2009 03:31 AM
iware

I have a table with 3 fields. country state city USA CA Los Angeles USA CA Sacramento USA OR Portland Canada ...

dn.perl@gmail.com

07-31-2009 09:02 PM
kevin

Hi, I need a way to intercept and modify SQL statement with parameters sent by .NET application. It should be transparently, I mean I don't want...

Zabuti Maxim

07-30-2009 03:20 PM
joel garry

Hi All HOW TO COPY AND PASTE data TO Oracle java application ? I want copy notepad data to one of field. Is it possible ? e.g. In Oracle java...

moonhkt

07-30-2009 01:12 PM
joel garry

http://www.nanometer.ru/users/microsoft-lsd-tv.html doctor-lsd-tv (AT) yandex (DOT) com tel.8_9195265461 patent Japan

doctor-lsd-tv Google

07-30-2009 07:52 AM
doctor-lsd-tv Google

we're running this statement from a VB program ALTER TABLE MyTable DROP COLUMN MyCol However I get an error. ORA-00604: error occured at...

Sicilian Dragon

07-28-2009 01:36 PM
The Boss

Hi, We want to pin a couple of tables, hoping to increase some performance. From the docs, a pinned table means less reads from disk, etc. If the...

The Magnet

07-25-2009 10:49 AM
Mark D Powell

I have this data (it's just a sample for testing purposes): with invoices as ( select 1000 invoice_id, to_date('2009-07-24',...

Álvaro G. Vicario

07-24-2009 12:50 PM
joel garry

In Oracle SQL (or any other dialect), if there an easy way to select all cols in a table except for 2 explicitly specified cols, without having to...

dana

07-23-2009 02:20 PM
Ed Prochak

Hello Experts, I'm using the following query to create a table,which has over 7 million records. I'm writing these query's on oracle 10g using...

novice82

07-23-2009 12:57 PM
joel garry

Hello, I have a problem with checking data integrity if I want to cover a n- dimensional space with rectangles. I look for a solution which runs...

Hans Mayr

07-23-2009 05:40 AM
Hans Mayr

Hi, I'm a novice to sql scripting. Am trying to figure out a design problem, involving some arithmatic computation. I have two tables temp1 and...

novice82

07-22-2009 09:13 PM
novice82

Suppose I have a query like the following. What's the best way to find the position of a particular item? e.g. I would like to find out that: 'fred'...

mh@pixar.com

07-22-2009 03:01 PM
ddf

Is there an RSS or other type of automatic feed that announces upgrades, patches, etc? I would like to find an easy way to follow upgrades so that I...

mh@pixar.com

07-21-2009 09:26 AM
Mark D Powell

Not too long ago, I needed to create a FK relationship from a table in my schema to a table in another schema on the same database instance. I...

dana

07-21-2009 05:24 AM
dana

Which of these 3 operations creates the most volume of total REDO log file entries; not REDO log *records*: INSERT, UPDATE, or DELETE? A colleague of...

dana

07-21-2009 05:23 AM
dana

We have products: PRODUCT: PRODUCT_ID PRODUCT_NAME ========== ============ 100 Foo 200 Bar We have product types:

Álvaro G. Vicario

07-21-2009 03:39 AM
Álvaro G. Vicario

I'm trying to accomplish this: estimates=`sqlplus -s $user/${password} << " EOF" set heading off feedback off verify off timing off SELECT...

The Magnet

07-17-2009 10:42 PM
Tim X

Hi all, Could you help me, I tried to install oracle configuration manager, but it was not successful it show the error screen shot as below...

acleda

07-17-2009 05:50 AM
CarlosAL

http://forexnews-4all.blogspot.com/2009/07/us-stocks-advance-led-by-banks-as.html U.S. stocks rose, with the Standard & Poor’s 500 Index...

sana

07-14-2009 04:16 PM
sana

Hello, I'm working with ORACLE 10.2.0.4.0 on windows server 2003 R2. I need to execute a DOS batch file. I used some code i found in the web (see...

CenturionX

07-13-2009 03:41 AM
Vladimir M. Zakharychev

I'm using dbms_application_info.set_module('my-module','my-action') to set v$session.module and v$session.action. How do I set...

mh@pixar.com

07-10-2009 09:41 AM
Frank

Hi, I'm new to Oracle Financials. I'm using ASP.Net 2.0 and I need to insert Invoice Header and Invoice Line Item information through and Oracle...

gabe

07-08-2009 07:33 PM
gabe

Hello everyone I am trying to delete rows from a massive data table that are "almost" duplicates. I can do a nice query to find them when I join the...

Jeff Calico

07-08-2009 02:28 PM
Jeff Calico

Hello everybody, I'm working with Oracle 10g on Windows. I got this message: 01654: unable to extend index MASTER.XPK_BR by 256 in tablespace...

CenturionX

07-07-2009 11:02 AM
CenturionX

How do I qualify a function or procedure call to indicate that it should be at global scope? I have my own scn_to_timestamp() in a package that...

mh@pixar.com

07-06-2009 05:33 PM
sybrandb@hccnet.nl

given this table: x y -- - 10 a 20 b 30 c I want the best way to to map values -> b [30,inf) -> c

mh@pixar.com

07-06-2009 02:02 AM
Maxim Demenko

Hey, does anybody know what's happening with Dan Morgan? I haven't seen any posts or messages from him in a long time. ed

Ed Prochak

06-30-2009 08:19 PM
Ed Prochak

We had a developer make some changes to production. Idiot. Anyhow, we have a complete backfrom from about 9:00am. There were some changes arounf...

The Magnet

06-28-2009 10:23 AM
jim

I'm trying to learn about analytic functions, more specifically the OVER() clause applied to COUNT() and AVG() functions. I've read the SQL Reference...

Álvaro G. Vicario

06-26-2009 01:59 PM
Robert Klemme

In an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 server, REGEXP_SUBSTR() always returns NULL. E.g.: SELECT REGEXP_SUBSTR('1234,5678',...

Álvaro G. Vicario

06-26-2009 03:23 AM
Álvaro G. Vicario

with love and faith This site contain usefull informations about medical diseases ,medicine and includs usefull links see it * Drugs beginning with...

yaqub khan

06-25-2009 05:01 AM
yaqub khan

with love and faith This site contain usefull informations about medical diseases ,medicine and includs usefull links see it Diseases and Symptoms *...

yaqub khan

06-25-2009 05:00 AM
yaqub khan

Hello everyone, I am using Oracle ODBC to connect tables from an Oracle schema to an empty Microsoft Access DB. In one particular table i have a...

Strange Cat @ Work

06-25-2009 04:26 AM
Strange Cat @ Work

Hello All, Well I'm cracking the books and learning about Oracle. I'm figuring I'll start on the admin side and see how it goes. I'm more...

jj

06-23-2009 11:51 AM
joel garry

I want to play with some Oracle data warehouse features on my PC (OpenSuse 10.3); to do so, I downloaded the Enterprise Edition of the...

Joachim Pense

06-22-2009 11:42 AM
Joachim Pense

Dear all, I have question about analyze. I have daily batch sequence in procedures that started after finish the analyze for all tables But within...

NOVA

06-22-2009 10:14 AM
Mark D Powell

Site contain very much information about airlines inclouds coutry wise airlines companies informations and video see this # Bahrain Airlines #...

yaqub khan

06-19-2009 06:43 AM
yaqub khan

This site contain usefull informations about medical diseases ,medicine and includs usefull links see it * Drugs beginning with "0" * Drugs...

yaqub khan

06-18-2009 08:01 PM
yaqub khan

Hello, I've written a query to get me the metrics (record counts) in the system. SELECT sites.total, main.mains, sub.subs,...

arkarrel

06-18-2009 05:17 PM
Shakespeare

Shakespeare schrieb: No, problem, happens me often enough too... Best regards Maxim -- Why make things difficult, when it is possible to make...

Maxim Demenko

06-18-2009 01:58 AM
mh@pixar.com