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 Grade: A Views: 60
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 Grade: C 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 Grade: C 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 Grade: A Views: 0
I have two tables like call with call_no and call_state with a serial no as key. Through my java program i am inserting into call and then to call_state. I am working with personal Oracle. Now, wh...
http://www.experts-exchange.com/Database/Oracle/Q_10035431.html
Zones:
OracleDate Answered: 01/13/1998 Grade: D 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 Grade: A Views: 4
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 Grade: A 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 Grade: C 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 Grade: A Views: 0
