You're posting in the wrong forum.
Regarding your question:: just explore/search the OnlineOracle Documentation: Oracle Database Online Documentation 11g Release 2 (11.2)
Well, I have great news for you then:
In Oracle you can select without a refcursor as well.
You need to be more specific about what your actual question is, give us an example, something to work with.
why we r using rc in store proc ??
in MSSQL u can select without refcursor
and I've some other great news for you.... Oracle isn't MSSQL.
Don't try and compare one database platform to another, because they use completely different languages (aside from the SQL part) and they work completely differently.
Typically a ref cursor is used to supply a cursor back to a 3rd party application layer such as a Java, .NET etc. program, and then they have mechanisms to process such cursors and fetch the data.
MSSQL <> Oracle, so whenever you have doubts, you can use/search this forum for advice (provide as much information as possible, but keep it concise, as small as possible) and search the documentation and totally forget about MSSQL when you work with Oracle. Keep an open mind and be willing to learn completely new (and cool ) stuff