Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how can create the lexical parameter after the select class?

Answer Posted / ashutosh

just create a parameter
and write sql command in report like this...

select * from emp
where &condition

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if u want to delete all these detail block etc what will happen in form

1987


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2999


What are the various configuration files that are used by oracle forms?

1031


suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2021


hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2163


What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4617


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1695


can you convert or reverse engineer a fmx back to a fmb file?

1164


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

1000


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2230


List the different types of columns in oracle reports.

1003


In what sequence do triggers get fired by oracle forms?

957


did u received a single file or multiple files

2018


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1158


Is it possible to execute a dynamic sql from forms?

1070