| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi, I already included in GROUP BY clause all SELECT expressions that
are not group function arguments.
And it runs OK in Oracle 8, but when I change...
MM
|
05-24-2005 01:59 AM
Primo¾ Govekar  | 5 | 383 |
 | | i have had to install 8.1.7 on Redhat Enteprise 3. That was a feat by
itself but i finally got it to run the listener and the instance, i have
a...
Bob Marley
|
05-20-2005 08:37 AM
Paul | 1 | 139 |
| | | Hello
I am trying to build a system where I can full-text index documents with
UTF8 or UTF16 data using Oracle Text. I am doing the filtering in...
Server Applications
|
05-19-2005 04:00 AM
Frank van Bortel | 1 | 142 |
| | | Hi All,
I tried evething: but no help,
I'm connecting from my home trough 1.5 MB ADSL Line to Oracle Server
and getting ORA-12170
Oracle...
Zahi Savion
|
05-17-2005 05:38 AM
Zahi Savion | 0 | 178 |
| | | Hello users!
I have to prepare a paper about ERDish programming language. Unfortunately I
can't find any useful info about it.
All I know it is...
Slawek Z
|
05-15-2005 04:11 PM
Slawek Z | 0 | 103 |
| | | We have some performance Problems due to heavy load in an oracle database
10g.
Our Server is Hewlett Packard Proliant ML380 OS: SuSE Linux...
max
|
05-12-2005 11:14 AM
IANAL_VISTA | 1 | 91 |
| | | This is probably easy and I'm missing it because I'm a little
sleep-deprived this month, but:
given the following table 'test':
name group ...
jared
|
05-10-2005 05:21 AM
Tomislav Kokoska | 3 | 93 |
| | | What is the best way to speed up query looks like:
SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5
= 5
cardinality of...
Tomislav Kokoska
|
05-10-2005 05:13 AM
Tomislav Kokoska | 0 | 99 |
| | | Søren Alexandersen wrote:
That's basically what export/import does for you. It moves all the
data, including tables, triggers, views, constraints,...
Walt
|
05-09-2005 05:41 PM
Walt | 0 | 80 |
| | | Hello guys,
I would like my app to generate and execute cross platform (sybase and
oracle) multi-statement SQL in the form:
(situation A)
SQL +=...
SerGioGio
|
05-08-2005 08:22 AM
SerGioGio | 0 | 88 |
| | | hello..
with oracle 7.3.4.4 and with remote_login_passwordfile=NONE,
can a user be granted the SYSDBA system privilege?
Or does granting the SYSDBA...
Luis Correia
|
05-06-2005 04:44 PM
Luis Correia | 0 | 122 |
| | | To all,
How do you stop the debugger when you encounter an error ?
I have tried using STEP OUT (CTRL T) and BREAK (SHIFT+ESC) and...
Rick Silvers
|
05-04-2005 02:57 PM
Rick Silvers | 0 | 97 |
| | | We have a network with 4 computers on it. One of them is running the
database and the other 3 are clients. I can ping the server, but not...
berj
|
04-26-2005 06:06 AM
Frank van Bortel | 3 | 101 |
| | | Hello!
I have Oracle 10g using AL32UTF8 as internal charset.
I have a documents table where uploaded files (I'm using modplsql
web-gateway (release...
Michael Postmann
|
04-25-2005 10:28 AM
Michael Postmann | 0 | 138 |
| | | You can't ...
What you might try is:
desc tabe1
This will list the columns in that table.
You can select what you want to pull from that way.
Steve Kirby
|
04-21-2005 09:20 PM
Steve Kirby | 0 | 76 |
| | | Hi all,
We are doing an exercise of migrating an application (developed in
Informix 4gl) from Informix to Oracle database.
Before doing actual...
Girish
|
04-19-2005 02:49 AM
Joe Yong | 3 | 108 |
| | | Hello All,
I am new to PL/SQL, come from a COBOL/DB2/iSeries world. I have a question
about Packages, Procedures.
I want to create a Package, that...
Rick Silvers
|
04-17-2005 09:56 PM
GreyBeard | 1 | 96 |
| | | Hello All,
I am new to PL/SQL, come from a COBOL/DB2/iSeries world. I have a question
about Packages, Procedures.
I want to create a Package, that...
Rick Silvers
|
04-17-2005 06:33 PM
Rick Silvers | 0 | 79 |
| | | Hello All,
I am new to PL/SQL, come from a COBOL/DB2/iSeries world. I have a question
about Packages, Procedures.
I want to create a Package, that...
Rick Silvers
|
04-17-2005 06:27 PM
Rick Silvers | 0 | 65 |
| | | Hello all,
I have a question about the Oracle 10g thin JDBC driver. I was
wondering if anyone knows what the default prefetch size is (in number
of...
nospam
|
04-16-2005 02:59 PM
nospam | 2 | 81 |
| | | Hi -
I've created the following SuperType object in Oracle :
CREATE OR REPLACE TYPE CT_CALC_UT as object (
ct_plant_nm varchar2(50),
ct_value...
daviscomp20
|
04-16-2005 10:22 AM
Frank van Bortel | 1 | 83 |
| | | Can anyone help with a mysterious problem that has arisen since 'upgrading'
from 8 to 9.2.0.4?
The situation is this:
Queries that worked fine...
SteveS
|
04-16-2005 08:08 AM
SteveS | 0 | 83 |
| | | Hello together,
I'am a oracle databse administrator and i want to write a short procedure
in PL/SQL. My programming experience is ohther programming...
T.Kindermann
|
04-14-2005 02:26 AM
T.Kindermann | 0 | 75 |
| | | Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user
who successfully connects to it with her Oracle 7.3 client. I have...
Tig
|
04-12-2005 05:54 PM
KMART | 2 | 115 |
| | | Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user
who successfully connects to it with her Oracle 7.3 client. I have...
Tig
|
04-11-2005 03:03 AM
Tig | 3 | 200 |
| | | I'm using Oracle database.
It is true that I can't use update when I have group by ?
For example I tried with:
update (select t1.ID,...
MM
|
04-08-2005 08:59 AM
MM | 0 | 94 |
| | | Hi - I'm updating an Oracle table with an empty string and getting the
error:
An unhandled exception of type 'System.Exception' occurred...
arvee
|
04-08-2005 07:46 AM
Frank van Bortel | 1 | 157 |
| | | Dear all,
We use TCP/IP for our Oracle networking to the database server but I see
2 formats for specifying the definition of a connection string of...
Miori
|
04-08-2005 06:49 AM
Artur Karazniewicz | 1 | 80 |
| | | Hi,
The following does not return result:
with free_space_by_tablespace as
( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024...
web_poster03@yahoo.com
|
04-06-2005 10:11 AM
web_poster03@yahoo.com | 2 | 125 |
| | | Hi All,
I am currently handling a J2EE application with the Application server
as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0.
The client wants...
Anshul Seth
|
04-06-2005 06:50 AM
dinko | 2 | 67 |
| | | Hi All
Nice to be in this Forum.
I have questions to ask on UTL_FILE :roll:
Let me explain the concept
1.When the net is down the user will take the...
Prasanna
|
04-03-2005 12:53 PM
Mark C. Stock | 2 | 138 |
| | | Hi,
I'm using dreamweaver to do some asp development with an oracle
database. I'm having trouble seeing tables that are in my own schema.
I can see...
samuelgreene@gmail.com
|
03-30-2005 06:44 PM
samuelgreene@gmail.com | 0 | 84 |
| | | Hi
I have a very complex sql query and a explain plan. I found there is a
full table scan in ID=9
9 8 TABLE ACCESS (FULL) OF...
Marcus
|
03-30-2005 11:07 AM
GreyBeard | 2 | 78 |
| | | Trying to convert timestamp data to date data (without the time in
hours/mins/secs), does only seem to work with TO_DATE(mydate; 'yyyymmdd').
But I...
Bob
|
03-29-2005 06:17 PM
Walt | 1 | 218 |
| | | Hi,
I'm trying to setup a JDBCPDS (Pluggable Data Source) to a MySQL
database so that I can use Oracle Reports to report against that
database.
Has...
Stephen Walsh
|
03-29-2005 12:13 AM
Stephen Walsh | 0 | 106 |
| | | Hi,
I have Oracle9i on HP-UX. I am using raw partitions for Oracle. If I
change db_block_size, will it affect performance or scalability...
Tejaswini
|
03-28-2005 11:53 PM
Tejaswini | 0 | 85 |
| | | I want to delete just parts of tables, so I can't use 'TRUNCATE'. As I
want to delete about millions of lines, I need a very big rollback
segment....
Gert Schumann
|
03-24-2005 04:34 PM
Mark.Powell@eds.com | 2 | 100 |
| | | Hi all-
I have a windows service (like a Unix daemon) that loads flat files
into an 8.1.7 database. I use Oracle Objects for this, but it takes...
tachoknight@gmail.com
|
03-23-2005 08:52 PM
Jim Kennedy | 1 | 87 |
| | | Hy!
We got the same datamodell on Solaris and on WindowsXP. But there is a mojor
difference in the Performance. The database on Windows is much...
Putz Ronald
|
03-23-2005 04:21 AM
Sameer | 1 | 90 |
| | | People periodically post questions to the comp.databases.oracle newsgroup
and may wonder why there are very few responses.
Basically,...
GreyBeard
|
03-22-2005 10:23 AM
GreyBeard | 0 | 76 |
| | | People periodically post questions to the comp.databases.oracle newsgroup
and may wonder why there are very few responses.
Basically,...
GreyBeard
|
03-22-2005 10:22 AM
GreyBeard | 0 | 81 |
| | | I have a particular problem:
I am working at a client site where they have the following oracle
system:
Oracle7 Server Release 7.3.3.0.0 -...
Kal
|
03-22-2005 09:54 AM
Kal | 0 | 91 |
| | | Hi all.
Our company have a number of sites where I am required to work. When
at my "home" site Forms Builder works OK. When at another site,...
ernest.dale@timet.com
|
03-22-2005 08:15 AM
ernest.dale@timet.com | 0 | 59 |
| | | Hi,
After an insert using nextval I try:
SELECT * FROM tblClients WHERE fldclient_id = (SELECT
client_id_seq.currval from Dual)
and get:
james.kennedy@students.plymouth.ac.uk
|
03-21-2005 09:40 AM
jfk303 | 2 | 315 |
| | | I have a view that contains the following SQL1 and it takes about 500ms
to run with Explain Plan EXP1. However, if I add an order by
clause(e.g....
Scott
|
03-18-2005 10:50 AM
Mark.Powell@eds.com | 1 | 94 |
| | | I just realized that I meant to say "How to do this without a
correlated subquery". Sorry, folks
jared
|
03-17-2005 11:15 AM
jared | 2 | 76 |
| | | I have a table with following...
longhorntx
|
03-17-2005 09:49 AM
longhorntx | 0 | 127 |
| | | I have a table with following...
longhorntx
|
03-17-2005 09:49 AM
longhorntx | 0 | 78 |
| | | Rishka Mar 17, 5:40 am show options
Newsgroups: comp.databases.oracle.tools
From: "Rishka" <ris... (AT) webmail (DOT) co.za> - Find messages...
rishka@webmail.co.za
|
03-17-2005 08:57 AM
GreyBeard | 1 | 94 |
| | | Hi,
I'm working for the backup application. Currently we need to support
Oracle8i backups for our application.
We are having OCI* calls from our...
Nagi
|
03-17-2005 12:48 AM
Nagi | 0 | 69 |
