Archives: 02/25/2012

RECOVERY ADMIN PASSWORD

Windows XP: many times you cannot boot into normal Windows mode because of wrong user password, you can start Windows XP in safe mode and login the default admin account to bypass other user password.

LEARNING

– http://codex.wordpress.org/Developer_Documentation – http://humanshell.net/wordpress/wordpress-initialization/

MACRO

To create: Dev –> Visual Basic To use: Dev –> Macro Sub Fornitori() Sheets(1).Select Range(“G5”).Select Selection.Offset(0, 0).Value = Selection.Offset(1, -5).Value Selection.Offset(0, 1).Value = Selection.Offset(1, -4).Value Selection.Offset(0, 2).Value = Selection.Offset(1, -3).Value Selection.Offset(0, 3).Value = Selection.Offset(1, -2).Value Selection.Offset(0, 4).Value = Selection.Offset(1, -1).Value Range(“G6”).Select Selection.EntireRow.Delete Range(“G6”).Select Do Until Selection.Offset(0, -6).Value = “prova” If Selection.Offset(0, -6).Value <> “—” Then…

IMPORT EXCEL

There are two ways to load data from excel sheet . A easy and a difficult. The difficult one is to create a utl directory, put the csv over there and create a procedure that reads every line and inserts it in the table. But this solution is very big, and I can´t show here (not…

MQSERIES

MQSeries is an IBM software family whose components are used to tie together other software applications so that they can work together. This type of application is often known as business integration software or middleware. MQSeries consists of three products: MQSeries Messaging, which provides the communication mechanism between applications on different platforms MQSeries Integrator,which centralizes…

CONNECT BY

With the CONNECT BY LEVEL approach there is also no need to use the Join Method. Multiple integer series can be created using a query like this one: SELECT to_date(to_char(sysdate – 365, ‘YYYYMMDD’), ‘YYYYMMDD’) + level DT_DAY FROM dual WHERE LEVEL <= 395 — 1 year ago, 1 one month in advance CONNECT BY LEVEL…

Go Top