PL/SQL, YQL and SQL Windows functions

KBleivik
Site Admin
Posts: 178
Joined: Tue Sep 29, 2009 6:25 pm
Location: Moss Norway
Contact:

PL/SQL, YQL and SQL Windows functions

Postby KBleivik » Sun Dec 29, 2013 7:19 am

1. Introduction.
We start this thread by mentioning the Yahoo Query Language, YQL

The Yahoo Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint

Source: http://developer.yahoo.com/yql/

PL/SQL stands for Procedural Language extension of SQL. It is is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL. This language is also implemented as part of other languages like Python http://www.postgresql.org/docs/9.3/static/plpython.html perl http://www.postgresql.org/docs/9.3/static/plperl.html etc http://www.postgresql.org/docs/9.3/stat ... al-pl.html

2. SQL Windows functions.

A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of calculation that can be done with an aggregate function. But unlike regular aggregate functions, use of a window function does not cause rows to become grouped into a single output row — the rows retain their separate identities. Behind the scenes, the window function is able to access more than just the current row of the query result.

Source: http://www.postgresql.org/docs/9.3/stat ... indow.html

See also:

http://tapoueh.org/blog/2013/08/20-Window-Functions

http://hashrocket.com/blog/posts/sql-window-functions

3. Reated links

http://plsql-tutorial.com/

http://plproxy.projects.pgfoundry.org/doc/tutorial.html

http://wiki.postgresql.org/wiki/PL/Proxy

http://pgfoundry.org/projects/plproxy/

http://en.wikipedia.org/wiki/PL/pgSQL

4. Litterature.

http://shop.oreilly.com/product/9780596514464.do

http://www.amazon.com/PostGIS-Action-Re ... 617291390/

http://www.amazon.com/Practical-Postgre ... 0054RCT7Q/

Return to “Databases and SQL”

Who is online

Users browsing this forum: No registered users and 1 guest