Click here to Skip to main content
15,885,366 members
Articles / Desktop Programming / WPF

DBTool for Oracle - Part 1

Rate me:
Please Sign up or sign in to vote.
4.92/5 (45 votes)
13 Apr 2014CPOL18 min read 135.8K   5.1K   88  
Enhance productivity and reliability, write your own tools.
using System;
using System.Data;
using System.ComponentModel;
using System.Reflection;
using Oracle.DataAccess.Client;

namespace Harlinn.Oracle.DBTool.Utils.DB
{
    // Order corresponds to the elements in the 
    // ObjectReader.ObjectTypeNames array
    public enum ObjectType
    {
        Unknown = 0,
        //EDITION
        Edition,
        //INDEX PARTITION
        IndexPartition,
        //CONSUMER GROUP
        ConsumerGroup,
        //SEQUENCE
        Sequence,
        //TABLE PARTITION
        TablePartition,
        //SCHEDULE
        Schedule,
        //RULE
        Rule,
        //JAVA DATA
        JavaData,
        //PROCEDURE
        Procedure,
        //OPERATOR
        Operator,
        //DESTINATION
        Destination,
        //WINDOW
        Window,
        //SCHEDULER GROUP
        SchedulerGroup,
        //PACKAGE
        Package,
        //PACKAGE BODY
        PackageBody,
        //LIBRARY
        Library,
        //PROGRAM
        Program,
        //RULE SET
        RuleSet,
        //CONTEXT
        Context,
        //TYPE BODY
        TypeBody,
        //JAVA RESOURCE
        JavaResource,
        //XML SCHEMA
        XMLSchema,
        //TRIGGER
        Trigger,
        //JOB CLASS
        JobClass,
        //DIRECTORY
        Directory,
        //MATERIALIZED VIEW
        MaterializedView,
        //TABLE
        Table,
        //INDEX
        Index,
        //SYNONYM
        Synonym,
        //VIEW
        View,
        //FUNCTION
        Function,
        //JAVA CLASS
        JavaClass,
        //JAVA SOURCE
        JavaSource,
        //INDEXTYPE
        IndexType,
        //CLUSTER
        Cluster,
        //TYPE
        Type,
        //JOB
        Job,
        //EVALUATION CONTEXT
        EvaluationContext
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect Sea Surveillance AS
Norway Norway
Chief Architect - Sea Surveillance AS.

Specializing in integrated operations and high performance computing solutions.

I’ve been fooling around with computers since the early eighties, I’ve even done work on CP/M and MP/M.

Wrote my first “real” program on a BBC micro model B based on a series in a magazine at that time. It was fun and I got hooked on this thing called programming ...

A few Highlights:

  • High performance application server development
  • Model Driven Architecture and Code generators
  • Real-Time Distributed Solutions
  • C, C++, C#, Java, TSQL, PL/SQL, Delphi, ActionScript, Perl, Rexx
  • Microsoft SQL Server, Oracle RDBMS, IBM DB2, PostGreSQL
  • AMQP, Apache qpid, RabbitMQ, Microsoft Message Queuing, IBM WebSphereMQ, Oracle TuxidoMQ
  • Oracle WebLogic, IBM WebSphere
  • Corba, COM, DCE, WCF
  • AspenTech InfoPlus.21(IP21), OsiSoft PI


More information about what I do for a living can be found at: harlinn.com or LinkedIn

You can contact me at espen@harlinn.no

Comments and Discussions