www.webdeveloper.com
Results 1 to 2 of 2

Thread: prob in retrieving

  1. #1
    Join Date
    Oct 2004
    Posts
    169

    prob in retrieving

    i have two tables named sec_mast and sec_detail

    SQL> descr sec_mast;
    Name Null? Type
    ----------------------------------------- -------- ------------
    SEC_NO NOT NULL NUMBER(4)
    CATG_CODE NUMBER(2)
    FACE_VAL NOT NULL NUMBER(10,2)
    PUR_VAL NOT NULL NUMBER(10,2)
    INT_PAID NOT NULL NUMBER(8,2)
    INT_RECD NOT NULL NUMBER(8,2)
    BRKR NOT NULL NUMBER(8,2)
    TOT_VAL NOT NULL NUMBER(12,2)
    VOU_NO VARCHAR2(9)
    VOU_DATE DATE
    VOU_AMT NUMBER(15,2)
    DUE_DATE1 NOT NULL DATE
    DUE_DATE2 DATE
    LF_NO NOT NULL VARCHAR2(10)
    MAT_DATE NOT NULL DATE
    FK_VOU_NO2 VARCHAR2(9)

    SQL> descr sec_detail;
    Name Null? Type
    ----------------------------------------- -------- ----------------
    SEC_NO NUMBER(4)
    LF_NO VARCHAR2(8)
    DUE_DATE1 DATE
    VOU_NO VARCHAR2(9)
    VOU_DATE DATE
    VOU_AMT NUMBER(15,2)
    FK_VOU_NO1 VARCHAR2(9)


    my problem is that i want to retrieve values from database and i have used following query for the prepared statement.Here VOU_No is foreign key.

    select * from sec_detail,sec_mast where sec_detail.sec_no=sec_mast.sec_no //

    if this query is wrong then plzz help me in this..


    i have done this in jsp page

  2. #2
    Join Date
    Jan 2004
    Location
    Melbourne, Australia
    Posts
    5,298
    The query looks fine to me. What actual error are you receiving and can we see the code on that line (and 3 or 4 lines above)?

    Regards.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles