I am trying to spool data to a file and it is adding left spaces but i want it to start from first character.
This is in .sql file:
---------------------
SET NEWPAGE 0
SET SPACE 0
SET LINE...
http://www.experts-exchange.com/Database/Oracle/Q_23073307.html
Zones:
OracleDate Answered: 01/10/2008 Rating: 8.6 Views: 4
Hi experts
I have an Oracle question related to a select. The main part of it is bellow:
contains (ad.Title, '?sch%' WITHIN ADR_Name);
The '?sch%' can be retrieved in uppercase. How can ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23570349.html
I'm using Personal Oracle 7.3.x.x which installed its 20MB sample database with all of the default value. I would like to know if is it possible, and how to create new tablespace(s), new named dat...
http://www.experts-exchange.com/Database/Oracle/Q_10021844.html
Zones:
OracleDate Answered: 08/31/1997 Rating: 6.4 Views: 0
Does anybody know where to find detailed information for using Oracle OLE controls (for example Oracle Treeview ControlV1.0)?
Or has anybody used any OLE2 controls in Forms 4.5 and could share his...
http://www.experts-exchange.com/Database/Oracle/Q_10026479.html
Zones:
OracleDate Answered: 12/17/1997 Rating: 6.6 Views: 44
Which is the number that identifies uniquely an Oracle Session?
How can an user know it?
I know the session id SID and SERIAL# on table V$SESSION.
This two attributes are necessary to KILL a sessi...
http://www.experts-exchange.com/Database/Oracle/Q_10027896.html
Zones:
OracleDate Answered: 11/07/1997 Rating: 8.2 Views: 0
This should be easy, nevertheless, I am having difficulties:
I have recently downloaded and installed a trial version of Personal Oracle Lite on my machine at home. THe install went ok, and I can...
http://www.experts-exchange.com/Database/Oracle/Q_10037000.html
Zones:
OracleDate Answered: 01/29/1998 Rating: 6.8 Views: 0
Some how all the files in my ORACLE_HOME got 777 file permissions. I was wondering if there is a way I can fix these permissions instead of re-installing Oracle.
Thanks,
Kittu.
http://www.experts-exchange.com/Database/Oracle/Q_10038772.html
Zones:
OracleDate Answered: 02/18/1998 Rating: 7.8 Views: 0
I have a program that inserts data in a remote Oracle database. I would like the program to only insert data when the remote Oracle database is up. How do I check the status of a remote Oracle da...
http://www.experts-exchange.com/Database/Oracle/Q_10045580.html
Zones:
OracleDate Answered: 04/09/1998 Rating: 6.6 Views: 0
Hi there, how do I completely remove a previous installation of Oracle 7.3.x on Solaris, so that I can
do a clean re-install, with the existing data. Thanks...
http://www.experts-exchange.com/Database/Oracle/Q_10047031.html
Zones:
OracleDate Answered: 04/14/1998 Rating: 8.2 Views: 0
i am looking for introductory books on how to make oracle talk to hardware devices, such as storage devices/equipments, by using c programming. i am new to this and is it right that this question m...
http://www.experts-exchange.com/Database/Oracle/Q_10049266.html
Zones:
OracleDate Answered: 04/23/1998 Rating: 7.4 Views: 0
