Hi, I am trying to insert a big text data into clob field but getting ORA-01704: string literal too long Oracle Data Provider for .NET error. Here my code that gives error.. also how to insert...
Hi,
I am preparing the script to monitor 9i SQL statements performance.
I got an issue with sql_text size limitation - varchar2(1000) for all v$ sql views.
I cannot see the entire bod...
I would like to create a stored procedure that reads data from a file and updates records in a database table. Is this possible if so can someone please provide me with some sample code. Thank...
Hi,
Can i use safely "ALTER TABLESPACE tablespace_name COALESCE" to free up unused space in any tablespace ( like ununsed extents). Is there any way to find if a tablespace needs to ...
folks
when i run this statement i get an error
SELECT CASE
WHEN INVOICECOST.GLDEBITACCT LIKE "%^"
THEN 8
ELSE SUBSTR(GLDEBITACCT, LENGTH ( GLDEBITACCT ) -1 ,1)
END DEPT
...
Hello I am trying to put together a sscript to read Oracle's alert log. I found this code on the net it should work but I am getting a SP2-0310: unable to open file "update_alert_log.sql". You...
on an ORACLE database, is there a table that lists all user created PL SQL Functions?
Hello!
I have a column which have time and date in it. assume now() function in VB.
It is like this:
2007/07/28 06:54:41
It have about 10000 records with a column called last which h...
Hi!
I am using the following VBA code in Excel 2000 to get a SQL query result from an Oracle database. At the moment I am writing the query result to the worksheet. Since I want to use the re...
I get the error message "frm- 92050 unable to access server" and then followed by a bunch of java error messages when trying to access an oracle application through my webrowser. I need help u...
how do I get the first name out of a string like this with sql plus in oracle.
DOE-DOE, JOHN-XXXX
JOHN would be the first name.
Hello,
I have a table whose date fields are all declared as NUMBER. For example, the value 14076 is supposed to represent 16-Jul-2008. I'm not sure how this number was created - whether it wa...
Hi,
Currently, I have one problem in my J2EE application. I have one SELECT query that joins up 8-10 tables at a time and it took around 7-10 minutes (we have optimized it...it was 30-40 mi...
What is equivalent of SYSDATE in Sybase?
what is the difference between "file Size" on General table and "Maximum size" on Storage tab on edit datafile screen in OEM tablespaces.
the data file size is set to 4GB and the max size i...
Hi,
Using Oracle 9.2.0.3, I receive the following error : EXP-00056: ORACLE error 4068 encountered
when exporting from Enterprise Manager console...I?ve searched on the web for a solution...
Hi guys -
One of my table columns in an oracle database is a clob datatype and actually contains xml data.
I need to write a query to find out all the rows that contain "$nbsp;" in th...
Hi,
Can someone give the sql queries to use to find the sessions blocking another sessions in Oracle, nothing but blocking locks. Im confused as what is the first thing to find out and t...
How can one analyze the information generated in bdump tracefiles ?
I have an application that is using Access 97 as the interface and using VB and Microsoft ODBC driver to connect to an Oracle database via DNS machine that is in a different location. I 'm l...
i have 50 tables and data in 50 csv files.
can i load data using single control file in sql loader??if so how can i do it
Hi Guys,
I am creating a pl/sql program at the moment to use with Oracle E-Business Suite.
I am wanting to hide certain procedures in this program so that they are only able to be run from w...
Hi,
Im trying to clone a database using RMAN DUPLICATE command. I have gone through the documents and was able to get a basic idea of how to do it. Im still suspicious whether i got the...
I am using SQL*Loader to load files that are in CSV format. I want to set commit points for the load process. How do I tell SQL*Loader to do a COMMIT to the database every 1000 rows inserted?
I am producing two parameters from a webpage (jsp,java) and am sending them to a shell script.
I want to call them in a stored procedure from the shell script as below:
s...
