How to check the Oracle version?
You can check the Oracle version you are connected to by retrieving information from the v$version data dictionary view
v$version has only one field, BANNER.
select * from v$version
1 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
2 PL/SQL Release 10.2.0.4.0 - Production
...
...
Aside from the Oracle version, you can also retrieve version information of other oracle related products, like Pl/SQL etc.
Tuesday, March 17, 2009
Thursday, October 23, 2008
Oracle Developer Interview Tips
I'm placing here the Technical interview questions that had been asked to me( latest job), well, only those that I remember :p
Post to be updated later.....
Post to be updated later.....
Wednesday, October 15, 2008
Welcome To The Oracle Developer Refuge
Welcome!
I don't have much to say, basically this will be the repository of my SQL / PL*SQL codes...
I tend to forget things so basically this is for me and for others who will going to find my post informative.
Here you'll find techniques, codes, How tos, Tips and Tricks, Interview Tips and a lot more, basically more on my experiences as an Oracle Developer.
Oracle Programmer vs. Oracle Developer
Is there a difference? for me yes, a lot.. not that I see programmers less than developers, but being a developer makes you step to the higher level, and requires years of experience. A programmer merely codes based on requirements, but a developer can handle system development from data gathering to system implementation. So I guess that gives you a hint of what I'm doing.
Well this is not a tutorial blog.. this is again, basically a repository of my works, and sharing of my experiences
I don't have much to say, basically this will be the repository of my SQL / PL*SQL codes...
I tend to forget things so basically this is for me and for others who will going to find my post informative.
Here you'll find techniques, codes, How tos, Tips and Tricks, Interview Tips and a lot more, basically more on my experiences as an Oracle Developer.
Oracle Programmer vs. Oracle Developer
Is there a difference? for me yes, a lot.. not that I see programmers less than developers, but being a developer makes you step to the higher level, and requires years of experience. A programmer merely codes based on requirements, but a developer can handle system development from data gathering to system implementation. So I guess that gives you a hint of what I'm doing.
Well this is not a tutorial blog.. this is again, basically a repository of my works, and sharing of my experiences
Subscribe to:
Comments (Atom)