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.
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
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
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'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.