Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle by Charlie Russel

By Charlie Russel

Such a lot Oracle DBAs spend the vast majority of their time every day doing pretty well an analogous issues they do another day, that's nice, on the grounds that they do not have any challenge remembering the syntax and instructions they need to take advantage of. yet for the remainder of their time, they're doing whatever they might purely do as soon as each few months -- and that is the time they want support. no longer from an important tutorial guide, or awkward on-line documentation -- they've got lots of either and should use them once they have to. What DBA's actually need is a straightforward, small, unmarried quantity speedy reference that might remind them of the syntax and suggestions of a command they hardly use, or provide them a brief reminder of the on hand perspectives and tables that make up a DBAs existence.

Show description

Read or Download Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle Series) PDF

Similar oracle books

Object-Oriented Oracle

Describes complete and basic points of object-oriented information modeling and implementation in Oracle. It discusses the full cycle of database layout utilizing object-oriented options, implementation of object-relational Oracle, and knowledge manipulations utilizing member procedures/functions and object-relational queries.

Beginning PHP and Oracle: From Novice to Professional , 1st Edition

Starting Hypertext Preprocessor and Oracle: From beginner to expert bargains entire details on utilizing the Hypertext Preprocessor scripting language at the side of Oracles database platform. Hypertext Preprocessor is likely one of the so much renowned open resource applied sciences within the region of net improvement, whereas Oracle is without doubt one of the most generally deployed and used database items.

The CERT Oracle Secure Coding Standard for Java (SEI Series in Software Engineering)

  “In the Java international, safety isn't really considered as an add-on a function. it's a pervasive frame of mind. those that fail to remember to imagine in a safe frame of mind turn out in hassle. yet simply because the amenities are there doesn’t suggest that defense is guaranteed instantly. a suite of ordinary practices has developed through the years.

Java Programming with Oracle JDBC

JDBC is the main Java know-how for relational database entry. Oracle is arguably the main popular relational database platform in the realm. during this booklet, Donald Bales brings those applied sciences jointly, and exhibits you the way to leverage the complete strength of Oracle's implementation of JDBC. you start through studying the all-important mysteries of creating database connections.

Additional info for Oracle DBA SQL Quick Reference (Prentice Hall PTR Oracle Series)

Sample text

Implicitly allows the setting of passwords, quotas, default, and temporary tablespaces and assigning of profiles for new users. Alter User Alter settings for existing users. Implicitly allows the setting of passwords, quotas, default, and temporary tablespaces and assigning of profiles. Become User Change to any other user (required for full database imports) Drop User Drop any user Create View Views in own schema Create Any Views in any schema View Drop Any Views in any schema View Under Any Create subviews of any view View Flashback Any Any table, view, or materialized view in the Table database Analyze Any Any table, cluster, or index in any schema Audit Any Any object in any schema Comment Any Any table, view, or column in any schema Table Exempt Bypass access control Access Policy Force Own in-doubt distributed transactions Transaction Force Any Force the commit or rollback of any in-doubt Transaction distributed transaction 35 Grant Any Object Privilege Grant Any Privilege Resumable Select Any Dictionary SYSDBA SYSOPER Grant or revoke any object privilege Grant any system privilege Enable resumable allocation of space Query SYS data dictionary objects.

Of the database. Startup Recovery General recovery 41 42 Full database recovery Partial database recovery Parallel 42 43 Managed standby recovery Recover 43 44 Cancel Finish 44 45 Database file Autoextend Maxsize 45 46 logfile logfile descriptor 46 47 Controlfile Trace file Standby database 47 48 Commit switchover Default settings Set time_zone 48 49 Conversion Redo thread Security Alter Dimension Modify the attributes or hierarchical relationships of a dimension. 49 50 Level Hierarchy Join Attribute 50 51 Alter Function Recompile the function.

Alter Outline Modify an existing outline statement. Alter Package Recompile a package as a unit. Alter Procedure Recompile a standalone stored procedure. Alter Profile Modify a profile to change resource limits or password management in an existing profile. 63 64 Resource parameters Password parameters 64 65 Alter Resource Cost Specify or modify the resource cost for a particular session. Alter Role Modify the authorization parameters for a role.

Download PDF sample

Rated 4.83 of 5 – based on 14 votes