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 Grade: A 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 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 Grade: A Views: 78
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 Grade: A Views: 8
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 Grade: A Views: 58
I have a SQL query which returns results and places the results in an XML file. the problem is that one of the fields can contain ampersands (&) in the field, so when a bare & is put into an XML f...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23697173.html
Zones:
Oracle 10.xDate Answered: 09/02/2008 Grade: A Views: 56
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 Grade: B Views: 8
We have Symantec System Center (corp edition).
We have a couple of infected machines that have outdated Virus Defs (which I am assuming is a Virus). I cannot get the VirusDefs updated (they are...
http://www.experts-exchange.com/Software/Internet_Email/Anti-Virus/Symantec/Q_23863734.htm...
