If I have table A , It Contain 50 Columns and 1000 rows.In
between 50 columns,
some null columns also there.i want only show the output in not null
columns.

Looking for a consultant with solid experience in application and
database security for a project in the GTA.
CONTACT
------------------------------­---------------------

A have a query that involves 3 tables:
individuals (id(pk),personalid, i.firstname, i.surname)
recruitments (r_id(pk),recruitmentstatus, statusdate, contractstatus,
id(fk))

After devoting a great deal of effort to tune a particular batch process
some physical changes were made to our environment.  The result is that our
batch job now takes twice the amount of time to execute (7 hours instead of
3.5!)..

Each,
SELECT 'ABC'||to_char(01234567, '09999999') FROM DUAL;
Returns
ABC 01234567

hey all,
I'm trying to connect to an oracle 9.2 version as sysdba, using the
string
sqlplus 'sys/.....@INSTANCE as sysdba'

All,
DB is Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod.  JDBC driver
is the newest driver for Ora 10.2.
I got a strange error that I could find no explanation of.

I would like a user to be able to select on another schema's package
body
/ it can only see the spec at the moment ..any ideas
cheers

I am doing some testing with Oracle 10gAS Rel. 2 on Solaris 9.  I'm
doing this testing on a cobbled together used Sun Blade, and this is
just for doing some installation testing.  This machine has about 1.1GB
of memory right now.

my currently database is 50 gb (win nt) and the file location is :
dbf in drive g and f
(indexes seperate from tables and i know it's not contribute to
performance.

I have oracle 9.2.0.7 running on windows 2003 server.
The init parameter:
hash_area_size 4M
sort_area_size 2M

I have a question regarding what will be the efficient way to export /
import to different version of database.
Here is the details:
Source database version 8.1.7.4

I have a question caused by data grow.
As the db data grows, the tables become bigger, this kind of grown will
affect the system. So how to handle this kind of increase? To build
warehouse, or is there other methods to handle it?

Here's the error I'm getting in the unattended.
The problem is the patch.rsp file does have the Home names defined.
I've put it under the error message.
error message here =============================

I have a report and i have to change in such a way that, if user pass a
parmeter like
customer name or margin or percent, then depending upon that he have to
order by.