![]() Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.ĭBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. ![]() For information about which versions have been released, see the. It may include documentation of features of MySQL versions that have not yet been released. Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution It documents MySQL 8.0 through 8.0.32, as well as NDB Cluster releases based on version 8.0 of NDB through 8.0.29-ndb-8.0.30, respectively. ![]() Methods for DBAs to improve query and database performance with cursors and table functions.Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE) Row-Level Security(RLS), Fine-Grained Auditing (FGA) and random value generation.A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running.Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains: Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur. Predefined RDBMS sites are no longer distributed in file defaultRDBMSSites.xml and will be removed from existing versions of that file.PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years.Engine need to be changed in existing scripts. It’s replaced with “Oracle Nashorn” scripting engine. Oracle SQL Developer is a graphical version of SQLPlus that gives database administrators a convenient way to perform basic tasks involving schema objects. “Mozila Rhino” script engine is not distributed with JVM any more.What has changed? Some things from the release notes ( ): Mandatory fields being reset to optional – model in single file mode Unicode characters in domain definition are changed when save/reopen SVN – processing of outgoing changes is too slow Table to view wizard to copy column comments in rdbms to view column Journal trigger ddl refers to arbitrary “emp2” table instead of generated table Not possible to populate the supertype table without having to populate subtypes Grant flashback on an oracle table not supportedĭomain can’t be locked without opening design ![]() Missing check constraint ddl (arc constraint) during merge Interactive DDL for automatically generated Indexes contains an invalid semi-colonĭifferent formatting causes Table Check Constraint to be marked as changed This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.1. If you have not downloaded it yet, this is the place to do it: Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast! The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |