drop all tables and sequences in oracle
by Michał Kuklis on 18/05/2009tables:
SELECT 'DROP TABLE ' || TABLE_NAME || ' CASCADE CONSTRAINTS;' FROM user_tables;
sequences:
SELECT 'DROP SEQUENCE ' || sequence_name || ';' FROM user_sequences;
tables:
SELECT 'DROP TABLE ' || TABLE_NAME || ' CASCADE CONSTRAINTS;' FROM user_tables;
sequences:
SELECT 'DROP SEQUENCE ' || sequence_name || ';' FROM user_sequences;
Looks like google engine will support java. Pretty exciting
Here are few links which helped me understand few ruby concepts:
GIT is becoming more popular so I’ve decided to start using it. I found few good resources:
A Friend of mine introduced me to GNU screen a great tool which can be used in different ways. One of them is a session sharing which is awesome when 2 or more people are working together in Linux env.
I’m still looking around for a stage deployment setup with Capistrano.
Here are few ideas/links I found useful.
Update:
It turned out this is pretty simple with the capistrano-ext gem:
http://weblog.jamisbuck.org/2007/7/23/capistrano-multistage
set :default_stage, "development" set :stages, %w(production testing development) require 'capistrano/ext/multistage'
deactivate site:
a2dissite site_name
activate site:
a2ensite site_name
New release contains new selector engine called Sizzle (the fastest css selector out there) and live events (which work similar to the live query plugin).
More details can be found here
I’m planning to pass SCJA and SCJP at the end of this year. I will post all the mocks and materials which I find helpful. Here is the first list:
Tutorials/Books
Mocks:
UML
Tutorials/Books