| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
08-14-10, 12:34
|
|
Registered User
|
|
Join Date: Oct 2008
Posts: 33
|
|
|
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
|
|
08-14-10, 13:21
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
|
|
>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.
|
|
08-14-10, 14:20
|
|
Registered User
|
|
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
|
|
08-14-10, 14:34
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
|
|
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.
|
|
08-14-10, 14:59
|
|
Registered User
|
|
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??
|
|
08-15-10, 05:47
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,590
|
|
Quote:
|
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?
|
|
08-15-10, 10:06
|
|
Registered User
|
|
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.. 
|
|
08-15-10, 16:04
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,590
|
|
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.
|
|
08-17-10, 14:58
|
|
Registered User
|
|
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
|
|
08-18-10, 12:00
|
|
Registered User
|
|
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??
|
|
08-27-10, 16:08
|
|
Lost Boy
|
|
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,590
|
|
@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.
|
|
08-30-10, 15:38
|
|
Registered User
|
|
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
|
|
08-30-10, 16:37
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
|
|
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.
|
|
08-30-10, 17:07
|
|
Registered User
|
|
Join Date: Oct 2008
Posts: 33
|
|
thanks for your reply..but what exactly do u mean?
|
|
08-30-10, 17:24
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
|
|
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.
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Oracle search
