Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dynamic sql in PL/SQL

Re: dynamic sql in PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Mar 2005 23:08:05 +0100
Message-ID: <do514155v501ur3p0f50oora25q02rtefe@4ax.com> 





On 22 Mar 2005 13:21:56 -0800, "jimmy gogo" <james.lawless_at_vhi.ie>
wrote:



>Do I have to use dynamic SQL here? What other options might I have?




You have to use dynamic sql and you need to concatenate the order by
clause (which is not a variable but a string) to the rest of the
statement.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Mar 22 2005 - 16:08:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US