Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use code templates #time#, #date#, #for#, #user# in SQLDev 20.2?

I have the following templates defined:
image.pngThere is a simple template named "d" with the content "#date# #time#" for testing purposes.
I can select it in the worksheet:
image.pngand then I get this result:
image.pngI expected that the placeholders #date# and #time# will be replaced (e.g. with the current date and time values). There is a similar question open since November 2019: https://community.oracle.com/tech/developers/discussion/4303194/sql-editor-code-template-date-format-of-id-date-time - However, there the problem is that the date and time format cannot be configured.
In my case nothing happens. I tried older versions as well (4.1.3, 4.1.5, 19.1.0, 19.2.0, 19.4.0) under macOS and Windows, but the result is always the same. No replacement at all.
Has anyone an idea what I'm doing wrong? - I'm running out of ideas. What can I change to make it work?
Thanks.

This post has been answered by Glen Conway on Oct 17 2020
Jump to Answer
Comments
Post Details
Added on Oct 17 2020
5 comments
868 views