The SQL is 52,028 characters without spaces and 78,960 with spaces.
I need to use execute immediate so I can define the partition for one of the tables dynamically. This is the only reason ...
Hi
We have recently set the profiles for users to change password and there is a problem for users. Most of the users status have changed to lock as password expired after setting profile.
...
How to reduce the total SGA size
INSERT INTO EMPLOYEE(ID,EMPNO,TYPE1,TYPE2,TYPE3,TYPE4,TYPE5,TYPE6,TYPE7,TYPE8,TYPE9,TYPE10) VALUES(1,'EMP1','aa1','b2','vvv3','bb4','cc5','aa6','xx7','rr8','uui9','jjjjjjj10');
INSERT INT...
what is stream?. Where to get easy to understand material for an oracle streams.
please give as much info on stream as possible. Appreciate
9/3/2008 5:23:09 PM Application Error Error (100) 1000 N/A D%^E# Faulting application PROC_EXE.exe, version 2.2.0.360, faulting module oraclient10.dll, version 10.2.0.3, fault address 0x000ac2...
WHAT ARE THE DEFAULT STORAGE VALUES IT TAKES WHILE CREATING ANY TABLE OR MATERIALIZED VIEW?
Am updated a table it will update some colums and chages the last mdfy aswell which am calculating
as systimestamp using the code below
last_mdfy:= SYSTIMESTAMP;
...
We are going to migrate an Oracle 8i Database, currently running on a Linux server, to a new server on which we have to install Oracle 9.2. The new server will be running windows 2003 Server R...
How to move oracle 10g database to other location/partiton in in windows 2003 server?
we have dbf file in d: partition that has no enough space, is there any way to relocate this dbf file t...
During an Insert Operation, what is the accepted way to get the next sequence value?
With MS SQL Server, we use the scope_identity() method which returns that when an insert operation occur...
Hi
We are trying to insert into remote table using dblink and it gives us following error
ORA-01031: insufficient privileges
ORA-02063: preceding line from DEV3
The owner of the tab...
Hi there,
I have to write a query to report on all records for the previous day. However, these timestamps are stored as type VARCHAR2! Don't ask! I can't change the type so must make do.
...
Hi Experts,
I need use TOAD 8.5.0.50 free with Oracle 10g Express Edition and the toad show me the error ORA-28547 server conection fail, My tsname is OK, and i can connect with princi...
In an earlier post there was a query posted:
SELECT (&StartDate)+ROWNUM-1 AS DATEVAL FROM ( SELECT 1 nothing
FROM DUAL CONNECT BY LEVEL <= &EndDate )
WHERE (&StartDate)+ROWNUM-1 <= (&...
Am using a sp to load data into a table and the issue comes when the loading name into table
for instance If i want to load richard gibson into table thats working fine but if there are some...
Hi
I have a query that requires the top N attributes (based on a max(target field) calculation) to be returned for the top M items.
All information is in the same table.
Items are made ...
how can i develop and print report in oracle forms 10g, i have requirements need to built for sampe print report from forms and print it ..it has got second stage but as of now, i would reall...
how to create a package in oracle report builder and call a function in this package
i need an example please
Best Regards,
Ibrahim Ismail
we have a apex page that uses a popup. The popup works fine and refreshes the calling page. however after the popup closes and we go to submit or choose another item on the page, the page cl...
We use AIX 5.3 64 bit. I have never worked with RAW devices. What do I need to do to create an Oracle 10g database using RAW devices
Hi,
Quick Q as I cant find much in books / google. If I wanted to add two columns together how would I do that in SQL?
1 plus 1 = 2
Where 1 is is column 1, the other 1 is column 2 a...
How to find out number of row in the resultset in PL/SQL in Oracle without using COUNT(*)
can anyone please let me know difference between hints append and nologging.
Thanks in advance
Thanks
jeevan.
Hi All,
I am new to triggers, I need to create a trigger on 'A' table such that whenever a new row is inserted into 'A' table, it inserts a new row into 'B' table with some of 'A' table valu...
