Quick Copy paste Code Snippets

Here is a String extensions C# lib that i built that has simliar functions as those avaliable in Apache commons StringUtils library. Currently its a work in progress as i find the time to update it. Hopefully it maybe useful for your dot net projects. The Nuget packet package can be found here and Git hub source repo

The following example below demonstrates how we can go about exposing the DbSet.SqlQuery method when using IDbSet interface Please comment below if you have a better approach.

The following sql statement allows you to view the relationships between primary keys and foreign keys with other tables. SELECT uc.constraint_name||CHR(10)    || '('||ucc1.TABLE_NAME||'.'||ucc1.column_name||')' constraint_source    , 'REFERENCES'||CHR(10)    || '('||ucc2.TABLE_NAME||'.'||ucc2.column_name||')' references_column     FROM user_constraints uc ,     user_cons_columns ucc1 ,     user_cons_columns ucc2     WHERE uc.constraint_name = ucc1.constraint_name     AND uc.r_constraint_name = ucc2.constraint_name     and ucc1.position        = ucc2.position     AND uc.constraint_type   = 'R'     --AND uc.constraint_name   = 'FKF32F2C126588DBBC'     order by ucc1.table_name ,     uc.constraint_name;     CONSTRAINT_TYPE (from 11gR2 docs) C - Check constraint on a table P - Primary key U - Unique key R - Referential integrity V - With check option, on a view O - With read only, on a view H - Hash expression f - cons

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;

The following code snippet shows you how to convert GUID to a varchar SELECT SYS.STANDARD.TO_CHAR(SYS_GUID()) FROM DUAL