Enter Keywords:
1 - 10 of 38(0 seconds)
Sort By:
 
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 Rating: 7.4 Views: 12
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 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?
Zones: Oracle 10.x, OracleDate Answered: 10/17/2008 Rating: 9.6 Views: 0
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...
Zones: Oracle, Oracle 10.x, ...Date Answered: 12/21/2008 Rating: 8.2 Views: 0
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...
Zones: Oracle, Oracle, Oracle 10.xDate Answered: 09/29/2009 Rating: 9.0 Views: 0
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 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;...
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). ...
Zones: Oracle 10.x, OracleDate Answered: 06/16/2008 Rating: 9.3 Views: 83
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 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...
Zones: OracleDate Answered: 09/11/2008 Rating: 7.2 Views: 0