Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ApEx trigger (ApEx 3.2, Windows Server 2003)
ApEx trigger [message #435916] Fri, 18 December 2009 23:35 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi all,

Can anybody please let me know, what is ApEx triggers?
How to create them?
How to use them?
And some other details regarding that?

regards,
Delna
Re: ApEx trigger [message #435985 is a reply to message #435916] Sun, 20 December 2009 21:31 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi,I am not using Oracle apex..But These are from google Smile

Apex triggers

And some more stuff


Apex trigger

http:// blog.sforce.com/sforce/2009/10/one-of-the-things-about-working-for-a-company-that-innovates-at-such-an-incredible-pace-is-that-you-ar e-constantly-tasked-wit.html

http://wiki.developerforce.com/index.php/Round_Robin_Lead_Assignment_Trigger


Hope the above helpful:)
Good luck Smile

Sriram Smile
Re: ApEx trigger [message #435986 is a reply to message #435985] Sun, 20 December 2009 21:36 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Apex triggers nice Blog

Apex pdf

sriram Smile

[Updated on: Sun, 20 December 2009 21:55]

Report message to a moderator

Re: ApEx trigger [message #436005 is a reply to message #435986] Mon, 21 December 2009 00:53 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi ramoradba,

What do you think, can't I google on my own?
Don't I have access to Google?

Have you gone through, all the links you provided?
Each and everyone is irrelavent.
No one can help me.

Anyone else, who can help me in this regard?

regards,
Delna

[Updated on: Mon, 21 December 2009 00:54]

Report message to a moderator

Re: ApEx trigger [message #436029 is a reply to message #436005] Mon, 21 December 2009 03:05 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member

Hi delna thanx for your reply That i am wrong But....
Quote:
What do you think, can't I google on my own?


i don`t think so...As some of your messages are like "Search before posting"

Quote:
Don't I have access to Google?

I dont know this.

Quote:
Have you gone through, all the links you provided?

Yes...All are from
1) apps2fusion
2)forums.oracle about Apex triggers.
3)tittled Apex triggers for Email messages.
4)Developerforce.com
5)apex-notes.blogspot.com(search for the "Build an image gallery using APEX " here is n`t that what you are looking for?)


Quote:
Each and everyone is irrelavent.


Here On the link provided Only one link (apex pdf is irrelevant )

If you still think those are irrelavent, Let me know why?
And as i told on my first reply, Quote:
"I am not using Oracle apex"
.I just tried to help you.If iam wrong let me know so that i will start learning Apex thats good for me too. Smile

Good luck.

sriram Smile

[Updated on: Mon, 21 December 2009 03:28]

Report message to a moderator

Re: ApEx trigger [message #436048 is a reply to message #436029] Mon, 21 December 2009 03:42 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Some of the links you provided was containing oracle DATABASE TRIGGERS.
And remaining was containing non-oracle triggers.

No one was related to ApEx triggers.

regards,
Delna
Re: ApEx trigger [message #436076 is a reply to message #436048] Mon, 21 December 2009 05:44 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Even On this i found the same cmd for the triggers...Then what are the diffrences you are saying between Apex trigger and database triggers?

sriram Smile
Re: ApEx trigger [message #436090 is a reply to message #436076] Mon, 21 December 2009 07:20 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
If I would knowing the difference, it might be possible that I know enough about it and I would not ask question here.
Don't know anything about ApEx triggers Sad

Last link is also not helpful to me...

regards,
Delna
Re: ApEx trigger [message #436091 is a reply to message #436090] Mon, 21 December 2009 07:28 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
As i am unable to find any relavant document (as you stated like that) I am posting this link as my last reply for this topic search on this.. if it is also not helpful,I can say one thing....
Good luck..

Sriram Smile
Re: ApEx trigger [message #436100 is a reply to message #435916] Mon, 21 December 2009 09:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Perhaps if you could show us the context in which you have seen references to Apex Triggers, we might be able to be more help.
Re: ApEx trigger [message #436167 is a reply to message #436100] Mon, 21 December 2009 23:35 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Actually, this was the question asked to me in one of the recent interview. Don't know anything about it. Sad

regards,
Delna
Re: ApEx trigger [message #436168 is a reply to message #436167] Mon, 21 December 2009 23:46 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi,delna,
If you don`t know what exactly Those,How can you say/post that the links provided by me are irrelevant/not helpful.

Always trigger is trigger if it is in reports/forms/apex/etc... in oracle products as per my knowledge.
based on the context only we will/can use them.

You can say that the message/reply by any one for your post are not helpful when ever you got some info/(any correct link) for that.

sriram Smile
Re: ApEx trigger [message #436176 is a reply to message #436168] Tue, 22 December 2009 00:48 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
I asked about database triggers also to the interviewer for confirmation that he is not talking about it, but he refused. That is why I am sure, it is not database trigger.

regards,
Delna
Re: ApEx trigger [message #436217 is a reply to message #436176] Tue, 22 December 2009 03:12 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Apex blogs
I got the above link from this and i found this

Apex Trigger :
  A trigger is Apex code that executes before or after the following types of 
operations on database objects:
 insert, update, delete, merge, upsert, and undelete. 
These are similar to database triggers written in Oracle's PL/SQL or Microsoft's tSQL.
 One important note is that all Apex triggers are bulk triggers. 
That means that a trigger can be invoked by a single record transaction or by a bulk 
operation such as an API call that has a batch of up to 200 records.
 For example, if I create an Account in the user interface,
 any triggers on the Account object will be invoked with a single record as the input. 
Conversely,
 if there is an integration sending a batch of 200 records to the API, 
that same Apex trigger on the Account object will be invoked only ONCE,
 but with 200 Account records as input. 
on the web.

even some presentation with sample code on it. Hope this info helpful.Smile

sriram Smile

[Updated on: Tue, 22 December 2009 03:13]

Report message to a moderator

Re: ApEx trigger [message #436348 is a reply to message #436217] Tue, 22 December 2009 22:56 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi ramoradba,
Thanks a lot for your help, specially for that Quoted string you provided in your last post here. Smile

regards,
Delna
Re: ApEx trigger [message #436350 is a reply to message #436348] Tue, 22 December 2009 23:02 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Now i feel like I got this

/forum/fa/1940/0/

sriram Smile
Re: ApEx trigger [message #436352 is a reply to message #436350] Tue, 22 December 2009 23:12 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
/forum/fa/1581/0/

regards,
Delna
Re: ApEx trigger [message #436353 is a reply to message #436352] Tue, 22 December 2009 23:18 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
And Delna, You know one thing,What ever you agreed with my post all are posted at my first reply...if you observed or not
the same link from different website....
Apex_Code
so thats why here i request not only you but all the members of this forum to read the content of the link provided by any user completely then only post the comment/reply on that.

Thank you
Goodluck

sriram Smile

[Updated on: Tue, 22 December 2009 23:30]

Report message to a moderator

Previous Topic: Printer Friendly Report
Next Topic: Help Wanted
Goto Forum:
  


Current Time: Fri Mar 29 09:06:29 CDT 2024