OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Changing SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing SQL [message #243877]

Sun, 10 June 2007 14:05

spooja
Messages: 25
Registered: May 2007

Junior Member

Can Somebody tell me at the time of runtime can we change SQL in Reports?

Report message to a moderator

Re: Changing SQL [message #243882 is a reply to message #243877]

Sun, 10 June 2007 16:55

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you explain what you, exactly, want to do? If we know the problem, we might provide a better solution. I believe that simple YES or NO aren't the answers you need.

Report message to a moderator

Re: Changing SQL [message #243891 is a reply to message #243877]

Sun, 10 June 2007 18:37

spooja
Messages: 25
Registered: May 2007

Junior Member

Somebody asked me this question in an interview whether you can change the SQL during runtime or not?

Report message to a moderator

Re: Changing SQL [message #244417 is a reply to message #243891]

Tue, 12 June 2007 13:20

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi,

Then I think you should first search it Why yes or No. Then better learn it for next interiew. Read about Dynamic sql also.

Ashu

Report message to a moderator

Re: Changing SQL [message #244429 is a reply to message #243877]

Tue, 12 June 2007 14:52

spooja
Messages: 25
Registered: May 2007

Junior Member

Thats what I asked whether it is yes or no?

Report message to a moderator

Re: Changing SQL [message #245702 is a reply to message #244429]

Mon, 18 June 2007 10:14

Madhu_bala
Messages: 16
Registered: January 2007
Location: Chennai, Now at Saudi Ara...

Junior Member

U can change the sql at run time using Dynamic SQL.
But it too have some limitations.

Report message to a moderator

Previous Topic:	How to disply Physical Page No. on all but last page
Next Topic:	Problem in the format of output in Excel (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 07:09:35 CDT 2024