JavaTMP Bootstrap Template Documentation Index

Database Related Information

Referenced Database Schemas:

• http://www.ntu.edu.sg/home/ehchua/programming/sql/sampledatabases.html

Analytical Oracle SQL Functions

The following links provide you information about Oracle SQL statements related to Analytics and reporting:

• http://www.orafaq.com/node/55
• https://oracle-base.com/articles/misc/analytic-functions
• https://technology.amis.nl/2004/09/29/analytical-sql-functions-theory-and-examples-part-1-on-the-partition-clause/
• https://technology.amis.nl/2004/10/04/analytical-sql-functions-theory-and-examples-part-2-on-the-order-by-and-windowing-clauses/
• https://github.com/oracle/analytical-sql-examples
• http://www.java2s.com/Tutorial/Oracle/0320__Analytical-Functions/Catalog0320__Analytical-Functions.htm
• https://oracle-base.com/articles/misc/analytic-functions
• https://www.red-gate.com/simple-talk/sql/oracle/introduction-to-analytic-functions-part-1-2/
• https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/BigDataSQL/BigDataSQL_HOL.html

General SQL Window Function links:

• https://blog.jooq.org/2015/05/12/use-this-neat-window-function-trick-to-calculate-time-differences-in-a-time-series/
• https://jaxenter.com/10-sql-tricks-that-you-didnt-think-were-possible-125934.html
• http://www.mysqltutorial.org/mysql-window-functions/
• https://blog.jooq.org/2013/11/03/probably-the-coolest-sql-feature-window-functions/

Oracle Stored Procedures

The following links provide you information to call Oracle stored procedures and functions with JPA and Hibernate:

• https://vladmihalcea.com/how-to-call-oracle-stored-procedures-and-functions-from-hibernate/
• https://www.journaldev.com/2502/callablestatement-in-java-example

Multilingual database Design

• https://stackoverflow.com/questions/2227985/whats-the-best-database-structure-to-keep-multilingual-data
• https://stackoverflow.com/questions/316780/schema-for-a-multilanguage-database
• https://stackoverflow.com/questions/26765175/multi-language-database-with-default-fallback

JDBC Helper links

• https://www.progress.com/blogs/jdbc-tutorial-extracting-database-metadata-via-jdbc-driver
• http://commons.apache.org/proper/commons-dbutils/

Tables Join

• https://stackoverflow.com/questions/38549/what-is-the-difference-between-inner-join-and-outer-join?rq=1
• https://zeroturnaround.com/rebellabs/how-to-use-jpa-correctly-to-avoid-complaints-of-a-slow-application/

JPA Links

• https://vladmihalcea.com/sql-query-parent-rows-all-children-match-filtering-criteria/
• https://www.logicbig.com/tutorials/java-ee-tutorial/jpa/map-joins.html
• https://gist.github.com/fwgreen/ff5077bbfdb20c8b6187e9cd0b74fbc0
• https://www.programcreek.com/java-api-examples/?class=javax.persistence.criteria.CriteriaBuilder&method=lessThan
• Locking and Concurrency in Java Persistence 2.0
• Java Persistence Locking

General Links

• https://stackoverflow.com/questions/9253244/sql-having-vs-where
• https://www.essentialsql.com/what-is-the-difference-between-where-and-having-clauses/
• https://www.red-gate.com/simple-talk/sql/t-sql-programming/ten-common-sql-programming-mistakes/
• https://jaxenter.com/10-sql-tricks-that-you-didnt-think-were-possible-125934.html

This site is open source. Improve this page.