What is bind reference and how can it carate?

Answer Posted / guest

Bind reference are used to replace the single value
in sql,pl/sql statements a bind reference can be created
using a (:) before a column or a parameter name.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is responsibility and how u attach How to create user and how u attach with responsibility.

1846


Explain the different levels at which oracle form services interact.

815


Can we invoke one form from another in a multi-forms application?

893


i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1786


what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

816


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2726


What is the difference between bind and lexical parameter?

806


if some data is not transfered where it will get stored

1695


how do u place it in required folder

1709


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1790


i am writing a query select EmpNo from Emp how can i call in after parameter form

1829


what exactly u write in when_new_form_instance

3206


Explain the various types of oracle report?

846


how to send file attachment from oracle forms

2333


Name the different triggers associated with oracle forms having a master-detail relationship.

731