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!

Create table with sequence and getdate()

3046502Oct 15 2015 — edited Oct 15 2015

Let me know, i have 2 questions from the below query

1) how to add sequence or autonumber for TRANS_NO column

2) getcurrentdate() for REQUEST_DT column

CREATE TABLE "Test"

  (

    "EMPLID"   VARCHAR2(11 BYTE) NOT NULL ENABLE,

    "Emp_NO" NUMBER(*,0) NOT NULL ENABLE,

    "REQUEST_DT" TIMESTAMP (6),

)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2015
Added on Oct 15 2015
3 comments
463 views