Blogmarks.net : Public marks from user ms

Recompiling Invalid Schema Objects

Supprimer tous les objets d'un schéma Oracle

Les fonctions analytiques

Permettent d'appliquer une fonction (somme, moyenne...) à un ensemble de lignes définies par rapport à la ligne courante ce qui permet de calculer aisément des sommes cumulées, des moyennes mobiles et d'accéder aux valeurs de la ligne précédente...

oracle

A Simple Example of Oracle Analytics: Running Totals


Analytic_Fuction(«Any-Legal-Expression usually just a column»)
over (
  «Partition-By-Clause»
  «Order-By-Clause»
)

oracle

Les vues matérialisées (Materialized Views)

by 1 other

Une vue matérialisée (VM) est un moyen simple de créer une vue physique d'une table. Comme son nom l'indique et à la différence d'une vue standard, les données sont dupliquées. On l' utilise à des fins d'optimisation de performance, lorsque le select associé est particulièrement complexe ou lourd, ou pour faire des réplications de table.

oracle

Re-writing Oracle subqueries for faster performance

oracle database

EnterpriseDB

by 1 other (via)

For applications that require Oracle to even function properly, consider EnterpriseDB, a version of PostgreSQL, which has reimplemented features such as data types, triggers, views and cursors that copy Oracle's behavior.

database oracle postgresql

Oracle SQL Developer

by 2 others , 1 comment (via)

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.

database oracle

SQL Function Reference: SQL Server vs. Oracle

by 1 other (via)

oracle sqlserver

Piper

by 1 other (via)

Piper is an SQL and PL/SQL Processor for Oracle. Piper is a powerful but easy-to-use Oracle SQL and PL/SQL tool for Windows (98,NT,2000,XP). It has many productivity features that make it useful to experienced Oracle PL/SQL developers and to anyone who needs to enter commands against their Oracle database.

oracle

ASP.NET Web Project Generator on Oracle Schema

This tool generates .ASPX, .CS files for a given Oracle Database Schema. It identifies the relations between database objects, designs ASP.NET pages, generates the server side code which includes Error checking and JavaScript Menus with complete navigation. It identifies the referential integrities

.net database oracle