Home » Developer & Programmer » Reports & Discoverer » Lexical Parameters
Lexical Parameters [message #90229] Wed, 15 December 2004 02:35 Go to next message
pooja
Messages: 31
Registered: September 1999
Member
HI All,

Can we use lexical parameters in From clause of a
query??

Ex:
SELECT empno,ename
&lex_prm;

Its urgent..can nyone can explain this.

pooja

Report message to a moderator

Re: Lexical Parameters [message #90231 is a reply to message #90229] Wed, 15 December 2004 22:49 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
yes you can.

E.g. Create a parameter P_query in your report.
Set its initial value as Select empno,ename,deptno from emp;

Now write our query in datamodel as :

Select empno,ename,deptno
from (&P_query);

HTH
regards
Himanshu

Report message to a moderator

Previous Topic: ORA 12222 while connecting through discoverer
Next Topic: ref cursor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 16:15:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.