Oracle Forms (MOSC)

MOSC Banner

FROM CLAUSE QUERY

edited Aug 30, 2011 7:15AM in Oracle Forms (MOSC) 4 commentsAnswered
Hi Anyone
I am new to using from clause query and am having problems getting data to appear on the from from the query.  I have read just about everything i could find on this subject, but nothing is working.

My form has 2 blocks on it.

1st the KEY BLOCK.  the key block has 2 fields in it.  the term and dept_code.   these 2 fields need to be passedused in the FROM CLAUSE QUERY for selection purposes.

The second is the DATA BLOCK, which contains the fields to be displayed.  There are 7 fields.  STUDENT_ID, STUDENT_NAME, STUDENT_DEGREE STUDENT_MAJR, STUDENT_CONC, ADVISOR_ID, ADVISOR_NAME.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center