hi all. i want to Produce total sales per month per indicated region. The total should include only sales of products with more than 4,000,000...

Totti

01-15-2008 10:14 AM
fitzjarrell@cox.net

Poll: How fast is YOUR database in rows per second, on a full bore table scan??? This is for those who like Tom Kyte's work, and empirically get...

dba_222@yahoo.com

01-15-2008 08:45 AM
Frank van Bortel

1) What are the real bytes per value (RAM) associated with each element of a Varray of NUMBER? (Of INTEGER, of PLS_INTEGER, of VARCHAR2(20) etc).We...

sideyt

01-14-2008 05:02 PM
joel garry

I love these external tables. It really gets rid of the old UTL_FILE.GET_LINE. Anyhow, is there a way to create an external table where the...

amerar@iwc.net

01-14-2008 01:51 PM
fitzjarrell@cox.net

Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is...

A Real Dead One

01-14-2008 07:30 AM
news.verizon.net

Hi, I have a question on how composite index should be used. As an example, my queries often select two leading columns, column_1 and column_2 of a...

nickli2000@gmail.com

01-14-2008 12:38 AM
nickli2000@gmail.com

Hi, at least since Oracle 10.2.0 the Oracle Linux distribution contains an ODBC driver which works with unixODBC. After installation of the Oracle...

Andreas Thiele

01-13-2008 06:51 PM
Andreas Thiele

Hello, I was working as a trainer(contractor) for Oracle University Turkey and for their education partners. One of their partners tried to force me...

Bora Yuret

01-13-2008 01:55 PM
Bora Yuret

hi all, i am posting a sample of a result i am getting from the...

Totti

01-13-2008 12:24 PM
Charles Hooper

hi all, i have a sales table that i want to get the balance for some specific condition products, i am getting the wrong balance since i lack the...

Totti

01-12-2008 07:11 PM
Totti

This is driving me crazy! Ok, I have an external table that is tab delimited. I am not interested in all of the fields, jsut a few of them. My...

amerar@iwc.net

01-12-2008 03:25 PM
fitzjarrell@cox.net

Hi: Please let me know if you have any resources with you for this opportunity? ***Mail resume and contact details to sachi (AT) ciits (DOT)...

Sachi Tadepalli

01-12-2008 10:06 AM
Mark D Powell

Let me present you with some of list of consultants Name Primary Skills Total/US Exp Manas Dey Oracle Apps Distribution, Supply Chain Planning &...

Babbs

01-12-2008 10:04 AM
Mark D Powell

Hi, I am trying to execute my newly created 'Login' stored procedure. For some reasons I get error on dbms_outout.put_line line code. Can someone...

Vidya

01-11-2008 10:17 PM
Vidya

When creating a user account, is there a good way to add a comment regarding that user account? Something like "test account for ldap synchronizer",...

mh@pixar.com

01-11-2008 04:36 PM
joel garry

Hello, I am no Query expert so I would appreciate it very much if someone could help me out. We use Oracle 9. I have 1 table named contents. This...

M@r(o

01-11-2008 08:36 AM
fitzjarrell@cox.net

anyone have code snippets to copy table contents from one database to another? i usually use toad and make 2 database connections, then copy data...

Sean Nakasone

01-11-2008 04:24 AM
shakespeare

ok, I am a contractor trying to install 10g on a server. I have NO experience with this. I have 18 discs and no idea what to install or which one...

mike

01-10-2008 03:32 PM
Markus Tazl

Hello, in our application it would be very helpful, if the search wouldn't return only exact matches, but also similar items, e.g. search for...

Marten Lehmann

01-10-2008 03:23 PM
Marten Lehmann

Bit of a noob question I'm afraid... I've had a look on t'interweb and it has got me so far, but I'm doing something wrong. I've managed to run...

CJM

01-10-2008 12:51 PM
CJM

Hello, How can I read from registry (VB 6.0) ? Need sample code, please. Thanks :)

Mr. X.

01-10-2008 06:45 AM
Arch

The existing server extensibilities in modern DBMSs have been critical in our company's development of software products that improve database...

Eric Davies

01-09-2008 09:19 AM
DA Morgan

hi all, i have some big tables i am generating in excel, and i want to create them in my DB, since they are many and every one is >20 000 rows, i...

Totti

01-08-2008 07:47 AM
Charles Hooper

Hi, I'm using the cx_oracle python module to access an oracle database It works fine but when I run within a qt environment it fails with...

labrach@gmail.com

01-08-2008 04:13 AM
labrach

Hello, I'm trying to retrieve a list of tables from all_tables in a given Oracle db. I'm using the .NET provider (by Microsoft) and I always obtain...

abbeyro@gmail.com

01-08-2008 01:44 AM
Robert Klemme

