Page 1 of 1

Declare select * from dual end

Posted: Mon Apr 30, 2018 8:41 am
by tricampeon81
friends within the query section I can use a declare

???
?????

Posted: Mon Apr 30, 2018 10:48 am
by chulett
Can you be a wee bit more specific, please? In the query section of what and what are you trying to accomplish? I would also be curious why you would feel the need for using syntax like that.

Re: Declare select * from dual end

Posted: Mon Apr 30, 2018 3:00 pm
by tricampeon81
I need to improve a query and for that I need to use variable before the query
it's possible??

Posted: Mon Apr 30, 2018 3:41 pm
by chulett
Again, hard to say without details. I for one am not really sure what "use variable before the query" means... especially the "before" part. Do you mean you need to bind a variable into the query? If not, can you provide a specific example of what are looking to do? Maybe when we see it we can say yes or no or provide a proper path to accomplish it.