Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: December 01, 2014 - 4:50 pm UTC

Last updated: December 12, 2018 - 3:47 am UTC

Version: 11.2.0.4

Viewed 10K+ times! This question is

You Asked

Tom,
I was recently looking at distinct object_type in dba_objects and noticed that one object_type was PROGRAM. Where can I find more information on object_type PROGRAM?

Thanks...

and Tom said...

it is a dbms_scheduler program:

ops$tkyte%ORA11GR2> select object_name, object_type
  2    from user_objects
  3   where object_type = 'PROGRAM';

no rows selected

ops$tkyte%ORA11GR2> begin
  2    dbms_scheduler.create_program (
  3      program_name   => 'test_program',
  4      program_type   => 'PLSQL_BLOCK',
  5      program_action => 'begin null; end;',
  6      enabled        => TRUE,
  7      comments       => 'Program to do something...' );
  8  end;
  9  /

PL/SQL procedure successfully completed.

ops$tkyte%ORA11GR2> select object_name, object_type
  2    from user_objects
  3   where object_type = 'PROGRAM';

OBJECT_NAME                    OBJECT_TYPE
------------------------------ -------------------
TEST_PROGRAM                   PROGRAM

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Just to know

Karthick, December 09, 2014 - 11:10 am UTC

Just out of curiosity, did you actually know the answer already or you looked for it once the question was asked 
Tom Kyte
December 09, 2014 - 6:23 pm UTC

I already knew...

it is best to show however, less mistakes that way - or at least if I make a mistake, someone will see it and point it out.

be wary if someone just says "X is the answer" :) without showing some work

Some other object types in Oracle

Annamalai C, December 06, 2018 - 3:48 pm UTC

Hi,

This information is very very useful.
Also, I fould some other object types.

OPERATOR
INDEXTYPE
CONSUMER GROUP
SCHEDULER GROUP
SCHEDULE

Could you pls provide some lights on this ?

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library