Tech Notes: Spring Cache + Couchbase NoSQL DB

Tech Notes: Spring Cache + Couchbase NoSQL DB: This post expands on the previous Library example using Couchbase as NoSQL database. You can download and configure Couchbase server from ...

Drop all tables, constraints, and sequences within an Oracle schema

Drop all tables, constraints, and sequences within an Oracle schema.

refer link: https://snipt.net/Fotinakis/drop-all-tables-and-constraints-within-an-oracle-schema/

BEGIN

FOR c IN (SELECT table_name FROM user_tables) LOOP

EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');

END LOOP;

FOR s IN (SELECT sequence_name FROM user_sequences) LOOP

EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);

END LOOP;

END;

Hibernate Caching

refer to :
 http://www.javabeat.net/introduction-to-hibernate-caching/
http://www.tutorialspoint.com/hibernate/hibernate_caching.htm