Link to home
Start Free TrialLog in
Avatar of sai niharika Sariputi
sai niharika Sariputi

asked on

need example for with,merge,trigger statements in cursors

how to use with clause , merge statement and triggers inside the cursor .please explain with examples.
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

That's quite a "messy" question, sorry!
Please provide MORE information!
Avatar of sai niharika Sariputi
sai niharika Sariputi

ASKER

i want to know how we can use ' with clause'  inside cursor
This is still not enough information!!

Can you provide some code snippets or pseudo code maybe?
What exactly do you want to achieve?!
It looks like you have two questions open for this same topic.  Can you close or delete one of them, so we can focus on only answering one question here from you, not two?

Also triggers and cursors don't go together.  Those are two separate objects that cannot be combined.  Cursors are for retrieving information, ("select..."), triggers are for processing information (insert, update or delete).

And please give us a specific example of something you have tried that you are having trouble with, or a specific business problem that you are trying to solve.  If you just give us a general question, we can only give you a general answer something like: read the documentation.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.