Programming ! Here's How.

This is a place where I will post my day to day learning's in Oracle SQL, PL/SQL, Java and other technologies...

Pages

Home
Oracle
Informatica

Tuesday, December 18, 2012

Queries for DD tables in Oracle

Find the queries for various DD tables in the document https://docs.google.com/open?id=180eCMrfSn-SkDRA-eXEAFIQCi85wdiugzlt9jzwZSjqoCLHyVA_HQnqnqzTa

Posted by Manikanda Prabhu at 5:38 PM

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: data dictionary, oracle

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Feeds from other blogs/sites

Oracle Magazine - Most Recent

Files Up and Files Down -
5 months ago
SbhOracle

7 Insider Secrets to Make Your Manuscript Stand Out to Publishers - What Publishers Look for When Evaluating Manuscripts As an aspiring author, one of the most critical steps in your writing journey is getting your manuscri...
8 months ago
PL/SQL Challenge

The Last Post on This Blog (for all the right reasons) - Friends, I have used this blog to make announcements regarding the PL/SQL Challenge since April 2010. We had a great run, and now we can look forward to a...
10 years ago

About Me

Manikanda Prabhu

View my complete profile

Blog Archive

► 2014 (5)
- ► December (3)
- ► February (2)

► 2013 (3)
- ► October (3)

▼ 2012 (8)
- ▼ December (2)
  - Queries for DD tables in Oracle
  - Data dictionary tables for Roles and Privileges in...
- ► November (2)
- ► October (1)
- ► September (1)
- ► August (2)

► 2011 (8)
- ► September (8)

Popular Posts

[INFORMATICA] - Steps to install Informatica Powercenter 9.5 in Windows 8 or windows 8.1

Here am going to give the step by step process to download and install Informatica Powercenter 9.5.x in Windows 8/8.1 Step 1 : Define Sc...
Oracle Listener service is not starting

When you try to start the listener service and it gives you the below message and stops automatically. The OracleOraDb10g_home1TNSListen...
How to Split single Column value into multiple rows?

Consider the data set with t as ( select 101 job_id, 'P00O0496,,P00O0828,P00O2739,P00O3522,P00O4405,P00O7182,P00U1375' str ...
Delete duplicate rows from Oracle tables

Removing duplicate rows from Oracle tables with SQL can be very tricky, and there are several techniques for identifying and removing dup...
[INFORMATICA] - The specified DSN contains an architecture mismatch between the Driver and Application.

I am trying to connect to oracle using power center designer 9.5.1 > Import Database source option and I get this error " T he spe...
Finding missing dates using SQL

Query to find missing dates between two date range in a table. We need to LEFT JOIN the table. WITH all_dates AS ( SELECT TO_DATE(...
Oracle PL/SQL Articles

Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Miscellaneous Copied from http://www.oracle-base.com/articles/plsql/ar...
[INFORMATICA] - How to Create a Target Table in Informatica?

If you have created Target table just using the Target designer and wondering how to create it in actual database then here are the steps....
The SQL Model Clause

Refer http://www.dba-oracle.com/oracle_news/10g_dw_model_clause.htm
Installing and configuring OAM server 11g

Steps to Install and configure OAM server 11g: http://itnaf.org/oracle-access-manager-11g-new/

Followers

Simple theme. Theme images by luoman. Powered by Blogger.