Blog Detail

Oracle Tips & Tricks

http://oracletipstricks.blogspot.com

oracle tips & tricks for database administration, database performance to optimize your oracle database

• Added on: Jan 4th, 2008
• Country: Indonesia
• Language: English

• Author: mister popo
• Listed in: Software eLearning
• Tags: sql oracle pl/sql oracle database oracle dba

Recent Posts

• Invoking and Executing a Script from OEM

  Posted on Friday April 25th, 2008 at 02:59 in oracle dba

  When including script names in OEM you must carefully include the fully-qualified path for the script: (i.e. /u01/app/oracle/scripts/myscript.sql). Placing custom scripts within OEM is a great way to improve reporting. Here is a quick overview of sc...

• Database Link From Oracle to SQL Server

  Posted on Thursday April 24th, 2008 at 19:07 in oracle dba

  After you succeed connecting Oracle with SQL Server probably you want to create database link between it. Oracle heterogeneous services allow you to define a database link between Oracle and SQL Server, as well as links to DB2 and other inferior data...

• Accessing Oracle Alert Log via SQL with External Tables

  Posted on Thursday April 24th, 2008 at 18:57 in sql, oracle dba, sql*plus

  Starting in Oracle9i you can map external flat files to Oracle tables.Mapping the Oracle alert log is easy and once defined, all you have to do is query it with standard SQL syntax:create directory BDUMP as '/u01/app/oracle/admin/mysid/bdump';create ...

• Computing date differences

  Posted on Tuesday April 22nd, 2008 at 05:13 in sql*plus

  One of the confounding problems with Oracle DATE datatypes is the computation of elapsed time.Oracle supports date arithmetic and you can make expressions like "date1 - date2" to get the difference between the two dates. Once you have the date diffe...

• Oracle SQL : Coding a matrix of display values

  Posted on Tuesday April 22nd, 2008 at 05:00 in sql*plus

  Oracle has a fascinating non-ANSI feature called an in-line view. The in-line view allows for a query to be placed into the FROM clause of an SQL statement, where you would normally place a table name.By performing a SELECT in the FROM clause, we ca...

• Oracle Package Initialization

  Posted on Tuesday March 18th, 2008 at 01:53 in pl sql

  Did you notice that Oracle PL/SQL packages can have an initialization section? The initialization part of a package is run only once, the first time you reference the package. Here is an example:CREATE PACKAGE emp_actions AS /* Declare externally...

Comments & Reviews

This blog is currently rated a 5.00 out of a possible 5 based on 1 comment.

DiamondVVV1

Love the dog portraits .. well done and a beautiful site as well.

Posted: January 4th, 2008 | More Reviews From DiamondVVV1 | Report This Comment

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.