Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.
The table emp stores the employee data table, in which the…Continue
Added by Jim King on August 25, 2014 at 1:35am — No Comments
Added by Neeraj Rajput on August 22, 2014 at 3:25am — No Comments
Contact me for Oracle High Availability Training / Online Classes - Dubai firstname.lastname@example.org
Added by Shanmugam on August 18, 2014 at 1:00am — No Comments
It is convenient to realize some common in-memory grouping with esProc, such as, equal grouping, alignment grouping and enumeration grouping. They are to be illustrated with the following examples.
Grouping basis of equal grouping is certain fields (or computed columns derived from fields) within a data set. Each group is a subset of original data set.
Case description: Group sales orders by the year. …Continue
Added by Jim King on August 15, 2014 at 12:21am — No Comments
SQL data table and esProc TSeq(Table Sequence) are all the structured 2-dimensional data objects. The records, indexes, and primary keys can all be applied to the structured data computing. Although both of them can be applied to the structured data computing, their application scenarios differ distinctly. TSeq is fit for solving the complex computing problem involving not-so-big data volume, while data table is fit for the common computation involving possible big data volume.
Added by Jim King on August 10, 2014 at 7:31pm — No Comments
esProc can write to databases and manage database transactions. Here we’ll look at the programming method of rollbacks and controlling transaction submission, etc.
A．Submit transactions automatically…Continue
Added by Jim King on August 7, 2014 at 11:00pm — No Comments