Oracle 数据库 11 g 中的 PL/SQL 增强功能

[复制链接]
查看11 | 回复9 | 2014-2-19 11:55:14 | 显示全部楼层 |阅读模式
http://search.oracle.com/search/ ... +Technology+Network
http://www.oracle.com/technology ... ql_new_in_11gr1.pdf
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
我10g还没学好,11G又出来了。
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
谢谢,...
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
谢谢!!!
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层



回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
Thanks.
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
Oracle 11g PL/SQL New Features
PL/SQL "continue" keyword - This will allow a C-Like continue in a loop, to bypass any "else" Boolean conditions.A nasty PL/SQL GOTO is no longer required to exit a Boolean within a loop.

Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects).

Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham

Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL.

Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman

Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a warning for a "when others" with no raise.

Stored Procedure named notation - Named notation is now supported when calling a stored procedure from SQL.
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
3k
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
在学习中进步///
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
昨天 刚装上的11g。。现在还没有发现什么??正在研究学习中
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行