Oracle forms

Dear Experts,
   Can anybody teach me,how can i use from clause query and transaction triggers in oracle
forms.Iam currently working in oracle 10g.

Thanks & regards,

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Oracle forms has a vast numbers of triggers,

You can go to site,

Forums for oracle forms are there which can help you a lott.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helena Markováprogrammer-analystCommented:
You can also read "Guidelines for Choosing Block Data Sources" topic in the forms on-line help.

The main difference between FROM clause and transactional triggers is that transactional trigger block datasource can be used for DML and FROM clause not.

Using a FROM clause as a block datasource is similar to using an updateable join-view as a block datasource. However, a FROM clause provides more control, because the presence of a DBA is not required to define the view. You should note that the FROM clause produces results that are identical to an updateable join-view from the client side, but that there is no defined view on the server.

Transactional triggers are typically used when Oracle Forms is running against a non-ORACLE datasource. When transactional triggers are used, Oracle Forms default functionality is replaced.A transactional trigger block datasource can be used for both query and DML. Array processing is not supported.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.