Skip to Main Content
Forums

SQL & PL/SQL

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 create a table with SYSDATE in the name

LuKKaMay 7 2018 — edited May 7 2018

Hello,

I want to create a backup table and the name should be ending with _BKP_SYSDATE.

For example, I have a table Employee and today's date is 07_MAY_18.

And when I will create a backup table then it should create as EMPLOYEE_BKP_07MAY18.

So I want to create a script so that when anyone runs it it will create with the date.
This post has been answered by Etbin on May 7 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2018
Added on May 7 2018
#sql-pl-sql
8 comments
9,222 views