basic oracle question

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?

Answer 1

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

Answer 2

Hi backdoor,

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;