Database & Technology 1 _ Tom Kyte _ Efficient PL SQL - Why and How to Use.pdfInSync2011
油
Thomas Kyte discusses effective techniques for writing PL/SQL code. Some key points:
1) Use PL/SQL for data manipulation as it is tightly coupled with SQL and most efficient.
2) Write as little code as possible by leveraging SQL and thinking in sets rather than loops.
3) Use static SQL where possible for compile-time checking and dependency tracking. Dynamic SQL should only be used when static SQL is impractical.
4) Leverage packages to reduce dependencies, increase modularity, and support overloading and encapsulation.
5) Employ bulk processing techniques like bulk collects to minimize round trips to the database.
A rigorous, online, hands-on training course designed to teach students PL/SQL concepts, constructs and features; develop in them industry best-practices, and enable participants to be fluent and fast PL/SQL developers.
Email me at dwight.cummings@yahoo.com
1. Mac OS X is the operating system developed by Apple Inc. for Mac computers. It is based on UNIX and has similarities to both UNIX and Microsoft Windows.
2. Major versions of Mac OS X include Cheetah, Puma, Jaguar, Panther, Tiger, Leopard, Snow Leopard, Lion and Mountain Lion. Each version brought new features and improvements to the operating system.
3. Key components of the Mac OS X desktop include the Dock, Menu Bar, Launchpad, Mission Control and System Preferences. The Dock contains application icons while Mission Control allows switching between applications and desktop spaces. System Preferences is used to customize settings.
犖犖迦牽犖犖園犖犖迦牽犖萎犖犖犖犖о犢犖∇元犢犖∇検犖犖橿見犖犖園犖犖迦牽犖犖犖萎犖÷鹸犖犖犖犢犖犖
犢犖犖∇犖犢犢犖÷犖犖ム犖犖犖 犖犖犖犖朽絹犖謹犖犖迦検犖犖迦硯犖巌犖∇顕犖ム険犖∇犖犖犖園犖 犖犖園犖犖о険犖犖ム験犖犖迦
A Development of Peer Visit System for Self Assessment
by SECI Model : A Case Study of Nation University
A rigorous, online, hands-on training course designed to teach students PL/SQL concepts, constructs and features; develop in them industry best-practices, and enable participants to be fluent and fast PL/SQL developers.
Email me at dwight.cummings@yahoo.com
1. Mac OS X is the operating system developed by Apple Inc. for Mac computers. It is based on UNIX and has similarities to both UNIX and Microsoft Windows.
2. Major versions of Mac OS X include Cheetah, Puma, Jaguar, Panther, Tiger, Leopard, Snow Leopard, Lion and Mountain Lion. Each version brought new features and improvements to the operating system.
3. Key components of the Mac OS X desktop include the Dock, Menu Bar, Launchpad, Mission Control and System Preferences. The Dock contains application icons while Mission Control allows switching between applications and desktop spaces. System Preferences is used to customize settings.
犖犖迦牽犖犖園犖犖迦牽犖萎犖犖犖犖о犢犖∇元犢犖∇検犖犖橿見犖犖園犖犖迦牽犖犖犖萎犖÷鹸犖犖犖犢犖犖
犢犖犖∇犖犢犢犖÷犖犖ム犖犖犖 犖犖犖犖朽絹犖謹犖犖迦検犖犖迦硯犖巌犖∇顕犖ム険犖∇犖犖犖園犖 犖犖園犖犖о険犖犖ム験犖犖迦
A Development of Peer Visit System for Self Assessment
by SECI Model : A Case Study of Nation University
4. 犖 犖 犖 犖犖 犖 犖犖園 犖 SQL 2008 |4
犖犖伍犖犖÷犖園犖巌犖犖犖迦 : 犖犖迦権犖犖迦牽犖犖о顕犖÷犢 犖犖犖犖迦牽犖犖園犖犖犢犖迦犖犖犖犖迦牽犢 犖犢犖о牽犢 犢犖ム鍵犖犖犖犖犢 犢犖о牽犢 犖犖犖巌犖犖園犖犢犖ム鍵犢犖犖朽権犖犢犖犢
犖劇 犖朽
犖犖迦 SQL Server 2008
1. Framework
犖犖迦牽犖犖巌犖犖園犖 SQL Server 犖犖萎犢犖犖犢犖犢犖犢犖о犖犖犖萎犖犖犖犖犖犖犢犢犖о牽犢 犖犖犖犢犖犢犖犖犖朽
犖
-- NET Framework 3.5
-- SQL Server Native Client
-- SQL Server 犖犖犖園犖犖犖伍犖犖迦牽犖犖巌犖犖園犖犢犖犖ム
2 犖犖犖犖犢 犢犖о牽犢
SQL Server 犖犖迦牽犖犖巌犖犖園犖犖犢犖犖犢犖犢 Microsoft Windows Installer 4.5 犖犖犖 犖犖犖伍 犖犖犖朽犢犖犖÷犖犖о犖迦犖ム鍵 Microsoft Data
Access Components (MDAC) 2.8 SP1 犖犖犖 犖犖犖伍 犖犖犖朽犢犖犖÷犖犖о犖
3 犖犖犖犖犢 犢犖о牽犢 犖犖犢犖犖犖犢 犢犖犢犖
犖
Microsoft Internet Explorer 6 SP1 犖犖犖 犖犖犖伍 犖犖犖朽犢犖犖÷犖犖о犖迦犖犢 犖犖犖巌 犖犖犖迦犖犢 犖犖犖迦見犖犖園犖犖迦牽犖犖巌犖犖園犖犖犖園犖犖犖÷犖犖犖 SQL
Server 2008 Internet Explorer 6 SP1 犖犖犖 犖犖犖伍 犖犖犖朽犢犖犖÷犖犖о犖迦犖犢 犖犖犖巌 犖犖犖迦犖犢 犖犖犖迦見犖犖園 Microsoft Management
Console (MMC), SQL Server Management Studio, Business Intelligence Development Studio,
犖犢 犖о犖犖犖萎犖犖 Designer 犖犖迦権犖犖迦犖犖ム犖迦牽犖犖迦権犖犖迦犖犖ム犖迦牽犖犖犖 犖犖迦牽犢犖ム鍵犖犖о顕犖÷犢犖о権犢犖犖ム厳犖 HTML
4 犖犖迦牽犢犖犖犖犖犖
SQL Server 2008 犢犖犖犖劇 犖犖犖÷厳犖犖犖朽犖犖迦犖犢 犖犖犢犖犖犢犖犢犖犖犖迦犖 犖犖犖о顕犖÷献犖萎犖犖朽権犖 VGA 犖犖犖 犖犖犖 犖犖犖о犖 : 犖犖о顕犖÷献犖萎犖犖朽権犖
犖犖∇犖迦犖犢犖犖 1,024 768 犖犖巌犢犖犖
5. 犖 犖 犖 犖犖 犖 犖犖園 犖 SQL 2008 |5
犖犖迦見犖犖園犖犖迦牽犖犖巌犖犖園犖 SQL Server 2008
1 Processor :
犖
犖犖犖巌 Processor : Pentium III 犢犖犢犖迦犖園犢犖犢犖犖犖犖犢犖о権犖犖犖萎検犖о献犖犖ム見犖犖 犖犢犖犢 犖о犖о犖
犖犖о顕犖÷犖犢 犖 Processor : 犖犖園犖犖犢犖 : 1.0 GHz, 犢犖犖萎犖 : 2.0 GHz 犖犖犖 犖犢犖犢 犖о犖о犖
2 犖犖萎犖犖犖蹩巌犖園犖巌犖迦牽 : Windows XP Professional SP2
Windows XP SP2 Tablet
Windows XP SP2 Media Center 2002
Windows XP SP2 Media Center 2004
Windows XP Media Center 2005
Windows XP Professional Reduced Media
Windows Server 2003 Small Business Server R2 Standard
Windows Server 2003 Small Business Server R2 Premium
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Data Center
Windows Server 2003 Small Business Server SP2 Standard
Windows Server 2003 Small Business Server SP2 Premium
Windows Server 2003 SP2 64-bit x64 Standard
Windows Server 2003 SP2 64-bit x64 Data Center
Windows Server 2003 SP2 64-bit x64 Enterprise
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Vista 64-bit x64 Ultimate
Windows Vista 64-bit x64 Home Premium
Windows Vista 64-bit x64 Home Basic
Windows Vista 64-bit x64 Enterprise
Windows Vista 64-bit x64 Business
Windows Server 2008 Standard (with and without Hyper-V)
6. 犖 犖 犖 犖犖 犖 犖犖園 犖 SQL 2008 |6
Windows Server 2008 Web
Windows Server 2008 Data Center
Windows Server 2008 Data Center without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Server 2008 x64 Standard
Windows Server 2008 x64 Standard without Hyper-V
Windows Server 2008 x64 Data Center
Windows Server 2008 x64 Data Center without Hyper-V
Windows Server 2008 x64 Enterprise
Windows Server 2008 x64 Enterprise without Hyper-V
3 犖犖犢 犖о権犖犖о顕犖÷犖
RAM
犖犖園犖犖犢犖 : 512 MB
犢犖犖萎犖 : 2.048 GB 犖犖犖 犖犖÷顕犖犖犖о犖
犖犖 犖犖犖 犖 : 犖犖 犖犖犖 犖犖犖犖犖犖萎犖犖犖蹩巌犖犖巌犖迦牽
犖
4 犖犖伍犖ム険犖犖犖犖萎犖ム鍵犖犖迦牽犢犖犢 犖犖犖犖朽 Disk :
犖劇
Engine 犖犖迦犖犢犖犖÷弦犖ム犖ム鍵犢犖犢 犖÷犢犖犖÷弦犖, Replication, 犢犖ム鍵犖犢犖犖犖о顕犖÷犖犖犢犖犢犖÷犢犖犖犖 : 280 MB
犖犖犖 犖犖迦牽犢犖ム鍵犖犖迦牽犖о鹸犢犖犖犖迦鍵犖犢犢犖犖ム犖犖犖÷弦犖 : 90 MB
犢
犖犖犖 犖犖迦牽犖犖迦牽犖犖迦権犖犖迦犢犖ム鍵犖犖迦牽犖犖迦権犖犖迦 : 120 MB
犖犖犖 犖犖迦牽 Integration : 120 MB
Client Components : 850 MB
犖犖犖園犖犖 犖 SQL Server Books Online 犢犖ム鍵 SQL Server Compact Online : 240 MB
11. 犖 犖 犖 犖犖 犖 犖犖園 犖 S Q L 2 0 0 8 | 11
2. 犖犖ム鹸犖犢犖ム厳犖犖犖犖犖 犖犖園硯犖犢犖犖犖朽犖犖犖 犖犖劇賢 Installation 犢犖犖劇犖犢犖犢犖迦肩犖項 犖犖犢犖迦犢犖迦犖犖朽 犢犖ム犖о犖犢犖犖ム鹸犖犖犖迦犖犖園硯犢犖犖 ... New SQL
Server stand-alone .. 犢犖犖劇犖犖犖迦犖迦牽犖犖巌犖犖園犖犢犖犖犢犖犖犖÷犖犖園
- 犖犢犖迦犖÷犢犖犖∇献犖犖÷顕犖犢犖犖犢犖犢犖犖 NEW SQL Server stand-alone installation or add features to an
existing installation 犖犖犖園
- 犖犢犖迦犖犖∇献犖 SQL Server 2000 犖犖犖 犖 2005 犖÷顕犢犖ム犢犖犢犖犖 Upgrade from SQL Server 2000 or SQL
Server 2005 犖犖犖園
19. 犖 犖 犖 犖犖 犖 犖犖園 犖 S Q L 2 0 0 8 | 19
10. 犖犖園犖犖犖犖犖犖朽犢犖犢 犖犖犖園犖犖犖犖犖犖迦牽犖犖迦見犖犖 user 犖犖迦見犖犖園 service 犖犢犖迦 犢 犖犢犢犖ム厳犖犖犢犖犖迦犖犖犖犖犖園犖о犖迦犖萎賢犢犖迦犖犖巌 service
犖
犖犢犖迦 犢 犢犖о犖犖 user 犢犖犖 犢 犖犢犖迦犖÷犖犖項犖犖萎犖犢 user 犢犖犖犖犢犖犖迦犖犖巌 user network service 犖犖犖園 犢犖犖犖迦鍵犢犖犢 犖 user
犢
犖犖劇犖犖犖迦犖犖犖 Windows 犖犖迦見犖犖園犖犖迦牽犖犢犖迦犖犖巌 service 犖犢犖迦 犢 犖犖 Next 犢犖犢犢犖ム権犖犖園
20. 犖 犖 犖 犖犖 犖 犖犖園 犖 S Q L 2 0 0 8 | 20
11. 犢犖ム厳犖犖犖犖迦県犖迦犖犖園犢犖犖犖朽犖犖朽犖犖÷犖ム厳犖犖犖犖迦県犖迦犖犖∇犖園 犖犖 Next 犢犖犢犢犖ム権犖犖園
21. 犖 犖 犖 犖犖 犖 犖犖園 犖 S Q L 2 0 0 8 | 21
12. 犖犖萎犖犖犖園犖犖迦犖о顕犖÷犖ム賢犖犖犖園権 犖犖劇賢 犖犢犖迦犖犖迦犖犢 mix mode 犖犖犖犖犖迦犖犖萎犖迦見犖犖犖犖犖園肩犖犢犖迦犖犖犖 sa 犢犖ム犖о犖犖迦犢犖犖
犖犖迦見犖犖 local user 犢犖犖劇犖犢犖犢 犖 admin 犖犖謹犖犖犖迦検犖迦牽犖犢犖犢犖迦犖謹 database engine 犢犖犢犖犖犖園