Is it possible to join strings in PL/SQL procedure in my sql statement

Question

As the title suggests, I would like to know if it is possible to join the string in a select statement within a PL/SQL procedure.

For example, I have something like this

SELECT FCS.CATEGORY, 
       FCS.NUMBERS, 
       FCS.POINTS 
 WHERE FCS.OBJECT = 'T' 
   AND FCS.THIS_DB & strSelectedDB &

So, is it possible to do something like this?

what you are looking for is Dynamic SQL download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/… — Jagmag
– Jagmag, Commented Oct 21, 2010 at 13:53

Justin Cave · Accepted Answer · 2010-10-21 13:55:59Z

2

Your example is a little confusing. You can concatenate multiple strings using the || operator. But you'd then you'd have to compare the concatenated string to something. You can compare columns to local variables directly, though, i.e.

SELECT fcs.category,
       fcs.numbers,
       fcs.points
  FROM some_table fcs
 WHERE fcs.object  = 'T'
   AND fcs.this_db = strSelectedDB

assuming that strSelectedDB is a local variable in your PL/SQL block.

answered Oct 21, 2010 at 13:55

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to join strings in PL/SQL procedure in my sql statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related