sp_helptext for views in Oracle

So easy and I didn’t know...

 

select VIEW_NAME, TEXT
from all_views     
where
      VIEW_NAME = 'MYVIEW'

 

 

Crystal Reports for Download

Page has versions of Crystal Reports from v. 9.1 to 13.x for download.

 

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567

 

Get the IT career you want: Develop business value - Page 1 - IT Workplace

Get the IT career you want: Develop business value - Page 1 - IT Workplace

VS2010AutoScroller - Release: AutoScroller v0.4.2

I have no idea why Microsoft does this. They took the autoscroll functionality from Visual Studio 2010!
So, to solve this problem I found this extension!
VS2010AutoScroller - Release: AutoScroller v0.4.2: "AutoScroller.vsix"

After you finish download the file, you can copy the file into %appdata%\Local\Microsoft\VisualStudio\10.0\Extensions
folder.

Then you open VS2010 and... enjoy it!

Renaming a column using oracle from version 9i

ALTER TABLE <TABLE_NAME> RENAME COLUMN <CURRENT_COLUMN_NAME> TO<NEW_COLUMN_NAME>;

TO_DATE Oracle Function

Syntax: TO_DATE (date, format) 

 

Example: TO_DATE('11/11/2010 13:00:00', 'dd/MM/YYYY HH24:MI:SS')  - in this case for 24 hours. For 12 hours, you should also specify AM or PM.

 

Find out more in this website (another one that I hope lasts forever) - http://www.techonthenet.com/oracle/functions/to_date.php

 

 

Oracle JDBC string Connection for thin driver

Simple, simple (I took too much time trying to find this string)…

 

jdbc:oracle:thin:[user/password]@//[host][:port]/SID