| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 4 | 5 |
|  | 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 | 4 | 129 |
|  | 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 | 3 | 105 |
|  | 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 | 1 | 103 |
|  | 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 | 4 | 111 |
|  | 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 | 9 | 109 |
|  | 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 | 12 | 175 |
|  | 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 | 2 | 120 |
|  | 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 | 13 | 183 |
|  | 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 | 2 | 133 |
|  | 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 | 1 | 98 |
|  | 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 | 0 | 131 |
|  | 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 | 23 | 269 |
|  | 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 | 4 | 108 |
|  | 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 | 1 | 118 |
|  | 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 | 5 | 117 |
|  | 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 | 1 | 119 |
|  | 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 | 3 | 122 |
|  | 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 | 4 | 117 |
|  | 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 | 3 | 116 |
|  | 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 | 4 | 127 |
|  | http://coderbuzz-programming.blogspot.com/2007/12/oracle-interview-questions-1.html
raae
|
12-21-2007 12:24 PM
raae | 0 | 116 |
|  | 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 | 9 | 108 |
|  | 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 | 6 | 126 |
|  | 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 | 19 | 239 |
|  | 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 | 2 | 135 |
|  | 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 | 2 | 108 |
|  | 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 | 1 | 119 |
|  | 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 | 1 | 128 |
|  | 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 | 0 | 110 |
|  | 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 | 2 | 113 |
|  | 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 | 1 | 108 |
|  | 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 | 2 | 122 |
|  | 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 | 3 | 101 |
|  | 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 | 3 | 141 |
|  | 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 | 2 | 116 |
|  | 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 | 3 | 138 |
|  | 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 | 3 | 125 |
|  | 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 | 0 | 102 |
|  | http://coderbuzz-programming.blogspot.com
lawry_jim@yahoo.com
|
12-11-2007 11:55 AM
lawry_jim@yahoo.com | 0 | 113 |
|  | 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 | 1 | 121 |
|  | 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 | 0 | 122 |
|  | 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 | 2 | 118 |
|  | 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 | 5 | 122 |
|  | 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 | 2 | 108 |
|  | 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 | 4 | 108 |
|  | 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 | 0 | 115 |
|  | 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 | 1 | 115 |
|  | 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 | 1 | 111 |
|  | 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 | 1 | 108 |