Intelligence Base

Power not come from knowledge kept, but come from knowledge shared.

01 August 2010

How to see code of store procedure from sqlplus

login as system or owner of stored procedure
set long 1000000;
select dbms_metadata.get_ddl('PROCEDURE','ADDSUBPARTITION') FROM dual;
Posted by Kittisak Boyd at 22:01
Labels: oracle

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Labels

  • datastage
  • db2
  • efficiency
  • entrepreneur
  • ETL Design
  • evaluation
  • google
  • Guy Kawasaki
  • HRM
  • informix
  • Leisure
  • management
  • oracle
  • shell script
  • Teradata
  • unix

Blog Archive

  • ►  2011 (2)
    • ►  May (2)
  • ▼  2010 (39)
    • ►  October (2)
    • ▼  August (5)
      • วิธีการ create table บน Teradata
      • Teradata Table Type and Index Type
      • NLS_DATE_FORMAT
      • How to see code of store procedure from sqlplus
      • Find and remove duplicate rows from a table
    • ►  July (7)
    • ►  June (5)
    • ►  May (5)
    • ►  April (14)
    • ►  January (1)
  • ►  2009 (37)
    • ►  December (2)
    • ►  October (2)
    • ►  September (2)
    • ►  August (2)
    • ►  July (4)
    • ►  June (1)
    • ►  May (5)
    • ►  April (1)
    • ►  March (4)
    • ►  February (4)
    • ►  January (10)
  • ►  2008 (20)
    • ►  December (4)
    • ►  November (1)
    • ►  October (4)
    • ►  September (3)
    • ►  August (8)

Data Warehouse Link

  • Teradata
  • IBM - Technical library view
  • Data Doghouse

DataStage Link

  • DSXchange Member Portal
  • IBM Software - IBM Information Server
  • DSXchange :: IBM Information Server Forum
  • DSXchange Learning Center
  • DSXchange Channel on YouTube
  • Getting DataStage Certification
Picture Window theme. Theme images by mammuth. Powered by Blogger.