Advertisement

1 - 10 of 29 containing alltags:("10.x") (0 seconds)
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...
Zones: Oracle 10.x, PL / SQLDate Answered: 10/16/2008 Grade: A Views: 21
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...
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?
Zones: Oracle 10.x, OracleDate Answered: 10/17/2008 Grade: A Views: 53
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...
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;...
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). ...
Zones: Oracle 10.x, OracleDate Answered: 06/16/2008 Grade: A Views: 121
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....
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...
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...
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...
Zones: Symantec Anti-Virus, Anti-Spyware, Enterprise Anti-V...Date Answered: 11/13/2008 Grade: B Views: 21