Templates...a little clarification

[JaedenRuiner]

Howdy,

I'm rather new to Pl/SQL Developer, and loving every second of it. I had always found SQL to be so tasking because I'm a programmer and used to modern IDE's, and most SQL was not exposed to me in such a fashion.

Anyway, I am finding out about these Templates, and they are awesome, because a lot of my daily tasks involve repetitive SQL design query design, so a template that allows me to plug in a few of the values is awesome. However, I am curious about a few things, so with my effusive rambling done i will get to the point.

• Multiple Variable Check
  

  Note that you can create multiple program units in one template by separating them with a line with just a slash (/) character. This way you can create a templates for a package specification and body in a single program file.

  What exactly does this mean?
• New Line / Multi-Line input
  
  

  select *
     from table
     where field in (
         '336', '167', '8335', '485', '4331', '4878',
         '4834', '4852', '4890', '4893', '8381', '4834',
         '481', '48', '480', '47'
           )
  
  Template:
          [+Values="(table.field in ("]
                  [Values]
              [+Values=")
          )"]

  As you can see I am trying to set up the design right, but in the template dialog, "Values" is a single line Edit component. Is there a way to insert a line break character via escape codes (like the C++ "\n") or other such methodology to cause the Template to enforce a linebreak in the user inputed text?

 

[Marco Kalter]

Multiple Variable Check

Due to the [-AgeMax=+] expression you will always get some output, even is no AgeMin or AgeMax are supplied. Is this expression necessary?

From the Help

If you have a template like this:

New Line / Multi-Line input

No, multi-line text is currently not possible.