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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Simple select...
Thank you for replaying me, but your advice isn't answer to my question. I didn't inquire about condition WHERE, but I'd like to the SELECT return 365 rows, but not only one.- gold2000
- Post #3
- Forum: Oracle: All versions
-
Oracle IP Address
v_$session is a view on schema sys. You can select some information from this dynamic view, for example machine. You must have select rights on this view. Example> select * from v$session By Gold- gold2000
- Post #4
- Forum: Oracle: All versions
-
Simple select...
How I write Select command, that result are all days in this year. I would like use this select as subquery in IN/OUT cursor, therefore I don't want use For..loop. Thanks for answer on my stupid question. Example: Day 1/1/00 1/2/00 ... 12/31/00- gold2000
- Thread
- Replies: 6
- Forum: Oracle: All versions
-
Data from stored procedure Oracle, plz help.
Ok here it goes.<br>I have some stored procedure in Oracle database and I would like to retrieve single values and cursor from it and display in ASP-page. <br><br> PROCEDURE proc1(a_str1 OUT varchar2,a_str2 OUT varchar2)AS <br> BEGIN a_str1:='bla'; a_str2:='bla'...- gold2000
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
