Quick Search:
 
 Oracle PL/SQL: Show all links Jump to:  
Category: >> Oracle PL/SQL >> Show all links  

<< lastnext >>

Snippet Name: Show all links

Description: This code will show all the links for a given database

@c:\oracle\sql\all_link.sql

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

spool all_link.rslt 
 
SET linesize 130;
SET pagesize 1000;
SET LONG 50;
SET echo ON;
 
break ON "OWNER" ON "TBL - NAME";
 
SELECT      SUBSTR(owner,1,10)                      "OWNER",
        SUBSTR(db_link,1,40)                    "LINK",
        SUBSTR(host,1,50)               "HOST",
     created                         "CREATED"
FROM      all_db_links 
ORDER BY 1 ASC, 2 ASC;
 
SET echo off;
spool off;
SET LONG 80;
COMMIT;


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org