This post originated from an RSS feed registered with Java Buzz by justin cater. Original Post: All You Ever Need to Know About Recursive SQL Feed Title: Java Code Geeks Feed URL: http://feeds.feedburner.com/JavaCodeGeeks Feed Description: Java 2 Java Developers Resource Center Latest Java Buzz Posts Latest Java Buzz Posts by justin cater Latest Posts From Java Code Geeks

Oracle SYNONYMs are a great feature. You can implement all sorts of backwards-compatibility tweaks simply by creating SYNONYMs in your database. Consider the following schema:                 CREATE TABLE my_table (col NUMBER(7)); CREATE SYNONYM my_table_old FOR my_table; CREATE SYNONYM my_table_bak FOR my_table_old; Now you can query your same old […]