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-04-2008 12:27 AM
DA Morgan

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:15 AM
DA Morgan

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 12:41 PM
patrick

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

Babbs

01-03-2008 11:36 AM
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 09: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 06:54 AM
Ken Denny

Hello, In my VB 6.0 code, I have tried to connect to oracle-database, but program just hang (even there is no exception !!!) Code is : In alert.log...

Mr. X.

01-02-2008 01:12 PM
joel garry

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 11:35 AM
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 10: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 10: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-31-2007 10:50 AM
fitzjarrell@cox.net

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 04:32 PM
Bora Yuret

I am new to Oracle and I installed the Oracle 10g Express Edition on my windows machine. Immediately after installation, it worked great and I was...

scout1024@gmail.com

12-29-2007 09:19 AM
Frank van Bortel

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 02: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 09: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 07: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 03:20 AM
shakespeare

Hi, I currently have a package and contained within it I have 2 procedures. The first procedure has a parameter (SEQ_ID) passed into it from...

christophercash@hotmail.com

12-22-2007 03:11 PM
Galen Boyer

Hello I am new to Oracle. What I am trying to do is basic, I think. I typically use toad to run select statements. I want to be able to create a...

AP

12-22-2007 03:04 PM
Galen Boyer

Here's my situation - I'm working on a large scale data cleanup project and part of my duties include finding and fixing data anomolies such as date...

syclone98@hotmail.com

12-22-2007 09:09 AM
Mark D Powell

I am a beginning Oracle 9i user and I was hoping that someone can help me. I think I have the basic SQL statements down pat, but this problem is a...

cnbland1@juno.com

12-21-2007 03:42 PM
Charles Hooper

http://coderbuzz-programming.blogspot.com/2007/12/oracle-interview-questions-1.html

raae

12-21-2007 12:24 PM
raae

Hi, We have a master table, say with two columns name (varchar) and id (number) and a stored procedure insert_name_details(name, other details). SP...

sameergn@gmail.com

12-20-2007 03:06 PM
Robert Klemme

Hi. Anyone can guide me on this. I have a legacy structure where i have 12000 clients. each client has a password. Table_Name = clients Fields= ...

Aquiles.-

12-19-2007 06:13 PM
Pedro Lopes

Hello, i am having trouble creating tables from a package using oracle 10g. i am logged in as user 'testuser' and am working in the users...

andized@gmx.net

12-19-2007 11:04 AM
fitzjarrell@cox.net

Dear Friend, We are a chennai based well reputed HR consulting & recruitment company. Presently one of our esteemed MNC client in the IT consulting...

Baffin Management Solutions

12-19-2007 10:48 AM
DA Morgan

Hi, I have to following problem: I get X rows from a statement, these are sorted by a certain column, let's say an numerical value. Now I want to...

Jens Riedel

12-18-2007 09:16 AM
Jens Riedel

Hi there, I have a profile configured to lock users' accounts after 3 unsuccessful login attempts. Is there a view that can tell me how many...

steven@ferretlovers.com

12-18-2007 08:25 AM
Jerome Vitalis

Dear all I am installing Oracle10g (10201_database_linux_x86_64.cpio.gz (758,433,170 bytes) (cksum - 2921604215)) on RHEL5 64bit # uname -a Linux...

madunix

12-17-2007 09:05 AM
fitzjarrell@cox.net

I am always in search of the best deals online. Check out http://www.christmasplayland.com that I came across.Great onestop Christmas marketplace for...

e922nmwt

12-15-2007 08:17 PM
e922nmwt

Is there a way to display a trigger programatically, or via commandline, or via sql code? The only way I know how to display a trigger is to...

Sean Nakasone

12-15-2007 02:20 AM
Thomas Kellerer

Why in Forms sometimes is problem with copy and paste in application made in Oracle Forms Developer 10g. :)

grybi

12-13-2007 03:17 PM
Frank van Bortel

Hi my config. Oracle 10g RedHat linux fedora 4 Host=winxp pro sp2 tool=vmware When I use runInstaller to install oracle, there are some exceptions...

Jacky

12-13-2007 10:41 AM
shakespeare

Hello, in our system, we want to classify messages (stored in a table) with certain attributes (sort them into categories). Later, we want to...

Marten Lehmann

12-13-2007 10:15 AM
Maxim Demenko

On Oracle 9.2.0.5, windows 2000 server, select * from SYS.dba_ddl_locks after a time being resulted with an error ORA-04030: out of process memory...

Tomo

12-13-2007 07:48 AM
Tomo

I am trying to use the UNION ALL in a CURSOR declaration. It compiles fine and when we run the program it fetches only the rows corresponding to...

boopathi.it@gmail.com

12-12-2007 01:01 PM
grybi

Hi, I have requirement to sort the data something similar to Dictionary. For example: I have to get the words those have starting character : spaces,...

aru

12-12-2007 08:48 AM
aru

Production servers: RAC Oracle 10g 10.2.0.3, AIX 5.3 ML3, 2 Nodes IBM pSeries 550. Symptoms: CRS Status "Can not communicate with CRS" After the...

madunix

12-11-2007 10:08 PM
DA Morgan

143.204.94.82:2384 open socks4 proxy was used on 22 November for a Hipcrime attack on nanae. And I got the port number by Googling so it must have...

Tester

12-11-2007 09:50 PM
Tester

http://coderbuzz-programming.blogspot.com

lawry_jim@yahoo.com

12-11-2007 11:55 AM
lawry_jim@yahoo.com

After moving several tables from one tablespace to another, will the original table still exist? I've issued the Alter Table Move Tablespace command...

jjablt@hotmail.com

12-10-2007 09:46 PM
DA Morgan

Hello all. I am experiencing a core dump in a "OracleConnect" method we have written. Here is the stack trace: #0 0xb695fdd1 in sqlsadr () from...

aj

12-10-2007 03:50 PM
aj

I would like your help on the following situation: Anybody who has worked with oracle forms 6i on solaris on sparc machines with sun keyboard, should...

Aggelos

12-10-2007 02:06 PM
shakespeare

Suppose you have a SELECT stmt of form: SELECT Field1, Field2, Field3 FROM Table1 WHERE etc What would it take to generate a file from the output...

Occidental

12-10-2007 12:14 PM
joel garry

Read briefly on Oracle's web site that they've added a "hands-on" training requirement to the OCA/OCP certs... to "enhance their value" or some...

dananrg@yahoo.com

12-07-2007 06:59 PM
joel garry

CREATE TABLE SQL_TABL ( ORD_DATE Date, PROD_CODE Varchar2(10), CUST_CODE Varchar2(10), QTY ...

Totti

12-07-2007 01:13 PM
Ed Prochak

Hi, Please accept my apologies if this is the wrong group to post to. I have an issue with processing XML. I have a CLOB which contains XML....

Raj

12-06-2007 08:39 PM
Raj

Hello! Big problem in subject :-) ples send me some page or info how can i do it. thx

anotnio12

12-05-2007 08:26 AM
DA Morgan

CREATE TABLE SQL_TABL ( ORD_DATE Date, PROD_CODE Varchar2(10), CUST_CODE Varchar2(10), QTY ...

Totti

12-05-2007 08:10 AM
Brian Tkatch

Is there a way to write a sqlplus batch file to "recompile all invalid objects", or at least compile a specific object? I know the capacity exists in...

Ubiquitous

12-05-2007 12:01 AM
DA Morgan