Below I have attached a script I use to disable all scripts in the specified table, which works perfect. I am unsure on how I would modify this so it would disable all constraints in the entir...
I posted a similat question on how to use date variables within Oracle SQL embedded in an Excel VB macro.
I did receive an answer (Thanks again)
I'm currently expanding the previous solu...
Hello,
I was trying to re-build an index online, but have run in to some confusion.
I looked at an index that had a B-Level of 3 and decided to rebuild it. So I issued the following comm...
When running a forms 6i with Oracle database 10g, sometimes the application crashes. It happens sometimes. It creates a dump file as follows
[05/01/08 07:58:35 India Standard Time]::Client ...
Both of the following SQL statements give me the ORA 00933 error.
SELECT DISTINCT s.customer_name FROM depositor AS s WHERE NOT EXISTS ( (SELECT branch_name FROM branch WHERE branch_city = ...
Hi guys,
I came to know about the jasper reports recently. so i downloaded it . but i dont know how to use it.
i have downloaded the jasperreports 3.0.1 for reports.
I want to use ...
In Oracle, and I do not know what version we are using 9i, etc. I wish to know how many bytes one character occupies. If it is dependent on the Oracle version/level, please list 3, or 4 of t...
I have a query that I am running
SELECT (FIRST_NAME || ' ' || LAST_NAME) AS NAME, ID, COMPANY_NAME
FROM OWNER
WHERE lower(COMPANY_NAME) like '%$s%'
order by LAST_NAME asc...
When i try to connect using sqlplus "sys/password@tns as sysdba" I am getting this error
ORA-09817: Write to audit file failed.
It was working fine till now
How to change database character set in Oracle Express Edition. I would like to set the database character set to EE8MSWIN1250. Is it possible?
Thanks for help
Adam
Hi,
Below is a condition in my where clause but I need to use the function trim to remove any spaces before and after both first and last names(otherwise my report isn't picking up the name...
HI all,
I am using a pl/sql block to change a bunch of records. I am doing this by creating a table on the fly using the execute immediate statment. After that I try to select records int...
Hi,
I want to know is there any method to improve the time taken to Compile Oracle packages.
I have some packages whose bodies have more than 10000 lines of code and if on requirement if i...
I am using the following API to set the value of a CLOB is a SQL query:
stmt.setCharacterStream(index, new StringReader(stringValue), stringValue.length());
The query looks like is as fo...
Good afternoon,
I have got two functions returning the results of an SQL execution:
- a pipelined function returning a table of records.
- a non-pipelined function returning a table of ...
Hi,
I have an application done in Oracle Forms 6i version which i need to migrate to Oracle 10g.What is the best preffered way of doing this and what will be the impact of this migrati...
I have few csv files with table data.I would like to export into oracle 10g using sqlloader.can you please tell me step by step procedure to do it including writing .ctl file and dmp(dump)file...
Hi,
My client has 4 HP-UX servers in a Veritas cluster. Each of these runs about 40 odd Oracle databases. When the DB fails over to another server in the cluster, Users for that DB have to re...
how do i spool the output data from a storeprocedure to File.i am using toad with oracle
I have form with oracle form 10g distributed on the internet i want to attach file with my form and other person donwload it ?
what is hp data protector and how to set up a hot backup using rman on data protector server?
The enviornment is oracle 9i and RMAN , dataprotector
I have a question about Consistent Gets: is it correct to say that the greater the concurrency (inserts or updates in the tables involved in the query) the greater the number of consistent get...
Hi,
While compiling some of the packages in schema i get the error pls 00907 cannot load library unit.
I checked and all library's except 1 DBMS_OLAPI_LIB
DBMS_OLAPI_LIB2 exist and are...
Hi,
I am using refCursor (as output param) from a stored procedure for executing the sql stored in the database.
(Sample generated query is added also stored procedure is attached)
The qu...
Here is my INSERT pseudo code. How come parallel not working? Working on another insert in the same database with same source table. Thanks.
INSERT /*+ append */ INTO BIG_TABLE
...
