Tags » Query

APPROX_COUNT_DISTINCT function in Oracle 12C

Oracle 12C has a new function APPROX_COUNT_DISTINCT which helps us to calculate the approximate number of distinct values from a table. As the name indicate it returns a approximate value and not the exact count. 231 more words

Queries and Synopses and Agents, Oh My!

Today we move into the business-side of writing. It’s not really something you want to worry about until you’re done with your project, since you should never, ever query an agent until you have a finished book to send them. 1,390 more words


Use of TVARVC table in BW customer exit variable

The TVARVC table serves very handy when we have to do a dynamic selection in BEx queries based on some condition which can change in future. 559 more words


Perbedaan HQl dan Criteria Query Hibernate

Tutorial kali ini saya akan membahas perbedaan antara HQL dan Creteria query.

HQL (Hibernate Query Language) adalah bahasa query berorientasi object mirip dengan SQL. HQL beroperasi dengan object persisten dan berbagai peropertinya, query HQL ini akan diterjemahkan oleh hibernate dalam bentuk SQl query konvensional untuk manipulasi database. 315 more words


How not to query (for new writers)

Are you aware of my journey to hybrid-dom? No? Well, let me tell you, it involves being both an indie published author, with all of the crazy DIY stuff that involves and it also means I’m aiming to get traditionally published by a publishing house. 1,011 more words