Oracle External Organization

ifrun60 d:\shield\exam_shield1.fmx nip/nip@nip statistics=yes

create table encrypt (code number, inst_name varchar2(100),address varchar2(200),username varchar2(30),password varchar2(20),serial varchar2(1000));
alter table encrypt add photo long raw;

 create table ex1 (code number, inst_name varchar2(100), sl_no int, sem varchar2(10), branch varchar2(10), paper_no number, subject_name varchar2(100),
 code_no number, s_exam_date date, s_sess_id varchar2(30), dispatch_day date, dispatch_time varchar2(20), packet_count int, dispatch_on date);

create table abs_cnt as
select sl_no,signature qp_code,regno  regno ,sname ,branch,sem,paper_name,paper_category from theory_attendance_stage ;

create table exam_print as select * from exam order by branch,sem,regno;

CREATE TABLE EX6 (
sl_no int, s_exam_date varchar2(100),
subject_name varchar2(200),
q_code number,
no_seal_cover number,
tot_qus number,
present number,
supplied number,
not_opened number,
retained number,
returned number,code number, inc_name varchar2(100),s_sess_id varchar2(30));


create table tb_asst (one  varchar2(30),two  varchar2(30),three  varchar2(30))

create table tb_matrix_absent (sl_no int, regno number, sname varchar2(40), branch varchar2(6),
sem varchar2(5), regular varchar2(15), p_c varchar2(10),attend char(1));


  add_list_element('block3.long',n, rpad(k.sl_no,4)||' '||rpad(k.regno,10)||' '||rpad(k.sname,30)
        ||' '||rpad(k.branch,5)||' '||rpad(k.sem,4)||' '||rpad(j.iii,10)||' '||rpad(k.paper_category,4)||' '||rpad(k.absent,3),1);

delete from tIME_TABLE
  where REGNO in ( select REGNO
                   from ( select REGNO REGNO,
                                  row_number() over
                                      (partition by CODE order by REGNO) rn
                              from tIME_TABLE
                         )
                     where rn <> 1 )
  --DUBLICATE ROWS


create table compute_stage (sl_no number primary key, sname varchar2(40),
regno number, branch VARCHAR2(30),sem VARCHAR2(30),s_code VARCHAR2(30),s_paper_name varchar2(100),s_branch VARCHAR2(30),s_semester VARCHAR2(30),s_p_c number,
s_exam_date date, s_sess_id VARCHAR2(30),a varchar2(10), b number, c number, d number,e number, f number, g number, signature number, absent varchar2(5))
organization index

 SELECT * FROM
 (SELECT row_number() over (order by s_code,regno ) a ,regno,sname,s_paper_name FROM compute_statistics) x
 WHERE x.a < 15

 create table compute(
 sl_no number,
 regno number,
 sname varchar2(100),
 branch varchar2(30),
 sem varchar2(20),
 S_CODE NUMBER,
 S_PAPER_NAME VARCHAR2(100)
 ,CONSTRAINT CN_ORG PRIMARY KEY(BRANCH,S_CODE,REGNO))
 ORGANIZATION INDEX
/

INSERT INTO COMPUTE (SELECT SL_NO,REGNO,SNAME,BRANCH,SEM,S_CODE,S_PAPER_NAME FROM COMPUTE_STAGE)

alter table f_x modify s_exam_date varchar2(100);
/