Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Searching for info from multiple tables
There is a package that allows you to print directly to html/a browser. I user htp.print(stuff to print) or htp.prints(stuff without html tags) -
Searching for info from multiple tables
I have apache webserver. ( I think that's what you were asking for.) -
Searching for info from multiple tables
Hmm. I'm just learning SQL, so I don't understand all of the second response, but I think I get the basic idea. I'm not sure if this will work with PL/SQL, but there was no PL/SQL forum, so this was as close as I could get. If all of this is not possible in PL/SQL, I'm sorry to have bothered you. -
Searching for info from multiple tables
Thanks for the quick answer. Unfortunately, many people will have multiple addresses/phone numbers. Also, since this is for web output, I just found out that you can't select * into a varchar2 variable. -
Searching for info from multiple tables
I have 3 tables that I am searching through. There is a people table, a phone numbers table and an address table. The user is inputting information from a web site and runnint the pl/sql procedure. My question is: what would be a select statement that would search for the first name of a person...
