CODEWITHSUNDEEP
sqloracle-databaseplsql
backdoor
backdoor

Reputation: 1195

basic oracle question

I have this query:

select total.lecgrouplecture(l.groupcode)  lecturename,
       total.lecgrouptime(l.groupcode) lecttime 
  from total.lecgroup l  
 where term = (select term 
                from total.CURENTTERM) 
   and rownum < 10 
order by lecturename

I want to know what total.lecgrouptime(l.groupcode) is, and get this information from where?

Upvotes: 0

Views: 99

Answers (2)

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

it looks like TOTAL is the name of a schema (SELECT * FROM all_users WHERE username = 'TOTAL'). If this is the case then lecgrouplecture must be a pl/sql function. You will find what it does with Robert's query:

SELECT * 
  FROM all_source 
 WHERE owner = 'TOTAL' 
   AND name = 'LECGROUPLECTURE' 
 ORDER BY line;

Upvotes: 0

Rob van Laarhoven
Rob van Laarhoven

Reputation: 8905

total is the package name

lecgrouplecture is a function within that package

Look in user_source for the code or use a GUI like SQL Developer or TOAD

Upvotes: 1

Related Questions