Can I get a select(*) statement to give back only the fields that have
data?
(I'm running this is SQL plus worksheet, on server 9, client 10)
Thanks,

Thanks for your previous help. Now I am facing another problem to
writing the script like...
----------------------------------------------
SELECT ID into FAIRID  FROM RESERVATIONMASTER;

I am new to PLSQL.  Is this a good programming practice to test if there is
0, 1 or > 1 rows returned from a SELECT INTO:
DECLARE
   v_number number;

I've never worked with Oracle before and I am definitely not a DBA, but
I've been tasked with generating some mrtg reports from snmp data from
one of our Oracle DB servers. The server is a Sun Sparc 250, Solaris
5.9 (9), and I'm not 100% sure of the Oracle version. If you give me a

I have an insert statement in this format.
INSERT  /*+ APPEND */ INTO <insert_into_table>
                        (column1,
column2,

ver 9.2.0.5
I think I can overload a procedure but the variable list could be between 1
and a couple 100, so that's not a good option.
I am thinking about bringing the list in as a string then parsing it. and

I would like to separate the people in charge of the Oracle
installation from the people in charge of the Database installation.
Typicaly, separate the job of a Unix administrator and a DBA.
I oft read in the documentation the user oracle as the user of the

I am trying to write a script as a menu from SQLPLUS screen.
=====================Code
-------1. Activity1
-------2. Activity2

in Oracle 9i
Ouput example :
Dept No : 10 Accounting     No of Employees : 2

I am handling a complex query and ultimately the problem boils down to
this.
I have the data in the format
Col1      Col2

I have a user on prod db..which has got no create privs...
But the user can alter the objects in its own schema.
Is there any way by which i can stop it.
regards

When I Use Windows(xp/2003) service to start OracleStartORCL
(Oracle Database Server 7.3.4.x service starter)
I have recently "Oracle Service Controller Error"!
-----------------------------------------------------------------------

I want to break the the follwoing string  variable into two strings.
eg; str="abcd\wxyz"
   into
   str1="abcd"

when i want connect me in my BD with a JSP (with this simple code),
this exception is throw.
Thank's for ur help
Mathieu

I am using Oracle 9.2.0.1 on HP Intel Servers running SuSE 9.0.
My Oracle SW is OWNED by USER: LARRY and GROUP:ELLISON
I have 2 Instances running on it: CAL (caluser as its main user) and
BOM (bomuser as its main user)