Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to develop questions and answers in ORACLE APEX

User_MJMUSOct 5 2018 — edited Oct 5 2018

Hi

I created  table

create table lms_questions

  (question_id number constraint pk_question primary key,

   passage_id number,

   question varchar2(400),

   option1 varchar2(50),

   option2 varchar2(50),

   option3 varchar2(50),

   option4 varchar2(50),

   correct_answer varchar2(100),

   section_id number,

   created_date timestamp,

   created_by varchar2(50),

   updated_date timestamp,

   updated_by varchar2(50),

   CONSTRAINT FK_section_ques FOREIGN KEY(section_id) REFERENCES lms_section(section_id));

Thanks

Eshwar

Comments
Post Details
Added on Oct 5 2018
1 comment
533 views