Hi I have an confused problem
i.e. identify non-system and sys tables that have out of date
statistics and build a script to update the statics for the table that
were identifued.

hi friends,
if anyone intrested in getting oracle 8i,9i or 10g certification
without exams.....then contact me
at vinay_vue_prometric@yahoo.com

I have implemented a function similar to
http://www.databasejournal.com/features/oracle/article.php/2222781
(thanks James)
I need to return some nvarchar2

Many of our esteemed MNC clients are looking out for Oracle
professionals with multiple positions opening. Please go through the
list below and forward your updated word document CV if any of the
profile matches your requirement. Please email your CVs to

Hai every body,
please tell me how to find the list of employees who are getting top 5
salaries in a table.....

Hi, is there an easy way to create a role which has select privledges
to any table within a schema?
Thanks,
- charles

Does anybody know where to download any of these Oracle installations:
8.1.5, 8.1.6, 8.1.7? Windows/Linux versions, doesn't matter.
I can't find them at Oracle website.
Thanks in advance.

is there a way to retrieve floats between 0 and 1 with an 0 before the
decimal point, e.g. .12 -> 0.12? But a value like 1234.34345 shold be
displayed as is.
Actually a solution which influcences any statements without changing

Hi : am working on OEM Oracle 9.2.0.1 with around 40 databases.
Suddenly My OEM lost all the databases and now am not able to add any
databases into OEM. Its not giving any erros and all the databases
which was connected to network are gone.

  I am Trying to use Bind Variables using ODP.NET and calculate the
performance
The Scenario at my end is:
1. Win Form application that creates Sql statements to be executed.

We have a vendor/customer induced problem. Oracle versions only change
by...... well they don't.
A Windows 2003 server running SQL Server 2000 "needs" to connect to an
Oracle 7.3.4.5.0 instance.

Hi, are there any websites that offers free software projects with
source code preferabely made for data bases( that may be oracle,sql
server 2000, mysql... If any plz send me links of the websites who
offers the same.. It will be grately helpful for me... it will be

Gentlemen,
Here is another bug (in my code, I mean...) I can't get rid off. I try
to read a DATA column with the following code :
-------------------------------------------------------------------------------------

I am having a strange problem with a 10g server:
create table tt1 (i char(1));
create table tt2 (i char(1 char));
create table tt3 (i varchar2(1));

Given an interval, how can I identify the first and last dates/times
of it?
I had a look at the doc but there isn't much there for this.
Lots of Greetings1