2010-02-25 18:25:38 : Gros plan sur Visual TOM
comp.databases.oracle Google Group
Voir le site comp.databases.oracle Google Group
- Free ad-hoc reporting tools
- I am in need of an ad-hoc reporting tool for generating reports from a
database on an SQL server. Crystal Reports has all of the
functionality I need but the price tag is too high.
Are there any free tools out there like crystal (...)
3 June 2008
- why to migrate from infromix to oracle
- Hi all,
We are doing an exercise of migrating an application (developed in
Informix 4gl) from Informix to Oracle database.
Before doing actual migration, we would like to know some of the key
advantages of Oracle over Informix. If there are any examples of any
company getting benefits (...)
3 June 2008
- Oracle 7.3 v 9.2 client connection problems
- 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 an
Oracle 9.2 client installed on my machine.
I had her send me her tnsnames.ora from her PC. The entry I wanted was
as follows (some (...)
3 June 2008
- ORA 7.3 v 9.2 client conneection problems
- 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 an
Oracle 9.2 client installed on my machine.
I had her send me her tnsnames.ora from her PC. The entry I wanted was
as follows (some (...)
3 June 2008
- "No size set for variable length data" Oracle update error with empty string in .NET
- Hi - I'm updating an Oracle table with an empty string and getting the
error:
An unhandled exception of type 'System.Exception' occurred in
system.data.dll
Additional information: Parameter 'p1': No size set for variable length data
type: String.
The column is (...)
3 June 2008
- with clause for subquery factoring
- Hi,
The following does not return result:
with free_space_by_tablespace as
( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name
select * from free_space_by_tablespace (...)
3 June 2008
- Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
- "The unforgiveable sins this earth must confront and overcome are
Nationalism, capitalism, and hoarding. The idea of every nation
should be forgot, price should be struck from the commons, and
princes should be seen for the devils they are. The sins include
our church, secret societies, (...)
3 June 2008
- DW + Oracle: see tbls w/ recordset but not insert
- 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 several other tables in other schemas, but not my own - this
is in the dreamweaver table browser. If I do an 'advanced' (...)
3 June 2008
- Rules Engine
- I am looking for a rules engine, based on Oracle, that is as generic as
possible. I don't even know if such a beast exists.
The application area is saturated by nested ifs, else and lookup in
various tables. I want to try and consolidate all of that and hope that
there is a more (...)
3 June 2008
- Oracle Reports JDBCPDS
- 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 anyone successfully setup a JDBCPDS to MySQL via Oracle Reports?
If you have, can you send me the details of what you did.
I've (...)
3 June 2008
- Changing db_block_size
- 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 of
Oracle?
Thanks,
Tejaswini
3 June 2008
- 实现财务自由与 在家工作的梦想 ? Work from Ho me and Get Financial Freedom
- 实现财务自由与在家工作的梦想? Work from Home and Get Financial Freedom
我们了解忙碌的您，不会愿意再牺牲与
3 June 2008
- The Greatest News Ever!
- [link] The Greatest News Ever!
3 June 2008
- Great News Blog!
- [link] Great News Blog!
3 June 2008
- Which Operation of the Complex SQL is doing full table scan
- 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 'F_LOTTXNHIST'
(Cost=84573 Card=185892 Bytes=7063896)
How can I correlate which part of the SQL statement is running on full
table scan. Please see (...)
3 June 2008
- Fast bulk load with API?
- 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 a
very long time, especially with CLOBs to do > 10,000 records. I would
use SQL Loader, but because this is a service, I can't spawn (...)
3 June 2008
- Is it possible to delete parts of a table without using rollback??
- 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. The best way would be to delete without using rollback
because the delete really takes a lot of time copying all data into
the (...)
3 June 2008
- Help needed for Database Replication
- 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 to setup a test environment, and as the application
is mission-critical, it would be of great help if the production and
test DB are in (...)
3 June 2008
- Performance difference between Windows and Solaris 10g
- 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 faster than
the one on Solaris although the Solaris machine is a dual processor. The
initialization parameters are also correct, I hope so (...)
3 June 2008
- Why you don't usually get answers here ...
- People periodically post questions to the comp.databases.oracle newsgroup
and may wonder why there are very few responses.
Basically, comp.databases.oracle is NOT a newsgroup anymore, but rather
just a pointer or place holder to the correct newsgroups. Several years
ago, the group (...)
3 June 2008
- SQL - Select and filtering whereby a date is not null.
- 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 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
I am trying to select Person_id's filtering by where a date is not
null see below: (...)
3 June 2008
- Forms Builder speed
- 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, it
slows to a crawl due to a screen redraw every time I do anything, even
just click on a Record Group or Canvass. Every button redraws. If on
a (...)
3 June 2008
- (",) Do You Want To Know For Sure You Are Going To Heaven?
- [link] Click On Link
3 June 2008
- Sequence Error ORA-02287
- Hi,
After an insert using nextval I try:
SELECT * FROM tblClients WHERE fldclient_id = (SELECT
client_id_seq.currval from Dual)
and get:
java.sql.SQLException: ORA-02287: sequence number not allowed here
I've read lots on sequence's etc and I can't see why I cant get the (...)
3 June 2008
- Order By Performance Problem on View
- 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. select * from view1 order by ID desc), it will then take
about 3 mins to return. The explain plan for the query with the order
by clause is as (...)
3 June 2008
- How to build database to support user-specified entities and attributes?
- I have a database that tracks players for children's sports clubs. I have
included representative DDL for this database at the end of this post.
A single instance of this database supports multiple clubs. I would like to
add support for letting each club define and store custom (...)
3 June 2008
- Pivot query in oracle- Please help!!
- I have a table with following values
City STATE COLOR REGION
city1 Texas White SW
city2 Texas Gray SW
city3 Texas Gray SW
city4 Nevada Gray PAC
c5 Texas Yellow SW
c6 Florida Yellow SE
c7 Missouri Orange W
c8 Texas Orange SW
I am trying to create a report which looks like: (...)
3 June 2008
- Read Text file into Oracle Reports
- Rishka Mar 17, 5:40 am show options
Newsgroups: comp.databases.oracle.tools
Local: Thurs, Mar 17 2005 5:40 am
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hello
I a newbie to Oracle Reports, our requirement is to write a (...)
3 June 2008
- OCI library for Oracle 8.1.7.4.0 on OpenVMS
- 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 code.
We are using Recovery Manager: Release 8.1.7.4.0 - Production version
in our system. We have installed the oracle 81740 patch. (...)
3 June 2008
- Follow up to previous post
- I just realized that I meant to say "How to do this without a
correlated subquery". Sorry, folks
3 June 2008
- SQL Query
- 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 salary
----- ----------- ------
unique medium cardinality
How can I select the name(s) for each group that have the highest (...)
3 June 2008
- AVG and SUM in subquery return wrong values
- Hi
I have the following query aggregating values over a column and
creating the sum over another column. Here everything works out fine.
SELECT c.timestamp, AVG(c.response) as response, SUM(c.quantity) as
quantity, c.trans
FROM
tbl_repo01_dest c
GROUP BY c.trans, c.timestamp
No (...)
3 June 2008
- Invalid attribute/identifier error
- HI ,
My application runs fine when I am using SQL Server 2000 as its db,
but it gives a message "Invalid attribute/identifier" error when the
db is Oracle .
Any help in this matter would be appreciated .
Thanks , (...)
3 June 2008
- XML joining Nested resultsets
- HI, I have an XMLType column that has the following XML structure:
3 June 2008
- How to build database to support user-specified attributes?
- I have a database that tracks players for children's sports clubs. I have
included representative DDL for this database at the end of this post.
A single instance of this database supports multiple clubs. I would like to
add support for letting each club define and store custom (...)
3 June 2008
- port/protocol for sqlplus connectivity
- Hello, We were having trouble connecting to Oracle 8.1.7 running on a
Solaris machine. We assumed this was because a firewall blocked access
to port 1521. When we requested that our IT group open up that port,
we were asked, which protocol, UDP or TCP?
Does protocol matter? What (...)
3 June 2008
- Problems: Oracle 9 Installation and Windows XP SP2
- Hello,
i have a big problems, to install oracle 9i v9.2 Server to my "Windows
XP" with Service Pack 2 and all security and other updates from
Microsoft.
The "Universall Installer" (Standard Edition is Selected and only
Software is Selected) throws an exception, during the installation (...)
3 June 2008
- Oracle 9 Installation Problems under Windows XP SP2
- Hello,
i have a big problems, to install oracle 9i v9.2 Server to my "Windows
XP" with Service Pack 2 and all security and other updates from
Microsoft.
The "Universall Installer" (Standard Edition is Selected and only
Software is Selected) throws an exception, during the installation (...)
3 June 2008
- install oracle 8.1.7 and developer 6i under same oracle home.
- Hello EveryBody,
I had installed Oracle client 8.1.7. Now I want to install Developer
6i under the Oracle 8.1.7 home. When I tried to install this , it was
giving message
"the location specified, D:\ is already
in use as an Oracle Home for 'Oracle 816 Production'. It cannot be (...)
3 June 2008
- Installing Oracle on Linux Redhat
- I was trying to install Oracle on a Linux box with Redhat and got an
error message saying the OS had to be Redhat 2.1 or 3.0 (plus some other
non-Redhat versions). Does anyone know what I have to do bypass this
since I am clearly using a higher version of (...)
3 June 2008
- Converting a bare number to an interval and back
- Salve.
I have an application in which I would like to convert a number of
seconds into an INTERVAL DAY TO SECOND value and, later, back to a
number of seconds. For reasons relating to inter-database portability,
I'd like to do this in a stored function, not in the database client (...)
3 June 2008
- ORA-29531 - And the method is declared both PUBLIC and STATIC
- Could someone be of assistance and show me the problem with the
following code? I have researched Metalink regarding ORA-29531, and the
most common cause of this error is the failure to declare the method
"public" and "static". I have done both here and still have the same
error:
Java (...)
3 June 2008
- External SQL functions exported by DLLs
- We have a few rather advanced calculation routines
developed in C++. Currently we are using a Sybase ASA
database for our app. and these routines are accessible
by so called external functions exported by a DLL
(dynamic link library) that we wrote in C++. Sybase
supports this quite (...)
3 June 2008
- Oracle Discoverer Newbie...
- Hi !
I am trying to learn how to use Oracle Discoverer.
I have worked with databases, like Oracle for several years, but i am
new to Discoverer.
Does anybody know a place to download an "Oracle Discoverer for
Dummies ...", or some other good tutorial for a newbie like me.
Regards, (...)
3 June 2008
- How to debug .pc file instead of debug generated .c file?
- Anybody knows if it is possible to use gdb/dbx to debug .pc file instead of
generated .c file?
Thanks
3 June 2008
- PL SQL Cursor beginner
- Hi
I'm beginning with PL SQL and try to learn cursors usage
I get ora 920 with this on line "WHERE WHERE_NORME "
What i'm trying to do is to fetch where conditions stored in a table,
and reuse it in dml order in my cursor.. but I must have missed
somethin ? any pl sql killer (...)
3 June 2008
- Aarrrgh - this is NOT the place to ask!!
- There is again a rash of people asking question in comp.databases.oracle
and these people are likely disappointed at the lack of responses.
Please note that this is not an official news group. Back in the late
90s, the Oracle user community decided to officially split this into
several (...)
3 June 2008
- Flashback over database link
- Hello out there,
this morning I had to get some rows via flashback query. Since my undo
retention is just 3h, the undo segments were already aged out.
But I have a physical standby database that is mounted read only
during daytime for report processing etc.
On this one the old data is (...)
3 June 2008
- how to do dbms_application_info.set_module from JDBC code
- Hi,
I want to use the Oracle dbms_application_module's set_module and
set_action functionality for tracing my calls. However my client uses
JDBC to connect. I can't find how I can make sure the SQL queries done
from JDBC are used with the correct module set.
Has anyone ever (...)
3 June 2008
- Re: Spotlight For Oracle
- The quest help is pretty good as are the drilldowns for each item
dan
3 June 2008
Dossier
Databases
Annonces
A voir sur le net
- Ordonnancement.net
Ordonnancement.net est un forum regroupant une communauté d’acteurs de l’ordonnancement de compétences différentes mais tous réunis par l’utilisation par l’utilisation d’un ordonnanceur.
Cette rubrique reprend les offres déposés sur le site, elles concernent donc exclusivement les métiers de l’ordonnancement.
- Keljob.com
Moteur de recherche d’emploi, job et stage du jeune diplome au cadre experimente. Criteres : region, type de contrat (CDD, CDI, Interim). Conseils pour les professionnels du recrutement (ASP,CV).
- Michael Page
Michael Page, cabinet de conseil en recrutement
- Monster.fr
Offres d’emploi monster.
- DirectEmploi.com
Offres d’emploi Informatique-Telecoms, depot de CV, tests de recrutement, plus de 14 000 annonces
- Apec.fr
30 offres de Cadre - Systèmes, réseaux, data
- ITProfil.com
ITProfil.com - Toutes les dernières offres de missions, offres d’emplois et offres de projets.
- Hays.fr
Jobs from Hays...
- Reseau-Emploi.com
Annuaire de 1100 entreprises et 3000 Offres d’emploi en informatique et électronique.
- Webcible-IT.com (Production)
Listing des offres Exploitation / Production / Maintenance
- Webcible-IT.com (Architecture)
Listing des offres
- Webcible-IT.com (Projets)
Listing des offres Gestion de Projets
- Webcible-IT.com (Ingénierie)
Listing des offres
- PC-infopratique.com
Les dernières offre d’emploi en informatique
- CarriereOnline
Le Blog des fonctions informatiques vous propose : Offres d'emploi, offres de stage et conseils en gestion de carrière dans les Télécommunications, Systèmes réseaux, Support informatique, Multimédia, Internet / NTIC, Ingénieur, Informatique industrielle, Informatique de gestion, Direction informatique, Conseil informatique, Autres fonctions informatique, Audit informatique, Architecte (IT)
- Cadremploi.fr
Ce service est fourni par CADREMPLOI.fr, il est protégé par le droit d’auteur et appartient à CADREMPLOI.fr.
- JobFreelance.org
Emploi Informatique - Offres de mission pour les freelances informatiques
Portail gratuit entièrement dédié aux missions freelance informatique, emploi informatique, recrutement informatique. Espace freelance et espace recruteur sont à la disposition des freelances informatiques recherchant des missions et des entreprises recherchant des compétences. Info pratique pour les indépendants informatiques
- OptionCarriere.com
Offres d’emploi sector : "informatique telecom" - France - Optioncarriere
- Emploirama.com
Dernières offres d’emploi dans l informatique parues sur emploirama.com
- CmonJob.fr
Votre recherche : Emploi Informatique / telecom , voici nos dernieres offres d’emploi sur CmonJob.fr. Emploi Informatique / telecom . Trouvez votre job !
- Jobtech.fr
Jobtech.fr - Le site emploi 100% Technique et Ingénierie. Offres d’emploi de la fonction "Hi-Tech / Informatique / Telecom"
- Orange-business.com
- Elancelot.com
Latest Job News
- Eci-conseils.com
Emploi par Eci-Conseils.com
- fr.emplois.offres
Google Group : Offres d'emplois ou de stages. (Moderated)
- Annuaire RH
Offres d’emploi quotidiennes http://www.annuaire-rh.org
- Freelance-info
- e-tangerine
votre partenaire sourcing
