社区
基础和管理
帖子详情
about oracle functions !
JasLi
2003-02-27 01:32:59
I need more info about oracle functions' description document !
could you provide some ?
...全文
51
2
打赏
收藏
about oracle functions !
I need more info about oracle functions' description document ! could you provide some ?
复制链接
扫一扫
分享
转发到动态
举报
AI
作业
写回复
配置赞助广告
用AI写文章
2 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
JasLi
2003-02-28
打赏
举报
回复
thank you ! Xiao Beck !
beckhambobo
2003-02-27
打赏
举报
回复
看书吧,
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#998166
Pro
Oracle
SQL
Pro
Oracle
SQL unlocks the power of SQL in the
Oracle
Dat
ab
ase—one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that
Oracle
provides to help use the language effectively, and learn to think and work in sets., , Karen Morton and her team help you master powerful aspects of
Oracle
SQL not found in competing dat
ab
ases. You’ll learn analytic
function
s, the MODEL clause, and advanced grouping syntax—techniques that will help in creating good queries for reporting and business intelligence applications. Pro
Oracle
SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your dat
ab
ase. You’ll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You’ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions., , What’s the bottom-line? Pro
Oracle
SQL helps you work at a truly professional level in
Oracle
dialect of SQL. You’ll master the language, the tools to work effectively with the language, and the right way to think
ab
out a problem in SQL. Pro
Oracle
SQL helps you rise
ab
ove the crowd to provide stellar service in your chosen profession. Endorsed by the OakT
ab
le Network, a group of
Oracle
technologists well-known for their rigorous and scientific approach to
Oracle
Dat
ab
ase performance Comprehensive – goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. What you'll learn Master powerful SQL features implemented only in
Oracle
Dat
ab
ase Read and interpret SQL execution plans Quickly diagnose and fix badly performing SQL Control execution plans through hints, profiles, and plan baselines Optimize queries within packaged applications without touching the code Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro
Oracle
SQL is aimed at developers and dat
ab
ase administrators who submit SQL for execution by an
Oracle
dat
ab
ase. Readers should already know the basic four SQL statements, and be ready to learn deeply
ab
out
Oracle
’s specific implementation of the language, including
Oracle
-specific features and syntax. Readers should also want to learn
ab
out
Oracle
Dat
ab
ase features such as analytic queries, the MODEL clause, and subquery refactoring that are designed to help developers and DBAs exert control over their SQL environment and its execution.
Oracle
Core Essential Internals
Since this book is only a couple of hundred pages and the 11g manuals extend to tens of thousands of pages it seems unlikely that I could possibly be describing “the whole thing ” so let me qualify the claim The book is
ab
out the core mechanics of the central dat
ab
ase engine the bit thatdrives everything else; essentially it boils down to undo redo data caching and shared SQL Even then I’ve had to be ruthless in eliminating lots of detail and interesting special cases that would make the book too long turgid and unread
ab
le Consider for example the simple question: How does
Oracle
do a logical I O then take a look at structure x$kcbsw which is a list of all the
function
s that
Oracle
might call to visit a block You will find for 11 2 0 2 that there are 1 164 different
function
s for doing a logical I O do you really want a detailed breakdown of all the options or would a generic description of the common requirements be sufficient ">Since this book is only a couple of hundred pages and the 11g manuals extend to tens of thousands of pages it seems unlikely that I could possibly be describing “the whole thing ” so let me qualify the claim The book is
ab
out the core mechanics of the central dat
ab
ase engine the bit thatdr [更多]
最完整的Toad For
Oracle
使用手册
1073页啊,够爽吧: Introduction 15 New in This Release 15 Introduction to Toad 23 DB Admin Module 24 Toad and
Oracle
Enterprise Manager 29 Quick Search Bar 30 Additional Resources 31 Working with other Quest Products 32 Knowledge Xpert 32 Using SQL Optimizer with Toad 32 Benchmark Factory 33 Quest Code Tester Integration 35 Toad Basics 37 Toad Tips 37 Errors 37 RAC Support 37 Task Bar & Status Bar 38 Toolbars, Menus and Shortcut Keys 40 Installation and Administration of Toad 64 Window Privileges and Toad 64 Toad for
Oracle
, Read-Only 64 Registering Toad 65 Silent Installation 66 Group Policy Management 71 Citrix Support 71 SQL*Net Versions 72 Configuration Files 73 Server Side Objects Installation 93 Connecting to
Oracle
97 Server Login Window 97 Create New Connection 99 Selecting Connection Color 101 SET ROLE 101 Auto Connect 103 Save Passwords for Connections 104 Select and View Favorite Connections 104 Organize your login display 105 Use Existing Connection 106 SQLNET Editor 106 LDAP Editor 107
Oracle
Homes 108 TNSNames Editor 111 Tutorials 119 CodeXpert 119 PL/SQL Debugger 121 SQL*Loader 140 Team Coding 158 RMAN Templates 164 RMAN Scripts in Toad 164 Working with RMAN Templates 164 Executing RMAN Scripts from Toad 165 Comparing 166 Data Duplicates 166 Compare Single Objects 166 Comparing Dat
ab
ases 167 Comparing Data 174 Compare Files (Difference Viewer) 176 Comparing Schemas 180 Controlling Sessions 188 Select Session 188 End Connections 188 Test Connections 188 Configure User Lists 188 Session Information 189 Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space Deficits 193 Log Switch Frequency Map 194 T
ab
lespace Map 194 TKProf Interface Wizard 196 Undo Advisor 198 Segment Advisor 200 LogMiner Interface 203 Health Check 207 Trace File Browser 226 CodeXpert 231 Dat
ab
ase Administration 259 Audit SQL/Sys Privs 259 NLS Parameters 260 Toad Features Security 260 ASM Manager 263 Audit Objects 269 Multiple Object Privileges 270
Oracle
Parameters 272 T
ab
lespaces 274 Redo Log Manager 282 Importing and Exporting Data 285 Data Pump 285 Export Dataset 304 Export DDL 310 Export File Browser 318 General Export 324 General Import 329 Generate Dat
ab
ase Script 341 Generate Schema Script 342 Managing Projects 346 Using Automation Designer to Control Toad 346 Project Manager 387 Query Viewer 416 SQL Command Recall 418 Script Manager 419 Monitoring 431 Toad Server Statistics 431 SQL Monitor 432 Toad UNIX Monitor 432 ADDM/AWR 434 Dat
ab
ase Browser 446 Dat
ab
ase Monitor 449 Dat
ab
ase Probe 453 Index Monitoring 458 Instance Manager 460 Session Browser 466 SGA Trace/Optimization 483 StatsPack Browser 486 Top Session Finder 495 Optimizing (Tuning) 499 DBMS_REDEFINITION Wizard 499 Estimate Index Size 500 Estimate T
ab
le Size 501 Explain Plan 503 Pinned Code 504 Repair Chained Rows 505 Rebuild T
ab
le 506 Unix Kernel Parms 507 Windows Registry Parms 508 Analyze All Objects 509 Profilers 512
Oracle
Tuning 523 Rebuild Multiple Objects 525 Options 535 Formatting Options 535 Toad Options 536 Language Management 603 Printing 620 Printing 620 Print Grid 620 Report Link Designer 620 Reporting 623 Toad Control Files 623 Dependencies 624 ER Diagrams 624 Explain Plans 631 Code Road Map 636 HTML Schema Doc Generator 641 Master/Detail Browser 643 Reports Manager 648 Reporting from Data Grids 655 Spool SQL 659 Spool SQL 659 Utilities 660 Archive 660 Wrap Code 660 Service Manager 661 External tools 662 FTP 665 Java Manager 668 Network Utilities 672 Task Scheduler 676 Unix Job Scheduler 678 Source Control and Team Coding 693 Support for Version Control Products 693 Third Party File Based Source Control 694 Team Coding 697 Status in the Editor Status Bar or Team Coding Viewer Status Column 707 Detailed File Properties 708 Checking Objects and Scripts in and out 709 Using Automatic Check-in and Automatic Check-out 709 Manually check-in or check-out 709 Entering Comments on Check in or out 710 Check In All 711 Undo Checkout 712 Freezing an Object 713 TC Locks not selected 726 TC Locks selected 726 Working from the Command Line 738 Command Line Syntax 738 Converting Old Settings Files to Actions 743 Command Line Passwords 744 Export T
ab
les, Views, SQL Queries from the Command Line 744 Run Analyze Objects from the Command Line 745 Run CodeXpert from the Command Line 750 Running Actions from the Command Line 751 Run Compare Dat
ab
ases from Command Prompt 754 Run Compare Schemas from a Command Prompt 757 Run Copy to another Schema from Command Prompt 757 Run Generate Dat
ab
ase Script from a Command Prompt 758 Run Generate Schema Script from Command Line 760 Run Rebuild Objects from the Command Prompt 762 Run Reports Manager from the Command Line 766 Using Vari
ab
les 768 Using Vari
ab
les 768 Working with Code 769 Editor 769 Debugging 819 Query Builder 851 Working with Data 861 Column Names Supported 861 Graph Properties 861 OPS$ Accounts 861 Viewing or Hiding Docked Windows 862 Viewing Source Surrounding a PL/SQL Error 863 Dataset Operations 864 Data Grids 866 DBMS Output 881 Finding Data 883 Generate Test Data 890 Working with Dat
ab
ase Objects 896 Schema Browser Overview 896 Auto-Refreshing the Datagrid 897 Icon Legend 898 Privileges 898 Schema Browser Toolbars 899 Statement Processing 900 Create Objects in Another Schema 900 Personalizing the Schema Browser 900 General Schema Browser Actions 903 Browser Filters 907 Clusters 912 Constraints 914 Contexts 917 DB Links 918 Dimensions 920 Directories 921 Favorites 923 Flashback Archives 924
Function
s 926 Indexes 928 Invalid Objects 929 Java 931 Jobs 933 Libraries 936 Materialized Views (Snapshots) 938 Materialized View (Snapshot) Logs 940
Oracle
Scheduler 941 Packages 953 Policies 955 Policy Groups 956 Procedures 957 Profiles 959 Queue T
ab
les 960 Queues 964 Recycle Bin 966 Refresh Groups 968 Resource Consumer Groups 970 Resource Plans 972 Roles 974 Rollback Segments 975 Sequences 977 Synonyms 978 System Privileges 980 T
ab
les 981 T
ab
lespaces 996 Triggers 1002 Types 1004 Users 1010 Views 1012 Troubleshooting 1017 Unicode Troubleshooting 1017 Hints and Tips: Connecting To Personal
Oracle
1018 Hints and Tips: T
ab
le Does Not Exist Errors 1019 Create Support Bundles 1019 Toad Advisor 1019 Contact Quest 1021 Contact Quest Support 1021 Contact Quest Software 1021
Ab
out Quest Software, Inc 1021 Appendix: Contact Quest 1022 Contact Quest Support 1022 Contact Quest Software 1022
Ab
out Quest Software, Inc 1022 Index 1023
Actualtests
Oracle
Oracle
学习资源,对于初学者是个不错的帮助资料。
McGraw.Hill.
Oracle
.Dat
ab
ase.11g.PL.SQL.Programming.Mar.2008
This book is designed to be read from beginning to end by those new to
PL/SQL. Part I covers PL/SQL fundamentals. Part II covers the backbone
of the programming language, which consists of
function
s, procedures,
packages, triggers, and large objects. Part III dives into some advanced
topics that should help you immediately with your development projects.
The appendixes in Part IV provide primers on
Oracle
DBA tasks, SQL programming,
PHP scripting, Java development, regular expressions, and wrapping PL/SQL. Introductory
primers are provided to help you learn
ab
out the PL/SQL Hierarchical Profiler and PL/Scope.
There is also an appendix that reviews reserved words and built-in
function
s that support
your programming tasks.
基础和管理
17,382
社区成员
95,118
社区内容
发帖
与我相关
我的任务
基础和管理
Oracle 基础和管理
复制链接
扫一扫
分享
社区描述
Oracle 基础和管理
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章