basic oracle question -
I used this query:
Choose from all_source text where owner = ' (Name) = Bottom ('LECGROUPTIME') order
has been received for finding the named reference function 'TOTAL' and LECGROUPTIME:
Return LECGROUPTIME (varchar2 in invergroupCode) Select Varchar2 cursor gate time, day, start, time from program where the group code = inGroupCode; Maida varchar2 (10); MyFlag number; MyTimeVarcar 2 (200); Maybaf Vartar 2 (50); Mydub Vartar 2 (10); MyBuginTime Date; MindTime date; Start MyFlag: = 0; MyTime: = ''; Open GetTime; Get Loop GetTime InTo MyDay, mybeginTime, MyEndTime; Exit (GetTime% NotFOUND) or (GetTime% NotFOUND is NULL); Select Day from MyDayBuf Refrence where not = MyDay; If MyFlag & lt; & Gt; 0 then mytime: miteum || 'And'; end if; MyTime: MyTime || MardiBuff || To_Char (MyBeginTime, 'HH24: MI') || 'TA' || TO_CHAR (MyEndTime, 'HH24: MI'); MyFlag: = 1; End loop; Close GetTime; If MyTime = '' then MyTime: = '-'; end if; Return Mightim; Exception when NO_DATA_FOUND return again '-'; End;
In one line, this is: Select day, start time, end time from program ...
I can see any table that is programmed Let's name ... Can you say why I am? Thanks ...
Can you run that question on your own?
..
Choose from all objects * where object_name = 'program';
Comments
Post a Comment