Skip to main content

Oracle convert SYS_GUID() to VARCHAR

The following code snippet shows you how to convert GUID to a varchar

SELECT SYS.STANDARD.TO_CHAR(SYS_GUID()) FROM DUAL

Comments

Post a Comment

Popular posts from this blog

Building your first django app in minutes (Conjure up that overdue MVP)

As the trends shift towards data science and big data, machine learning there’s has never been a more lucrative time to start learning python and Django. Building your first Django app in minutes course takes an in-depth look at Django for web development with python. The course is tailored for both beginners, experts, to be founders.  Why not start today learning so you can land yourself the next dream job, build your MVP fast, get that work, and school project done fast. Coding doesn’t have to be mystic, it’s actually more familiar than you think.   Checkout this awesome  75% limited time discount
2 comments
Read more

How to rename hibernate auto generated Foreign key constraint names

When using hibernate maven plugin to generate your tables you may have noticed hibernate generates obfuscated foreign key constraint names which are unreadable. In order to change the constraint names you can apply the @ForeignKey annotation to give your foreign keys more meaningful names as shown below. Take note if you take this approach you will need to take by insuring no duplicate constraint names are created. import @org.hibernate.annotations.ForeignKey;   @ForeignKey( name = "FK_PI_COMPANY_ID" ) @ManyToOne(targetEntity = Company.class, fetch = FetchType.EAGER) @JoinColumn(name = "COMPANY_ID", nullable = true) private Company company;
Post a Comment
Read more