Is there an easy way for somebody connected to an Oracle instance running on a host somewhere to determine 1) the version of Oracle that it's running under and 2) the default character encodin...
I AM RUNNING THIS IN TOAD FOR ORACLE, THE DATA IS STORED LIKE 1/1/1999
SELECT * FROM CLASS WHERE CLASS_DATE BETWEEN BETWEEN '1/2/1999' AND '12/31/1999'
ERROR:INVALID MONTH
I TRIED T...
Hello,
I have installed Oracle 9i and now I'm installing its patch. I have to connect to sql*plus as sysdba, but I don't know its password. When I installed Oracle, I remember to set up passw...
I use a for-loop in a pl/sql script like:
for rec in (select a,b,c from x) loop begin <script> end; end loop;
If have catched an exeption and want to do "continue" just to skip the curre...
I am trying to run a Pl/Sql script(Oracle 9i on Windows) which opens and writes a file using UTL_file but the UTL_File.FOpen gives error:
ORA-29280: invalid directory path
The init.ora da...
Hello All,
We are getiing this ORA error when we are performing a high volume task(search, sort, grouping, insertion of more than 4 million records). We are creating LMT. The current defaul...
How do I convert a field of LONG datatype to one of a VARCHAR2 datatype?
I have a table in an oracle database that tracks table constraints in an application that I have written. I wish to...
I have a unix shell script (test.sh) that activates sqlplus to run a sql script (test.sql). The sql script spools the output to test.dat. I do not want test.dat to contain query that is echo...
Hi All,
I have a database in oracle HR i want to know
1.How can i take dump of this database complete.
2.How can i take dump of two tables in it.
3.How can i create another database sa...
I have a W2K server latest SP and update, on which an Oracle 9.2.0.1 server/client is installed
The Oracle server runs several databases since months, with local server application installed ...
Hi,
I am working with SQL plus on oracle database. When I try to insert a string that contains escape character like '&', it prompts for asking input for variable substitution as below:
...
I am using sqlloader with direct=TRUE , i am trying to insert 2 million records in to table through flat files. This flat files some times may have duplicated records also.
(using Direct Path...
Hi,
I have created a table called "myTable" with a column called CURRENT_DATE and it's data type is "DATE". When I programatically update my table, I also want to place a timestamp or syste...
Hello,
I have a strange problem with my client connection to an oracle database. I can connect to the database fine and work with the database ok, but if I leave the connection alone then ...
Is there a way to lock a table in Oracle 9/10 so that when another process tries to access/lock the table, the current lock tells the new process to not wait for the lock to lift? I need to r...
Hello to all,
My problem is about calling a pl/sql procedure from inside another, in Oracle 9i.
Requirements are:
- pass some parameters and get others
- code in the parent proced...
Hello all,
I need to export a portion of a series of Oracle 9i tables to a csv file. I have the select statement to get all the data I want, but I don't know how to get it into csv format....
Here is an example of the tnsname.ora. I have label the line number on the side.
In Line1, what does the Tasmin.world mean?
In Line 10, what is SID used for?
When I do a sqlplus user/...
I need a good example on using RAISE in exception in Oracle. Will RAISE stop the program run and exit? Thanks.
Hi,
I need to check if a table exisits and drop it if it does (without errors) so a DROP and error if it doesn't exist won't work.
Any ideas?
DROP TABLE IF EXITS <tablename>;
(I kn...
Hello,
I have a simple stored procedure that has an 1 output and 1 input parameter. I get an error when I try to execute the proc from SQL editor in TOAD. It has to do with the ouput param...
I am starting EM console from browser at http://bobik:5500/em
but it requested Database Credentials and Host Credentials
Where can I get Host Credentials?
I've installed DB on computer wi...
Why this query generates an error in oracle
Select top 10 from table
Thanks!
I need the sql syntax to drop a schema from my oracle 10g database
I want to update a date that has the time appended to the end like this -
10/08/2007 17:23:16
What is the syntax if I wanted to update it to say
11/08/2007 15:22:10
Something like
update ...
