| Clubbing Alter session in SQL [message #447505] |
Mon, 15 March 2010 09:58  |
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
|
Member |
|
|
All,
I am here to ask solution for one wiered requirement,
I need to have some way to add Alter session command in the SQL statement.
Alter session set "_gby_hash_aggregation_enabled"= FALSE
I need to have above command to be executed before my SQL statement in the report. In report I can not use two statement
So I need some way to club Alter command and My SQL statement together so that my SQL will work with the report.
any idea is it possible ?
thanks,
freakabhi
"everybody in the work is insane, average of them is called as normal!! "
|
|
|
|
| Re: Clubbing Alter session in SQL [message #447507 is a reply to message #447505] |
Mon, 15 March 2010 10:02  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
In SQL*Plus you can run the two statements one after the other.
Whether you can do it "in the report" would depend on which tool you use to create the report.
|
|
|
|
|
|
| Re: Clubbing Alter session in SQL [message #447511 is a reply to message #447509] |
Mon, 15 March 2010 10:35 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
With what programming language?
As far as I know, with Java or C# you open an Oracle connection, and then start the Crystal Report.
Then you could run the alter session on the Connection object before starting the report.
|
|
|
|
| Re: Clubbing Alter session in SQL [message #447530 is a reply to message #447511] |
Mon, 15 March 2010 14:33 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
If Crystal Reports are anything similar to Oracle Reports, perhaps they have something like "Before Report Trigger" which can be used to execute such a command.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