Hi All, I've looked over some internet pages and have not found the solution yet..... I have a cursor which is the same in terms of columns for 5...

amerar@iwc.net

01-07-2008 05:21 PM
amerar@iwc.net

Hi all , i want to get out of the data, the most popular good/month i have in my data, i figured out that it would be the one having the maximum...

Totti

01-06-2008 04:24 PM
DA Morgan

hi all, how ca put multiple statmwnts in sum(case statment? like if i have 4 regions, and 1 product, if for each region the transport fee is...

Totti

01-06-2008 04:21 PM
DA Morgan

Could someone please help me to better understand the application of collections in PL/SQL? Specifically, I wish to better understand when to use a...

Mook

01-06-2008 12:54 PM
news.verizon.net

hi all , i want to take out of the data (more than one table) the total purchases and the total sales, put each in a column near to each others and...

Totti

01-05-2008 05:46 PM
Totti

http://coderbuzz-programming.blogspot.com

lawryy

01-05-2008 01:14 PM
DA Morgan

JustOracle.com is a great source for Oracle jobs across all sectors like Apps Functional, Apps Technical, DBA, Developer, Web server, Designer,...

james2345

01-05-2008 10:17 AM
DA Morgan

hi all i am having the following error : ORA-00920 invalid relational operator i read the quotes of other people who had the same problem but i...

Totti

01-05-2008 09:30 AM
Charles Hooper

Hi Our organisation is using an off the shelf application which has an Oracle database back-end. We have a licence for 10 concurrent users. We now...

Steve

01-04-2008 07:18 PM
joel garry

Hi All, I am SQl DBA professional working since 2 years and I also want to work on Oracle. So, Please suggest me that should i start with Oracle 9i...

Luv

01-04-2008 06:54 PM
DA Morgan

Hi All, I am SQl DBA professional working since 2 years and I also want to work on Oracle. So, Please suggest me that should i start with Oracle 9i...

Luv

01-04-2008 04:35 PM
Luv

hi all i want to generate the total sales of the 3 most sold products of a firm, i ll try to write it here as follows from more than one table but...

Totti

01-04-2008 02:46 PM
Charles Hooper

I have a stored procedure that works just fine when testing, but throws that "Missing right parenthesis error when I call it. call...

chris.damsgard@gmail.com

01-04-2008 12:30 PM
chris.damsgard@gmail.com

hi all, i have a little problem with a formula in oracle which i dont know how to do it all, i have done many attempts but no success! i will write...

Totti

01-03-2008 01:41 PM
patrick

Hi, We have an Immediate Opportunity for you as Oracle HR Technical Consultant Location : Green Bay, WI.

Babbs

01-03-2008 12:36 PM
fitzjarrell@cox.net

hi all, i want to get the top 3 product that are the most sold, i want to use in the where clause, rowNum <= 3 but i dont know what is the...

Totti

01-03-2008 10:39 AM
Totti

Hi, I have a table with the following two columns and sample data: tran_date DATE; digits NUMBER; 10/2/2007 ...

nickli2000@gmail.com

01-03-2008 07:54 AM
Ken Denny

i have a column in my database with Long datatype, and i have to update the values in it. when i am trying to update it via UPDATE UM_TB_PD_BU_ACCSS...

uday

01-02-2008 12:35 PM
Mark D Powell

I am new to Oracle. I need to connect to a Oracle 8 database to extract some data. I have read some of the postings and wonder what is the least...

TD

01-02-2008 11:57 AM
Martijn Tonies

UI Tool : VC 2005, Database: oracle OS - Window XP Hi Everyone, Given stored procedure generate new key for given key name. CREATE OR REPLACE ...

vijay

12-31-2007 11:52 AM
DA Morgan

Hello, I was working as a trainer(contractor) for Oracle University Turkey and for their education partners. One of their partners tried to force me...

Bora Yuret

12-29-2007 05:32 PM
Bora Yuret

SAN FRANCISCO - Oracle Corp. fared far better than analysts anticipated in its fiscal second quarter, easing worries that the sagging U.S. economy...

DA Morgan

12-26-2007 03:47 PM
DA Morgan

Hello, Is the alternative quoting mechanism in 10g supported in 9i? In other words, the following query is understood in 10g: select * from...

csimam@gmail.com

12-26-2007 10:36 AM
fitzjarrell@cox.net

I am using Oracle 9i and I have an issue when in following situation CREATE TABLE BE_FRIEND (NAME VARCHAR(20), INSTITUTE VARCHAR(40)) CREATE TABLE...

basab.datta@gmail.com

12-26-2007 08:42 AM
basab.datta@gmail.com

This is Oracle tutorial, to give a brief of databases and Oracle's role in that , explain relational theory and provide a few practical examples to...

oracletutorial@gmail.com

12-24-2007 04:20 AM
shakespeare