CODEWITHSUNDEEP
plsqloracle-apex
user5924337
user5924337

Reputation: 23

New to PL/SQL can someone assist w a simple expression

I have a PL/SQL Expression which displays a page item's value. It's very simple:

:P240_STREET_NAME

So this would return, for example, 666 Fifth Avenue

I want it to return more items, for example

2 BR / 1 BA on 666 Fifth Avenue

The item for 2 BR is P253_BEDROOMS and the item that would be 1 BA is P240_BATHROOMS

How would I write this expression? I'm still learning so please go easy on me :)

Upvotes: 1

Views: 440

Answers (1)

Vance
Vance

Reputation: 897

You can use this expression 

  :P253_BEDROOMS || '/' || :P240_BATHROOMS || ' on ' || :P240_STREET_NAME

Upvotes: 1

Related Questions