Home » SQL & PL/SQL » SQL & PL/SQL » Bind Variables
Bind Variables [message #621779] Mon, 18 August 2014 05:06 Go to next message
supriya_singh
Messages: 2
Registered: August 2014
Junior Member
what are bind variables,How do we use bind variables in triggers,How do we execute them.help me understand this concept with an example.

Thanks in advance

Report message to a moderator

Re: Bind Variables [message #621782 is a reply to message #621779] Mon, 18 August 2014 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
what are bind variables


http://docs.oracle.com/cd/E11882_01/nav/idx-b.htm#index-BI, scroll down to "bind variable".

Quote:
How do we use bind variables in triggers


You can't.

Quote:
How do we execute them


What "them" refer to?

Quote:
help me understand this concept with an example


http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm#sthref517

Report message to a moderator

Re: Bind Variables [message #621795 is a reply to message #621779] Mon, 18 August 2014 07:57 Go to previous messageGo to next message
supriya_singh
Messages: 2
Registered: August 2014
Junior Member
Hello,

I am supriya and am new to oracle forms.I have not still been assigned with a trainer.but am trained by a dba in sql and I have gone through tutorialspoint and learnt some basic concepts of pl/sql(stored procedured and functions ).And have also created a sample from and a sample master detail form. Your guidance will be much of help.kindly, Help me with some materials. Smile



Report message to a moderator

Re: Bind Variables [message #621796 is a reply to message #621795] Mon, 18 August 2014 07:59 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Report message to a moderator

Previous Topic: Hierarchical Output
Next Topic: ORA-04052 Error - URGENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 15:25:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.