-
PL/SQL
like to add or change, feel free. PL/SQL, the Procedural Language for SQL, was first introduced with Oracle SQL*Forms 3.0. Subsequently, after
Page location:
The Official Oracle Wiki > Database > PL/SQL
Keyword tags:
PL/SQL,
PL/SQL Intro
Last updated:
Jun 24 2008, 1:09 PM EDT by
-
Designing PL/SQL apps
Oracle OpenWorld Unconference Session Session Title : Designing PL/SQL apps Facilator : Andrew Clarke Time : 15.00 (guess) Date : Wedsday 13th
Page location:
The Official Oracle Wiki > Oracle OpenWorld > Oracle OpenWorld Unconference > Designing PL/SQL apps
Keyword tags:
design,
pl/sql,
Process Goldfish bowl
Last updated:
Oct 25 2007, 10:58 AM EDT by
-
PL/SQL Best Practices
As in any programming language, good practices help to ensure that code is developed properly and in a maintainable fashion; PL/SQL is no exception
Page location:
The Official Oracle Wiki > Database > PL/SQL > PL/SQL Best Practices
Keyword tags:
best,
methods,
pl/sql,
practices
Last updated:
May 3 2008, 2:53 AM EDT by
-
Oracle OpenWorld Unconference
The Oracle DBA... A dying breed? Accessibility at Oracle How to migrate a DB from fs into ASM Designing PL/SQL
Page location:
The Official Oracle Wiki > Oracle OpenWorld > Oracle OpenWorld Unconference
Keyword tags:
community,
Conference,
OpenWorld Unconference,
openworld07
Last updated:
May 30 2008, 4:40 PM EDT by
-
Example PL/SQL Standard
Naming Standard Names shall be formed as a concatenation of the scope prefix, followed by the data type indicator, then an underline character followed
Page location:
The Official Oracle Wiki > Database > PL/SQL > PL/SQL Best Practices > Example PL/SQL Standard
Keyword tags:
standard
Last updated:
May 3 2008, 3:02 AM EDT by
tomcox
-
Favourite Articles
the backup or reporting load on your primary database. Nov/Dec 2007 Issue: Working with PL/SQL : Sue Harper showcases Oracle SQL Developer and how to edit
Page location:
The Official Oracle Wiki > Oracle Magazine > Favourite Articles
Keyword tags:
oracle magazine articles
Last updated:
May 16 2008, 5:49 PM EDT by
thaunert
-
Generate decision tree rules table
: Oracle 10gR2 and 11gR1 Data Mining Installation: Load as a standard PL/SQL procedure via SQL Plus, SQL Developer, etc. into the Oracle database
Page location:
The Official Oracle Wiki > Database > Oracle Data Mining > Oracle Data Mining Utilities and Experts > Generate decision tree rules table
Keyword tags:
Data Mining,
Decision Tree,
Model Detail,
ODM USER CONTRIBUTED EXPERT
Last updated:
Jan 10 2008, 12:41 PM EST by
-
Portal Error Codes
occurred in pages: ORA-06502: PL/SQL: numeric or value error: character string buffer too small (WWC-44847) (10.1.4+) Oracle Portal upgrades - Self
Page location:
The Official Oracle Wiki > Fusion Middleware > Oracle Portal > Portal Error Codes
Keyword tags:
portal error
Last updated:
Feb 10 2008, 5:54 AM EST by
-
Sample Code Incubator
This section under construction for the purpose of collaborative sample code development. Contributions wanted for PL/SQL , Java , ADF , etc
Page location:
The Official Oracle Wiki > Sample Code Incubator
Keyword tags:
samples,
source
Last updated:
Apr 11 2008, 4:08 PM EDT by
-
QuestionsOnSOA
. Expose PL/SQL as a webservice Scenario: A custom Oracle system is used for back office operations. Now, the business wants to move from
Page location:
The Official Oracle Wiki > QuestionsOnSOA
Keyword tags:
SOA FAQ
Last updated:
Jun 20 2008, 11:31 AM EDT by
-
Oracle Portal
OmniPortlet and WebClipping). However, a production portal site is likely to use custom-built portlets extensively. These can be developed using PL/SQL or Java
Page location:
The Official Oracle Wiki > Fusion Middleware > Oracle Portal
Keyword tags:
portal
Last updated:
May 24 2008, 5:14 AM EDT by
-
Application Express
. The programming language you need if the standard features don't fulfill your needs is PL/SQL . Many existing Oracle developers are moving to APEX
Page location:
The Official Oracle Wiki > Developer Tools > Application Express
Keyword tags:
Apex,
Application Express,
HTMLDB,
pl/sql
Last updated:
Jun 4 2008, 7:59 AM EDT by
-
Designer
desired) and to build applications in Forms and Web PL/SQL (or even in Visual Basic, once). Some organizations have managed to build 100% generated
Page location:
The Official Oracle Wiki > Developer Tools > Designer
Keyword tags:
designer
Last updated:
Dec 3 2007, 7:49 AM EST by
-
Who's in Oracle Magazine
Oracle Magazine columnists include: Mary Ann Davidson , Oracle Chief Security Officer ( blog ) Steven Feuerstein , PL/SQL evangelist Sue Harper
Page location:
The Official Oracle Wiki > Oracle Magazine > Who's in Oracle Magazine
Keyword tags:
davidson,
feuerstein,
harper,
kyte,
muench,
oracle magazine
Last updated:
Dec 7 2007, 1:25 AM EST by
-
Mapviewer integrates with . . .
- Dashboard/Answers How To Document --> pls see Attachment below as well
Page location:
The Official Oracle Wiki > Database > Spatial > Spatial Tools > Mapviewer integrates with . . .
Keyword tags:
ADF,
APEX,
JDeveloper,
Mapviewer,
SDO,
Spatial
Last updated:
Jun 5 2008, 10:46 AM EDT by
-
SQL Model
, assignments, loops, conditions. It is a powerful alternative/complement to PL/SQL. Specially interesting for datawarehousing and sql reporting, the MODEL
Page location:
The Official Oracle Wiki > Oracle OpenWorld > Oracle OpenWorld Unconference > SQL Model
Keyword tags:
database,
sql,
unconference
Last updated:
Nov 17 2007, 12:05 PM EST by
-
SQL Developer
and PL/SQL Developer from Allround Automations. It is a relatively recent entrant into the market and is not as full-featured as the commercial products
Page location:
The Official Oracle Wiki > Developer Tools > SQL Developer
Keyword tags:
developer sql application
Last updated:
Monday, 10:48 PM EDT by
-
Oracle Reports
with pixel precision. Report triggers allow the report developer to specify PL/SQL to be executed at specific points during the execution and formatting
Page location:
The Official Oracle Wiki > Business Intelligence > Oracle Reports
Keyword tags:
reports
Last updated:
May 24 2008, 5:08 AM EDT by
-
Oracle WebCenter
” a JSF application (subject to some limitations, of course). It does not depend on PL/SQL (like Oracle Portal does) and does not support PL/SQL
Page location:
The Official Oracle Wiki > Fusion Middleware > Oracle WebCenter
Keyword tags:
j2ee,
java,
jee,
middle,
middleware,
oracle portal,
portal,
portlets,
soa,
web 2.0,
webcenter
Last updated:
May 24 2008, 5:21 AM EDT by
-
Unicode Enabled Clients
is the only one that can work in a Unicode (UTF8) environment...’ Third Party Software PL/SQL Developer from Allround Automations
Page location:
The Official Oracle Wiki > Developer Tools > Unicode Enabled Clients
Keyword tags:
Unicode
Last updated:
Nov 19 2007, 4:32 AM EST by
|
|