Exforsys

Online Training

Creation of cursors and triggers in sql

This is a discussion on Creation of cursors and triggers in sql within the Microsoft .NET forums, part of the Programming Talk category; Hi All!!! Can any one guide me on creation of cursors and triggers in sql and how to call them ...


Go Back   Exforsys > Programming Talk > Microsoft .NET

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-19-2007, 03:47 AM
Junior Member
 
Join Date: Feb 2007
Posts: 2
harikreative is on a distinguished road
Thumbs up Creation of cursors and triggers in sql

Hi All!!!

Can any one guide me on creation of cursors and triggers in sql and how to call them from the front end...

Thanks,
Hari
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-19-2007, 01:18 PM
Senior Member
 
Join Date: Apr 2006
Posts: 144
caradoc is on a distinguished road
Hari,

Cursors are used as part of your stored procedures along with pl/sql blocks. triggers are defined on tables on events..

triggers get executed automatically depending on the event you code..

Please refer to oracle tutorials here ...

http://www.exforsys.com/content/category/17/261/343/

http://www.exforsys.com/content/category/17/220/267/

It should get you started... first you need to understand the concepts before asking these kind of questions since they are not one line answer questions.

Thanks,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
IBM - Oracle PL SQL / Crystal Reports, 2+Year Exp, Bangalore. lokeshm Experienced Job Seekers - India 0 03-22-2006 01:23 PM


All times are GMT -4. The time now is 12:18 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.