Hi,
I am using Oracle Enterprise Manager to write a trigger, but get "Missing in or out parameters at index:: 1" everytime that I want to use :new or :old. I looked around on the internet and it...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23813106.html
I want to write a trigger like this:
...
begin
if :old.column1 is null then
:new.column1A := :old.column1
end if
end
...
If I want to do the same thing on 3 columns for example, is it bet...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23820479.html
Zones:
Oracle 10.xDate Answered: 10/16/2008 Rating: 9.3 Views: 0
Hi,
I have a trigger on a table and I want to capture the os user who updates a field in that table. How can I do that on a row level trigger?
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23822267.html
I am trying to created a materialized view but having trouble to do a fast refresh on commit. I get the error ORA-12015: "cannot create a fast refresh snapshot from a complex query"
Can someon...
http://www.experts-exchange.com/Database/Oracle/Q_23929058.html
I am pulling my hair out on this one, we have an application that connects to our Oracle 10g database via ODBC, the application creates the connection and durring one of the long recrodsets (980,00...
http://www.experts-exchange.com/Database/Software/SCM/Oracle/Q_24717687.html
I need to be able to obtain the start_date and end_date of the previous month using an Oracle SQL query with sysdate.
Right now, I run select trunc(sysdate,'MM')-1, and that will give me the p...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23059726.html
Zones:
Oracle 10.xDate Answered: 01/04/2008 Rating: 8.6 Views: 36
Hi Experts,
i have to change where condition at the run time in the stored procedure
my stored procedure is as follows
create procedure MyFirstTestProcedure as
( Param1Number;Param2Number;...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23345857.html
Zones:
Oracle 10.xDate Answered: 10/08/2008 Rating: 9.0 Views: 4
I have daily/weekly/monthly reports to generate in pdf format.
Currently they are being run via Report Builder 10.1.2.0.2
These reports have 2 User Parameters for dates (START_DATE, END_DATE).
...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23487456.html
Is there a way with Oracle SQL to select a column if it only contains numeric characters, else return NULL for that field?
I have been using the is_number function in my sql:
and is_number(i....
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23557104.html
Zones:
Oracle 10.xDate Answered: 07/11/2008 Rating: 9.1 Views: 0
I need to write a query which will be joing both the fact and dimention table by account level to get the amount which is stored by group level (detail).
I've no problem writing a query for the de...
http://www.experts-exchange.com/Database/Oracle/Q_23719664.html
Zones:
OracleDate Answered: 09/11/2008 Rating: 7.2 Views: 0
