Home » SQL & PL/SQL » SQL & PL/SQL » Concenate a sql
Concenate a sql [message #281614] Sun, 18 November 2007 15:24 Go to next message
futi
Messages: 22
Registered: November 2007
Junior Member
hii.. i have a pl sql procedure. it has 3 in parameters, 1 out parameter as a SYS_CURSOR.
i can return cursor with normal plsql.
But i wanna it with dynamic plsql.

For example, in pl sql code, a '<' char at somewhere. But, it must be dynamic. According to another query this character may be '>' or '<' ... how can i do this?

is there any example code?
thanx
Re: Concenate a sql [message #281615 is a reply to message #281614] Sun, 18 November 2007 15:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Are both GOOGLE & the SEARCH function on this forum broken for you?

Have you read & followed the posting guidelines in the #1 STICKY post at the top of this forum?
Re: Concenate a sql [message #281695 is a reply to message #281614] Mon, 19 November 2007 00:59 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already tried.
I see no difficulty in building a string from parameters.

Regards
Michel

[Updated on: Mon, 19 November 2007 00:59]

Report message to a moderator

Previous Topic: procedure
Next Topic: Dynamic query using bind variables - search query
Goto Forum:
  


Current Time: Sat Dec 10 18:52:46 CST 2016

Total time taken to generate the page: 0.07333 seconds