Page 1 of 2 12 LastLast
Results 1 to 15 of 27

Thread: Oracle search

  1. #1
    Join Date
    Oct 2008
    Posts
    33

    Unanswered: Oracle search

    good day all,
    looking for some assistance and I know this is the right place to be. I am wondering if its possible that i create a search function for my database. i have a member table and i want the search function to retrieve the member details when the member name is entered. if this is possible..how do i go about doing this?? any assistance i receive will be appreciated.
    thanks in advance
    W.K

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >if this is possible..
    Yes

    >how do i go about doing this??
    write SQL.

    >any assistance i receive will be appreciated.
    We do not have your tables or data so no assistance is possible at this time.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2008
    Posts
    33
    hey there thanks for your reply..what should post? the create and insert statement for the member table? or the actual data? i dont want to be waisting your time by sending irrelevant information. thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    How would an independent observer conclude the correct answer has been posted
    or conclude from a variety of offered solutions which was the correct answer?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2008
    Posts
    33
    am sorry but am a bit lost by your last post?? can u explain what you are referring to??

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    i want the search function to retrieve the member details when the member name is entered
    The simplest way (in SQL*Plus) might look like this:
    Code:
    select *
    from members_table
    where member_name = '&member_name';
    In Forms, you'd create a data block based on the "members_table" and execute query after entering member's name into the corresponding item.

    In Reports, you'd use member's name as a parameter (which would be part of the WHERE clause).

    In other tools, you'd probably do that *somehow* as well, but - which tool do you use?

  7. #7
    Join Date
    Oct 2008
    Posts
    33
    hey Littlefoot,
    thanks for you reply. i will give your solution a try and keep you informed on the results. i am going to try it out via the form builder..thanks again..

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If this is going to be your first form, use a wizard - it will create a default, working form. Won't look very pretty, but will be fully functional - you'll be able to query, update and delete existing records, as well as add new ones.

  9. #9
    Join Date
    Oct 2008
    Posts
    33
    hey there littlefoot,
    i have been trying out your solution and am kind of confused as to where exactly i should put the query syntax on the form i built..must i create some thing like a text item with a button to execute the query??..please help

  10. #10
    Join Date
    Aug 2010
    Posts
    1
    am sorry but am a bit lost by your last post?? can u explain what you are referring to??

  11. #11
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    @wild kayode: you don't have to code anything - just let the wizard do the job. It will create all you need to successfully run the form.

  12. #12
    Join Date
    Oct 2008
    Posts
    33
    hey guys..thanks for the assistance given ..it really help and i got through with what i was doing. i have another problem now..i build a website using dreamweaver and i want to create a registration form and have the information added to the oracle database. i have configured the ODBC data source administrator using microsoft ODBC for Oracle. created a new ASP Vb srcipt page in dreamweaver, added the database but i am not seeing any of the tables i have in my database am seeing a whole bunch on tables that have nothing to do with my database... PLEASE!!!!!!! can i get some assistance..i am really confused and i consider myself to be " STUCK"...any assistance will be greatly appreciated...Thanks in advance.
    W.K

  13. #13
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You should only have visibility to table owned by the current schema.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  14. #14
    Join Date
    Oct 2008
    Posts
    33
    thanks for your reply..but what exactly do u mean?

  15. #15
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> connect oe/oe
    Connected.
    SQL> select  table_name from user_tables;
    
    TABLE_NAME
    ------------------------------
    PRODUCT_REF_LIST_NESTEDTAB
    SUBCATEGORY_REF_LIST_NESTEDTAB
    CUSTOMERS
    PRODUCT_DESCRIPTIONS
    PROMOTIONS
    ORDER_ITEMS
    PRODUCT_INFORMATION
    ORDERS
    INVENTORIES
    WAREHOUSES
    
    10 rows selected
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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