OraFAQ Forum: SQL & PL/SQL » Explain below query

Home » SQL & PL/SQL » SQL & PL/SQL » Explain below query

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

Explain below query [message #604051]

Mon, 23 December 2013 06:23

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

I Searched on Google about below query .Can any one please explain the below code

At declaration section 
--------------------
QT varchar2(10) :='''';  -->see here

 at if condition
--------------
if : :CONTROL_BLOCK.ITEM_NAME is not null then
         finalstr := finalstr || 'AND ITEM_NAME =' || QT||:CONTROL_BLOCK.ITEM_NAME||QT;
end if;

Thank You

Report message to a moderator

Re: Explain below query [message #604053 is a reply to message #604051]

Mon, 23 December 2013 06:32

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

Senior Member
Account Moderator

QT is a single quote. In a form, someone decided to concatenate that variable with a string (instead of messing up with multiple single quotes). Suppose that :control_block.item_name contains a string mist598. That code evaluates to

... and item name = 'mist598'

Report message to a moderator

Re: Explain below query [message #604055 is a reply to message #604053]

Mon, 23 December 2013 06:39

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thank You Littlefoot, Good explanation.. Smile

Report message to a moderator

Previous Topic:	Adding column to the table is taking long time
Next Topic:	Pass variable value in input XML for calling webservice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:49:17 CDT 2024