| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi there
I'm trying to pass this select statement to Oracle, using ADO
(specifically the TADOQuery object in Borland's compiler):
with T1 as...
deanbrown3d
|
05-27-2005 02:02 PM
deanbrown3d  | 6 | 82 |
| | | Instruktor - Specjalista ORACLE
Miejsce pracy: Ca³y kraj
Ref: Oracle
Wymagania:
• Wykszta³cenie ¶rednie lub wy¿sze
• Bardzo dobra...
instruktor
|
05-27-2005 10:58 AM
Frank van Bortel | 1 | 77 |
| | | dbms_xmlschema.registerSchema() generates the error:
ERROR at line 1:
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML...
FourWinds
|
05-26-2005 11:36 PM
FourWinds | 0 | 69 |
| | | Hi !
Another question from this stupid danish oracle-newbie :-)
I have 2 tables, STOCKTABLE and STOCKTABLE_EXT
I want to update 2 fields in...
Ole Hansen
|
05-26-2005 03:57 PM
Gerard H. Pille | 4 | 95 |
| | | Hi
I've a problem with an application that recently started to produce
strange behaviour with interop. I'm automating Word and Adobe
Illustrator...
a95johjo@hotmail.com
|
05-26-2005 01:12 PM
Walt | 1 | 63 |
 | | Hello Gents
