Trace:
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
jvx:server:db:table_functions [2020/02/25 22:39] admin |
jvx:server:db:table_functions [2020/06/29 13:00] (current) cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
||
---|---|---|---|
Line 1: | Line 1: | ||
~~NOTRANS~~ | ~~NOTRANS~~ | ||
- | ~~Title: Using table functions~~ | + | ~~Title: Using Table Functions~~ |
- | Table functions are a cool thing. Use it to dynamically create records directly in the database with all available database features. Not all database systems support table functions, but Oracle and PostgreSql do. Here's an example for a table function with Oracle. | + | [[https://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dcitblfns.htm|Table or pipelined functions]] are a cool thing. Use them to dynamically create records directly -- without a physical table -- in the database with all available database features. Not all database systems support table functions but Oracle and [[https://postgresrocks.enterprisedb.com/t5/The-Knowledgebase/Oracle-Workaround-PIPELINED/ta-p/152|PostgreSql]] do. Here's an example for a table function with Oracle. |
First, we need the table function: | First, we need the table function: |