Daily Archives: February 21, 2014

Quickly searching bashs history

For me one of BASHs kill features is the possibility to quickly search the history of commands you entered: press CTRL + R and begin typing the command you’re looking for. Assume you want to (re-)install a maven project on … Continue reading

Posted in Apple, IT, Linux, OS X, shell, Unix | Tagged , , , , | Leave a comment

Video Tutorial on Talend Open Studio

My experience with etl tools is limited. In my current project we use talend open studio (tos) to manage our assets. I found good video tutorials on tos on youtube: Importing data from csv-file into tos Working w databases Importing Excel … Continue reading

Posted in Database | Tagged , , , | Leave a comment

Finding Primary Keys in Oracle

A Query i use from time to time to find out which primary key columns are defined for a certain table: SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner FROM all_constraints cons, all_cons_columns cols WHERE cols.table_name = ‘_TABLE-NAME_’ AND cons.constraint_type = ‘P’ … Continue reading

Posted in Database, Oracle | Tagged , , | Leave a comment