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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: joebednarz
- Order by date
-
Accessing Oracle when ports are restricted
If your target database is on a Windows machine, you can put a setting in the registry that will help. \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ will have multiple "HOMEx" keys for each Oracle home installed. Find the one corresponding to your database and add a key (on the right side) called...- joebednarz
- Post #3
- Forum: Oracle: All versions
-
Querying records via a outer join
Yes, the query I posted will do just that. Outer joins using the (+) notation denotes the dependant/child table, and the "h.employeeid IS NULL" says only show records in employee where there is no match in history. I was going off of the sql-pseudo code orginally posted: It's similar to your...- joebednarz
- Post #5
- Forum: Oracle: All versions
-
Querying records via a outer join
In Oracle you have another option: SELECT e.* FROM employees e, employee_history h WHERE e.employeeid = h.employeeid(+) AND h.employeeid IS NULL; JoeB Use smaller fonts to save disk space...- joebednarz
- Post #3
- Forum: Oracle: All versions
-
accessing data in an xml file using DOM
I have been trying so many things I'm not sure what I have tried and what I have not. Here is my code: <html> <head> <script type="text/javascript"> var xmlhttp; var xmlDoc; var xmlRec = 0; function loadXMLDoc(start_p) { if (window.XMLHttpRequest) // code for Mozilla, etc. {...- joebednarz
- Thread
- Replies: 0
- Forum: XML
