May 2012
2 posts
Oracle - What Version?
Command to give details on the current running version of Oracle.
select * from v$version;
Oracle - Sequences Stuff
Drop a sequence:
DROP SEQUENCE SEQUENCE_NAME;
List all sequences:
For current user
SELECT * FROM USER_SEQUENCES;
For all users
SELECT * FROM ALL_SEQUENCES;
February 2012
1 post
Oracle - using a date in the where clause
select * from foo where bar_date=to_date(‘22-FEB-2012’,’dd-MON-yyyy’)
October 2011
1 post
Search SQL Server 2005 Stored Procedure Text
How to search the content of stored procedures in a SQL Server 2005 database:
SELECT Name, OBJECT_DEFINITION(OBJECT_ID) FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SEARCH_TERMS%'
September 2011
1 post
Using keepalives in PuTTY ssh sessions
When using PuTTY, an ssh session to a remote server can be disconnected due to inactivity. If you need to make sure the connection is maintained you can send keepalives - small regular blips of data - to the remote server. Keepalives are enough to convince the server that the connection is still active.
To turn keepalives on go to the top level of the section Connection on the PuTTY Configuration...