why nobody uses Oracle’s PL/SQL language
Oracle is probably the best database of the world. And it’s the market leader also. Oracle has it’s on procedural […]
Oracle is probably the best database of the world. And it’s the market leader also. Oracle has it’s on procedural […]
A design patterns overview at SERPland.com Design Patterns description [wiki:en/de]
As I did with the Template Method Design Pattern I also tried to implement the “Decorator” Design Pattern in Oracle’s
Oracle: Trying to use a package via db-link ends in a ORA-04052 ! Deutsch/German ORA-04052 Error ORA-04052: Fehler beim Aufsuchen
Design Patterns are great! The Template Method Pattern can also be implementet with Oracle’s PL/SQL language using clean Object Types (object oriented – inheritance). Here is my pl/sql sample.
Numeric Datatypes in Oracle are mostly subtypes of the NUMBER datatype. uml inheritance diagram: oracle numeric datatypes Oracle SQL datatypes:
——————————————————————————– — sys.anydata.sql ——————————————————————————– — Using the ANYDATA object — Startin with Oracl9i and up, ANYDATA is described — by
Let’s think we write a select statement and would like to DECODE (on Oracle database) on a column: DECODE(bew.bewart_tid, ‘GDL’,
You have a simple sql statement like this: select machine, count(*) as users from v$session group by machine This query
Enable SQL Trace for my own single session: ALTER SESSION SET SQL_TRACE = TRUE; Or use a pl/sql program instead: