社区
基础和管理
帖子详情
必须在使用 PL/SQL 之前创建 DBMS_STANDARD?
xiayule
2004-07-08 10:27:53
oracle 8.1.6.0 安装完之后,登陆sql plus 怎么有这个提示阿
必须在使用 PL/SQL 之前创建 DBMS_STANDARD?
oracle新手,thks!
...全文
82
2
打赏
收藏
必须在使用 PL/SQL 之前创建 DBMS_STANDARD?
oracle 8.1.6.0 安装完之后,登陆sql plus 怎么有这个提示阿 必须在使用 PL/SQL 之前创建 DBMS_STANDARD? oracle新手,thks!
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
2 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
ytnice
2004-07-12
打赏
举报
回复
up
dinya2003
2004-07-09
打赏
举报
回复
这应该是数据库的事,安装好了就有了.
pl
sql
dev12.0.4.1826x64主程序+ v12中文包+keygen
64位版本的
PL
SQL
正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为
PL
SQL
程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不习惯的建议不要更新。 部分插件会加载失败。 New features Ribbon User Interface
PL
/
SQL
Developer now uses a new Ribbon User Interface instead of a Menu User Interface: The Quick Access Toolba
pl
sql
dev12.0.6.1832x32主程序+ v12中文包+keygen
32位版本的
PL
SQL
正式版, 安装中文包时请注意安装路径是否为
PL
SQL
程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不习惯的建议不要更新。 部分插件会加载失败。 keygen生成注册码非100%有效~~请多尝试几次 New features Ribbon User Interface
PL
/
SQL
Developer now uses a new Ribbon User Interface instead of a Menu User Interface: The Quick Access Toolbar above the ribbon contains the most frequently used functions, so that they are always immediately available. You can customize the Quick Access Toolbar to your own liking. Users that prefer a menu-like system to preserve screen real estate can select to automatically hide the ribbon. In the preferences you can select an option to revert to the familiar toolbar layout from
PL
/
SQL
Developer 11.0 and earlier. Single Document Interface On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multi
pl
e Document Interface (MDI - the same as in
PL
/
SQL
Developer 11.0 and earlier). In SDI mode you always see just one maximized window. A tab control above the window allows you to quickly switch between the windows: General User Interface Enhancements
PL
/
SQL
Developer is now fully com
pl
iant with High-DPI screens such as 4K monitors and notebooks. All controls and images will scale with resolution (some
Pl
ug-Ins may still need to be enhanced). Click on the image below to enlarge this exam
pl
e of a 15" 4K notebook (250% DPI): All window types now have a specific icon color, so that you can quickly identify the type in the Window List, in the SDI tab control, in the window titles, and so on. The transaction status is now visible in the status bar of a window, next to the "Saved" and "Executing" indicators. Added user interface preference "Preselect current user for object selection lists".
PL
/
SQL
Clipboard The new
PL
/
SQL
Clipboard is a dockable tool that stores the history of all
SQL
and
PL
/
SQL
code you copy to the Windows clipboard, so that you can paste the clipboard item again in the future. It has a filter function so that you can quickly find a clipboard item based on its contents: At the bottom you see the
PL
/
SQL
Clipboard history items. Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor location of the current editor or drag & drop it to a specific location in an editor. You can use the editor preferences to configure when and how items are added to and deleted from the
PL
/
SQL
Clipboard. Debugger Enhancements You can now dis
pl
ay compound variable values such as user-defined types, records and cursors: Support has been added for Error Breakpoints, which allow you to break execution when a specific exception (handled or unhandled) occurs: Breakpoints can now be saved and loaded. Debug object privileges can now be granted and revoked from the user interface. Code Assistant Enhancements The Code Assistant can now include column names from a DML statement context without using an alias: The Code Assistant can now describe sub-records. The Code Assistant now includes an
choice for default object type constructors. The Code Assistant can now include synonyms for user object lists. The Code Assistant no longer pre-selects
after typing part of a parameter/column name.
SQL
Window Enhancements A new preference has been added: "Null value cell color for mandatory columns". This allows you to quickly identify mandatory columns when adding new records: The result set selection can now be copied as an expression list: "column in (value, value, ...)" by right-clicking on a selection and selecting "Copy as expression list" from the popup menu. This allows you to quickly build a where clause based on the selection: When viewing or editing LOB's the contents for common data formats will automatically be recognized, so that an external viewer or editor can be invoked: Changes made and saved in an external editor will automatically be propagated to the column data. The
SQL
Window will now navigate to the offending cell in the result set after an insert or update with a column-specific error. The rowid column is now omitted when exporting a result set grid in
SQL
format. Test Window Enhancements You can now define
Standard
Tests for a specific function or procedure: A
Standard
Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a
PL
/
SQL
source: The Test Window now supports Oracle12c im
pl
icit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save
dbms
_output to a file. The filename can include
3天掌握
SQL
Server 2012 数据库
SQL
Server是由Microsoft开发和推广的关系数据库管理系统(
DBMS
),Microsoft
SQL
Server 2012 是一个全面的数据库平台,
使用
集成的商业智能 (BI)工具提供了企业级的数据管理。Microsoft
SQL
Server 数据库引擎为...
pl
sql
dev12.0.6.1832x64主程序+ v12中文包+keygen
64位版本的
PL
SQL
正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为
PL
SQL
程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不习惯的建议不要更新。 部分插件会加载失败。 keygen生成注册码非100%有效~~请多尝试几次 New features Ribbon User Interface
PL
/
SQL
Developer now uses a new Ribbon User Interface instead of a Menu User Interface: The Quick Access Toolbar above the ribbon contains the most frequently used functions, so that they are always immediately available. You can customize the Quick Access Toolbar to your own liking. Users that prefer a menu-like system to preserve screen real estate can select to automatically hide the ribbon. In the preferences you can select an option to revert to the familiar toolbar layout from
PL
/
SQL
Developer 11.0 and earlier. Single Document Interface On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multi
pl
e Document Interface (MDI - the same as in
PL
/
SQL
Developer 11.0 and earlier). In SDI mode you always see just one maximized window. A tab control above the window allows you to quickly switch between the windows: General User Interface Enhancements
PL
/
SQL
Developer is now fully com
pl
iant with High-DPI screens such as 4K monitors and notebooks. All controls and images will scale with resolution (some
Pl
ug-Ins may still need to be enhanced). Click on the image below to enlarge this exam
pl
e of a 15" 4K notebook (250% DPI): All window types now have a specific icon color, so that you can quickly identify the type in the Window List, in the SDI tab control, in the window titles, and so on. The transaction status is now visible in the status bar of a window, next to the "Saved" and "Executing" indicators. Added user interface preference "Preselect current user for object selection lists".
PL
/
SQL
Clipboard The new
PL
/
SQL
Clipboard is a dockable tool that stores the history of all
SQL
and
PL
/
SQL
code you copy to the Windows clipboard, so that you can paste the clipboard item again in the future. It has a filter function so that you can quickly find a clipboard item based on its contents: At the bottom you see the
PL
/
SQL
Clipboard history items. Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor location of the current editor or drag & drop it to a specific location in an editor. You can use the editor preferences to configure when and how items are added to and deleted from the
PL
/
SQL
Clipboard. Debugger Enhancements You can now dis
pl
ay compound variable values such as user-defined types, records and cursors: Support has been added for Error Breakpoints, which allow you to break execution when a specific exception (handled or unhandled) occurs: Breakpoints can now be saved and loaded. Debug object privileges can now be granted and revoked from the user interface. Code Assistant Enhancements The Code Assistant can now include column names from a DML statement context without using an alias: The Code Assistant can now describe sub-records. The Code Assistant now includes an
choice for default object type constructors. The Code Assistant can now include synonyms for user object lists. The Code Assistant no longer pre-selects
after typing part of a parameter/column name.
SQL
Window Enhancements A new preference has been added: "Null value cell color for mandatory columns". This allows you to quickly identify mandatory columns when adding new records: The result set selection can now be copied as an expression list: "column in (value, value, ...)" by right-clicking on a selection and selecting "Copy as expression list" from the popup menu. This allows you to quickly build a where clause based on the selection: When viewing or editing LOB's the contents for common data formats will automatically be recognized, so that an external viewer or editor can be invoked: Changes made and saved in an external editor will automatically be propagated to the column data. The
SQL
Window will now navigate to the offending cell in the result set after an insert or update with a column-specific error. The rowid column is now omitted when exporting a result set grid in
SQL
format. Test Window Enhancements You can now define
Standard
Tests for a specific function or procedure: A
Standard
Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a
PL
/
SQL
source: The Test Window now supports Oracle12c im
pl
icit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save
dbms
_output to a file. The filename can include
Direct Oracle Access 4.1.2 Full Source for Delphi 2010
If you use Delphi or C++Builder to access an Oracle database, this component set can make your life a lot easier. With the Direct Oracle Access components and objects you access an Oracle database directly, skipping the Borland Database Engine, only using
SQL
*Net. This gives you the following advantages: w No distributing, installing and configuring the BDE. You can use any 32 bits Delphi or C++Builder version to develop Client/Server ap
pl
ications w No BDE overhead or tradeoffs: your queries will run up to five times faster w Automatic Master/Detail configuration w Automatically enforce server-constraints on the client w Make use of server generated values (defaults, trigger modified columns) w Query By Exam
pl
e mode for high performance queryable forms without any programming w Use
PL
/
SQL
blocks for server logic in your ap
pl
ication w Increase batch performance with Array DML or Direct Path Loading w Easily execute
SQL
scripts similar to
SQL
*
Pl
us through the TOracleScript component w Monitor database access information with the Oracle Monitor utility w Access your stored packages easily through the TOraclePackage component or the Package Wizard w Encapsulation of
standard
Oracle packages (
dbms
_alert,
dbms
_job, utl_file, ...) w Many Oracle specific features supported w Compatible with
SQL
*Net 1 thru Oracle Net 9, and with Personal Oracle Lite thru Oracle9i
基础和管理
17,377
社区成员
95,128
社区内容
发帖
与我相关
我的任务
基础和管理
Oracle 基础和管理
复制链接
扫一扫
分享
社区描述
Oracle 基础和管理
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章