Hi Im using the following trigger to refresh my mview.

BEGIN
DBMS_SNAPSHOT.REFRESH(
LIST => 'EQUIPMENT_FEATURES_MVIEW'
,PUSH_DEFERRED_RPC => TRUE
...

Thanks everyone..
The issue is resolved

ha ha, thanks for that.

But my Mview is also named as EUIPMENT_FEATURES_MVIEW

Hi Thanks, the change in order did have effect. Now its throwing another error.
select
apex_item.checkbox(1,"EQUIPMENT_ID") Tick,
ef.equipment_type as "Device Type",
e.equipment_name as...

I have modified the SQL as follows but its throwing me the same error
select
apex_item.checkbox(1,"EQUIPMENT_ID") Tick,
ef.equipment_type as "Device Type",
e.equipment_name as "Device Name",
...

Do you mean I have to put the groupby clause before where clause?

Hi Im trying to execute a the following query, but its throwing me an error

select
apex_item.checkbox(1,"EQUIPMENT_ID") Tick,
ef.equipment_type as "Device Type",
e.equipment_name as "Device...

I'm currently working on APEX where I expect the following query to work.. But its not working or giving me any errors.

here is the query

select et.equipment_type,
max(case when...

sorry mate.. basically wanted to give the font a color and cud only find red flavor in the pull down..

I understand your point.. Looks like Daniweb is a site of morons..
Bye Bye Daniweb ...

Hi I need to develop an application which reads a csv file from a server does data validation and write to a file and then bulk upload the data to an Oracle database.

The details of the...