Mini Posts Roundup from Twitterland (2007-07-30)
- Subscribing to http://www.dailywritingtips.com/ #
Videos on Flashback in Oracle Database 10g and 11g
Dan Morgan, the author of Morgan’s library, has just posted three videos on Flashback in Oracle database 10g and 11g:
Watch the FlashBack Database video (20 min) on how to return the database to a point in the past using either the SCN (system change number) or a specified time. Go to the FlashBack Database webpage on Morgan’s library to try the code yourself.
Watch the FlashBack Drop video (11 min) on how to recover a dropped table. Go to the FlashBack Drop webpage on Morgan’s library to try the code yourself.
Watch the FlashBack Query video (9 min) on how to run queries against the database at any specific time in the past. Go to the FlashBack Query webpage on Morgan’s library to try the code yourself.
These are excellent videos (with nice classical introductory music) and I hope that Dan will post more videos on more Oracle topics in the future.
Note: You need the free RealMedia Player to watch the videos.
Filed in Oracle with Comments Off | Tags: 10g, 11g, flashback6 Links from Around the Web (2007-07-27)
-
Oracle Apps Vision demo environment.
-
Oracle Apps Vision demo environment.
-
An Oracle Metalink document that describes the steps required to clear the cloned copy of the production EBS database of credentials such as schema and encrypted passwords.
-
What is SQL? What Is ANSI SQL? What Is a Database?
-
Oracle record browser and editor in a single PHP script.
-
Contains a collection of install guides and tips that worked best for customers as reported in the Linux Discussion Forums and OTN Installfests.
More from my bookmarks on del.icio.us
Filed in Links with Comments OffWhat you Ought to Know About CASE in Oracle PL/SQL
Oracle PL/SQL evangelist Steven Feuerstein‘s latest PL/SQL puzzler The Mysteries of CASE in PL/SQL is interesting. It touches on one “less-than-obvious aspect of PL/SQL’s CASE”. So, what is this “mysterious” thing about CASE? (more…)
Filed in Oracle with 6 Comments | Tags: pl/sqlMini Posts Roundup from Twitterland (2007-07-24)
- You know that Facebook is the next big thing when your aunt in Canada, your brother in Lebanon and your friend in Dubai join it. #
Get All the Cool New Features of Oracle Application Express 3.0 in Oracle Database XE
If you use Oracle Database 10g Express Edition (Oracle Database XE) you already have Oracle Application Express (Oracle APEX) release 2.1, it’s part of the XE installation. However, in order to use the many new features of the latest release of Oracle APEX, you need to upgrade APEX, within your Oracle Database XE, to version 3.0.1.
Justin Kestelyn, OTN Editor-in-Chief, blogged about this topic a couple of weeks ago. In reply to a question about the licensing fee of APEX, Justin mentioned that “you can develop a production Apex-based app on XE for free, subject to the terms of the XE license”.
A few days ago, I followed the instructions in this document to upgrade APEX within XE on my Windows Vista laptop. The upgrade was very smooth and took about 20 minutes to complete. I also wanted to test Jing, a new and simple screencasting tool, so I recorded the upgrade process as a 5 minute screencast: (more…)
Filed in Oracle with 4 Comments | Tags: apexNew Oracle ACE and Website
Oracle has just revamped the Oracle ACE 
section on OTN. In addition to the new look and feel, they also introduced a new ACE level, ACE Directors 
who meet a higher level of expectation in terms of community activity.
Check out the new Oracle ACE program site, Oracle ACE qualifications and nominations, and the brand new Find Oracle ACEs application.
Now each Oracle ACE has a page of his/her own. Here is mine. Yes, I have recently been granted Oracle “ACE-dom”. Thanks for whoever nominated me. The Oracle community rocks!
Rousing Entertainment With the Guru of Oracle PL/SQL
I received the following invitation from NWOUG:
On behalf of Quest Software, NWOUG invites you to attend a free breakfast seminar that will be held in Portland, OR on Tuesday, July 24, 2007.
Join Steven Feuerstein, PL/SQL Evangelist of Quest Software, to explore key best practices for PL/SQL development and learn how they fit into a development workflow that produces high quality code. In addition to the rousing entertainment, you might even win a signed copy of one of his books, courtesy of O’Reilly Media!
A free breakfast and a “rousing entertainment” with Steven Feuerstein just around the corner of where I work, it does not get much better than that! So, I’m planning to attend.
The agenda includes a Q & A session at the end of the seminar, so I may have the opportunity to ask Steven a few questions.
Do you have a specific question you would like me to ask Steven? I do not guarantee I’ll be able to ask him your question, but I’ll try.
Filed in Oracle with 3 Comments | Tags: pl/sqlOracle Database 11g Old Feature: Internet Addressing
No, this is not an Oracle database 11g new feature. If you are disappointed please move one to your next item on your reading list. Otherwise, the following is a quick refresher about a handy feature that has existed since 8.1.7 and will continue to exist in 11g. It is the Oracle supplied UTL_INADDR PL/SQL package.
UTL_INADDR is a neat utility for internet addressing. It provides two functions to retrieve host names and IP addresses of local and remote hosts.
Go ahead and try the following examples in your Oracle environment:
-- Give me the name of the machine that hosts
-- the database server I'm connected to.
SELECT UTL_INADDR.get_host_name
FROM DUAL;
-- Give me the IP address of the machine that hosts the
-- database server I'm connected to.
SELECT UTL_INADDR.get_host_address
FROM DUAL;
-- Give me the IP address of oracle.com, or any host name you desire
SELECT UTL_INADDR.get_host_address ('oracle.com')
FROM DUAL;
-- Give me the host name of 141.146.8.66, or any IP address you desire
SELECT UTL_INADDR.get_host_name ('141.146.8.66')
FROM DUAL;
-- Give me the IP addresses of all client machines connected to the database
SELECT DISTINCT machine,
UTL_INADDR.get_host_address (SUBSTR (machine,
INSTR (machine, '\') + 1)) ip
FROM gv$session
WHERE TYPE = 'USER'
AND username IS NOT NULL;
And here are a couple of related functions:
-- Give me the IP address of the client machine that
-- I'm currently using to connect to the database.
SELECT SYS_CONTEXT ('USERENV', 'IP_ADDRESS')
FROM DUAL;
-- Give me the operating system of the server machine that
-- hosts the database I'm connected to.
SELECT DBMS_UTILITY.port_string
FROM DUAL;
Watch this space for more 11g old features…
Sources and resources:
- Oracle UTL_INADDR at Morgan’s Library
- UTL_INADDR Documentation
- Identifying Host Names and IP Addresses
- Get IP address & host with sys_context and utl_inaddr
- How to find the IP address of the database server
- How to get the OS of the database server
