Your question is confusing. You mention an error but don't say what it is. You refer to a select statement below but don't give it and there seems to be fields posted all over the place for some reason. It's difficult to help.
The best idea is put the page on apex.oracle.com so someone can fix it for you.
Please mention the exact error.
Hello Krunal thanks so much for your reply i did manage to sort out that error how ever there is an other one that im stuck with . Basical i have a table with 6 columns begin score1, score2, score3, score4, form_total, User_id
What i want to do is create a trigger that adds the four numeric columns into the form_total
the trigger syntax i used was
create or replace trigger "Score_Total_t1"
insert on "Score_Total"
for each row
:NEW.USER_ID := ('APP_USER');
:NEW.form_total := ('Score1' + 'Score2 '+ 'Score3' + 'Score4 ');
However the :New.USER_ID works fine to input the currrent user but im getting an error with :NEW.form_total
Any ideas would be greatly appreciated
This is one of the worst uses for a trigger.
If you are on 11g+, USE A VIRTUAL COLUMN !!!!
create table score_total
score_total as (score1 + score2 + score3 + score4 )
Hay Man thank you so much that worked perfectly . Your a star really man iv been trying for the past day to sort this out thank you thank you thank you GOD BLESS YOU
Hay mike how come when i try to use this table in the same app on another machine i get a cannot insert into virtual column error
Its a DB thing. You can't INSERT into a Virtual Column.
You'll need to modify the page to prevent Automatic DML on the virtual column(s).
Worst case scenario: DIY DML. (ie replace the APEX process with your own INSERT, UPDATE, DELETE processes.)
For the DIY DML, build a PL/SQL Package.
You can use APEX to help you get started on it.
In the SQL Workshop, under Utilities, use the "Methods on Tables" wizard.
Personally, I'd use SQL Developer (and a code repository) to develop the Packages.
Hay mike thanks alot man for all your its really appricated
Hay mike i just wanted to let you know that in changed the properties on the button that was supposed to be the virtual column which i also included when i was doing the fetch columns from table . Into display only and that error i was telling you about (cannot insert into virtual column )went away and the values have been inserted into the table they where supposed to .