I have a application that work from 3 years and now on a prticular
action show this error :
java.sql.SQLException: Exhausted...
Alessandro Lagostena
|
05-26-2005 12:52 PM
Malcolm Dew-Jones | 3 | 203 |
| | | I have a string of these errors in the oracle logs. I am running Oracle
9.2 on Solaris 8. A google search doesn't reveal any thing. Any help...
zrnaqvi@yahoo.com
|
05-26-2005 11:35 AM
zrnaqvi@yahoo.com | 2 | 180 |
| | | Hi,
I have this error message with port 9200.
The FireWall is ISA.
I try to add a Filter in ISA configuration
TCP protocol, port 9200 , in/out
UDP...
Fabien
|
05-26-2005 09:38 AM
Fabien | 0 | 216 |
| | | I am using Oracle 9i
I need to extract records from a table where certain criteria is met
and then compare 4 fields from those records to 4 fields...
swoop
|
05-26-2005 06:14 AM
andrewst@onetel.com | 20 | 182 |
| | | Is there a way to find out whether a Table was modified in certain
period(E.g.Between 16-Apr-2005,10 am and 17-Apr-2005,9 am)? We could
see that...
qazmlp1209@rediffmail.com
|
05-26-2005 03:02 AM
Lewis C | 3 | 66 |
| | | I read the book and manual on oracle's jdbc driver, and it SEEMS to suggest
that oracle's driver has some extra limitations. However, the...
as
|
05-26-2005 02:53 AM
HansF | 1 | 74 |
| | | I am creating a package for Oracle 8i. I need to pass a variable in
and use that in the SQL statement IN clause. This worked for a simple
equal...
ndpace@gmail.com
|
05-25-2005 10:07 AM
DA Morgan | 8 | 166 |
| | | Björn Wächter wrote:
The best way is define a variable within the procedure.
You could try to work it out dynamically, see
asktom.oracle.com -...
Frank van Bortel
|
05-25-2005 10:00 AM
DA Morgan | 2 | 76 |
| | | I have searched high and low for an answer to this, can anyone help?
I am writing a BEFORE INSERT trigger on a table with a calumn called
COMMENTS...
whitegoose@inorbit.com
|
05-25-2005 01:11 AM
DA Morgan | 4 | 77 |
| | | We have used online redef extensively to convert to partitioned table
from non-partitioned table.
What factors to consider before deciding whether to...
Oradba_Linux
|
05-24-2005 10:44 PM
Oradba_Linux | 0 | 70 |
| | | Hi,
Is there some way to FORCE SQL*Plus to always return a figure for the
number of rows selected?
It doesn't always return the number of rows...
absinth
|
05-24-2005 09:01 PM
Barbara Boehmer | 1 | 61 |
| | | I need to build a large query that uses the subquery I created. I know
there is a way to name the subquery so that I could pull the name of
the...
Garfield
|
05-24-2005 06:59 PM
David Sanabria | 4 | 78 |
| | | Hi. I'm relatively new to plSQL, and I have a bit of a problem. I'd
like to make a package with one procedure creating some tables, and
another...
laszlo_spamhole@freemail.hu
|
05-24-2005 04:24 PM
DA Morgan | 10 | 131 |
| | | Hi Everyone, I'm in the middle of debugging a VB app that calls a stored proc. The stored Proc checks tables and under certain conditions copies...
Steven Howes
|
05-24-2005 02:18 PM
JimStrehlow@data911.com | 2 | 71 |
| | | I would like to set a bind variable within a function
I tried the following:
VARIABLE x NUMBER
CREATE OR REPLACE FUNCTION setX
RETURN NUMBER...
felixpfrunder@gmx.net
|
05-24-2005 12:07 PM
DA Morgan | 3 | 105 |
| | | Hi,
Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and...
Oracle
|
05-24-2005 07:36 AM
Ed Prochak | 1 | 58 |
| | | I am using JDBC to access Oracle from Java program. I need to generate a
huge table from reading a another huge input table. Here is the...
as
|
05-24-2005 04:30 AM
Frank van Bortel | 12 | 127 |
| | | Hallo,
is there an way, to make a difference between the parameter of a
procedure and the column name of a table if the name is equal?
in firebird...
Werner Hofmann
|
05-24-2005 03:37 AM
Werner Hofmann | 6 | 55 |
| | | Following is excerpt from the tnsnames.ora file:
SUMSKYDB =
(DESCRIPTION =
(ADDRESS_LIST...
qazmlp1209@rediffmail.com
|
05-23-2005 10:01 PM
DA Morgan | 5 | 95 |
| | | I am a programmer with extensive exposure working with Oracle
databases. However, up until now, I have been working with databases
that were either...
Chris
|
05-23-2005 12:15 PM
Frank van Bortel | 16 | 128 |
| | | Is it possible to use jdbc batch update with "call" statement? Statements
don't return any recordset. JDBC is ver 2.0, Oracle server version is...
Tõnis
|
05-23-2005 10:13 AM
Tõnis | 0 | 59 |
| | | Can a 3-d database be built using Oracle?
John F. Regus
|
05-23-2005 09:01 AM
Paul | 26 | 164 |
| | | Well, Buying a collection is always useful and result is fruitful. I have
made 3 test collections for oracle and got total of 20% discounts at all.
I...
AndyMc
|
05-23-2005 03:45 AM
Nkd | 3 | 68 |
| | | I'm calling SQL*Plus to run a query from inside a Unix (ksh) script. How
can I tell whether the query returned any rows or not?
Randy Harris
|
05-22-2005 09:09 PM
absinth | 7 | 79 |
| | | Hi,
Consider the following SQL*Plus:
SQL> select row_id from CX_LOCK;
ROW_ID
---------------
1
2
absinth
|
05-22-2005 08:28 PM
IANAL_VISTA | 1 | 64 |
| | | We have some application using Oracle Object Relational features. We
read a quite complex object made of 2 nested objects and about...
cvanti
|
05-22-2005 05:22 PM
cvanti | 0 | 69 |
| | | Hello,
i've to optimize a sql statement for a customer. There are inner join and
join.
Is there any documentation which I can read in order to know...
Christian Wapenhans
|
05-22-2005 02:22 PM
Christian Wapenhans | 3 | 81 |
| | | Can someone please tell me what I am doing wrong. I can't get it to
suppress the command echo in the spool file or suppress the terminal output.
I'm...
Randy Harris
|
05-22-2005 04:12 AM
Sybrand Bakker | 1 | 82 |
| | | Hi,
Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and...
Oracle
|
05-22-2005 03:01 AM
Oracle | 0 | 76 |
| | | Hello. I have a table that stores readings from temperature sensors
every 15 minutes. My problem is that one of them had a problem and kept
reading...
b_addams@yahoo.com
|
05-22-2005 12:12 AM
Gerard H. Pille | 5 | 61 |
| | | I need to develop some Unix (ksh) scripts to run on a HPUX system, but I'd
like to do the work on windows. I tried something called "UWIN"...
Randy Harris
|
05-21-2005 11:52 PM
Randy Harris | 2 | 68 |
| | | Hi !
A quick question from a danish oracle newbie.
I have 2 tables, and i want to update a field in table t1 with the sum
of a field in table...
Ole Hansen
|
05-21-2005 05:22 PM
DA Morgan | 9 | 68 |
| | | Hi,
Is it possible to create a view or a version of data accessible through
same object name (table or view), which returns different values...
vistav20@yahoo.com
|
05-21-2005 12:23 PM
DA Morgan | 5 | 69 |
| | | When I kick off an applet using Oracle Scripting ( in Oracle Apps ),
the applet fails to launch and initialise correctly. When invoking any
other...
JavaEnquirer
|
05-21-2005 09:03 AM
JavaEnquirer | 0 | 68 |
| | | Hallo,
is there a solution to reset a sequence inside a trigger?
I wanted to use this procedure:
####################
CREATE OR REPLACE PROCEDURE...
Werner Hofmann
|
05-21-2005 07:00 AM
Paul | 17 | 138 |
| | | LOS ANGELES - Relational Database Consultants Inc. (RDC) proudly
announces the 5.0 release of the Encryption Wizard for Oracle now
shipping with...
garuda432@yahoo.com
|
05-21-2005 02:53 AM
DA Morgan | 1 | 58 |
| | | Hello,
If I do :
(select 0, c.*
from table1 c
minus
select distinct 0, a.*
from table1 a,table2 b
where ... )
Christian
|
05-21-2005 02:48 AM
Christian | 4 | 107 |
| | | I am running Oracle Application Server 10g, and I tried to debug some
existing Java Bean files. so, I used "System.out.print" to debug, but...
Zean Smith
|
05-20-2005 09:13 PM
HansF | 4 | 136 |
| | | How can I rewrite the syntax for obtaining colC so that I still only
get the record that was most recently added, but I dont have to query
tabB...
brett.birschbach@cellcom.com
|
05-20-2005 03:31 PM
Anurag Varma | 1 | 86 |
| | | Hello,
I'm new in dynamic SQL query and I have a problem need help.
For example: I have a SQL query like this:
select hw.family,hw.id where...
leileili@hotmail.com
|
05-20-2005 03:15 PM
leileili@hotmail.com | 10 | 107 |
| | | OS: SunOS 5.8 Generic_117350-07 sun4u sparc SUNW,Ultra-Enterprise
Oracle 9i
This is probably obvious but I just have an uneasy feeling about it.
I...
luke_airig@hotmail.com
|
05-20-2005 02:02 PM
Ed Prochak | 1 | 79 |
| | | The following 2 queries are different only w/ or w/o "as 'test'".
Oracle server and client info:
SQL*Plus: Release 9.2.0.1.0 - Production on Fri May...
web_poster03@yahoo.com
|
05-20-2005 11:53 AM
Barbara Boehmer | 1 | 76 |
| | | I need to query (read, write, drop table, ecc..) an Oracle DB from a
handheld device (pocket pc 2002) using an internet connection.
How can i do...
Andrea
|
05-19-2005 07:10 PM
oradba | 1 | 63 |
| | | Hi All,
We have a legacy OCI application using OCI 7.x. recently we converted
it to a multi threaded application with one connection per thread.
To...
Robo-SerialKILLA
|
05-19-2005 05:49 PM
Robo-SerialKILLA | 0 | 62 |
| | | My solution to calculating the number of business days using Oracle 8i
is to create a table with holidays and run some kind of calculation
like...
bbcrock@gmail.com
|
05-19-2005 03:42 PM
Gerard H. Pille | 1 | 87 |
