This repository has been archived by the owner on Jun 3, 2020. It is now read-only.
Oracle_Built in_single_Row_Function
The Motive of the testing/googling is to identify that Oracle Build-In function (apart from orafce) and operator which are using by Spacewalk are Present/Not Present in PG
The minimum supported version of Postgres is PG 8.1+.
Oracle built-function: Oracle functions http://ist.marshall.edu/ist466/functions.html
Oracle Build in Operator: Other sql/plsql http://www.techonthenet.com/oracle/index.php
| Function Name |
|---|
| ASCII |
|---|
| AVG |
| MAX |
| COUNT |
| CHR |
| CAST |
| TO_NUMBER |
| GREATEST |
| MOD |
| SUM |
| UPPER |
| LPAD |
| OPERATOR NAME |
|---|
| UNION |
|---|
| UNION ALL |
| EXISTS |
| Function Name |
|---|
| ROWID |
|---|
| ROWNUM |
| OPERATOR NAME |
|---|
| MULITSET |
|---|
| MINUS |
| DATA DICTIONARY TABLE |
|---|
| USER_CONSTRAINTS |
|---|
| ALL_CONS_COLUMNS |
| ALL_CONSTRAINTS |
| Pl/sql data type |
|---|
| BINARY_INTEGER |
|---|
*Apart from all above theses,Didn't find any other Function Which are using/not using in Spacewalk.
*Oracle and Postgres Built-in function/operator which are using in Spacewalk are Compatible.
*Spacewalk is using these function's But NOT in a great Extend.
