Open Source Software in Java(tm)
Open Source Software in Java(tm) - posted by Saravanan Jayachandran @ 3:49 AM Permanent Link (0) comments

www.KickJava.com: Free Java Books
www.KickJava.com: Free Java Books - posted by Saravanan Jayachandran @ 3:45 AM Permanent Link (0) comments

All About MySQL 4.1
All About MySQL 4.1 - posted by Saravanan Jayachandran @ 10:43 PM Permanent Link (0) comments

Learning Guide: SQL
Learning Guide: SQL - posted by Saravanan Jayachandran @ 9:36 PM Permanent Link (0) comments

Learning Guide: DB2 basics
Learning Guide: DB2 basics - posted by Saravanan Jayachandran @ 9:33 PM Permanent Link (0) comments

Learning Guide: SQL Server basics
Learning Guide: SQL Server basics - posted by Saravanan Jayachandran @ 9:32 PM Permanent Link (0) comments

Multi-table insert : Oracle 9i or higher
1. Conditional Multi-table insert :
INSERT ALL
WHEN (period=6) THEN
INTO course_6 (course_name, period) values(course_name, period)
WHEN (period=3) THEN
INTO course_3 (course_name, period) values(course_name, period)
ELSE
INTO course_other (course_name, period) values(course_name, period)
SELECT course_name, period FROM course;
What does the above query do ?
1. Insert courses for period 6 into the table named COURSE_6.
2. Insert courses for period 3 into the table named COURSE_3.
3. Insert all other courses into the table named COURSE_OTHER
4. The ALL keyword causes Oracle to check each row returned by the SELECT query against each WHEN clause. If a row satisfies more than one WHEN clause, it is inserted into more than one table. Use the FIRST keyword to limit inserts to only the first matching WHEN clause.
2. Unconditional Multi-table insert :
INSERT ALL
INTO courses_taken (course_name) values (course_name)
INTO students_registered (student_name) values (student_name)
SELECT course_name, student_name
FROM enrollment;
- posted by Saravanan Jayachandran @ 9:21 PM Permanent Link (0) comments

Introducing Java 5 [Java and J2EE]
Introducing Java 5 [Java and J2EE] - posted by Saravanan Jayachandran @ 2:44 AM Permanent Link (0) comments

Technical Journal: SQL query to identify list of duplicate rows
Technical Journal: SQL query to identify list of duplicate rows - posted by Saravanan Jayachandran @ 2:10 AM Permanent Link (0) comments

Optimizing MySQL: Queries and Indexes
Optimizing MySQL: Queries and Indexes - posted by Saravanan Jayachandran @ 8:54 PM Permanent Link (0) comments

MySQL Subqueries
MySQL Subqueries - posted by Saravanan Jayachandran @ 8:54 PM Permanent Link (0) comments

Useless Facts from Brain of Brian -- People 1
Useless Facts from Brain of Brian -- People 1 - posted by Saravanan Jayachandran @ 1:56 AM Permanent Link (0) comments

Bruce Eckel's MindView, Inc: 7-9-04 Java Issues & Directions
Bruce Eckel's MindView, Inc: 7-9-04 Java Issues & Directions - posted by Saravanan Jayachandran @ 10:23 PM Permanent Link (0) comments

Why Java Sucks [ ZefHemel.com ]
Why Java Sucks [ ZefHemel.com ] - posted by Saravanan Jayachandran @ 10:22 PM Permanent Link (0) comments

Why Java Sucks For Sysadmins
Why Java Sucks For Sysadmins - posted by Saravanan Jayachandran @ 10:21 PM Permanent Link (0) comments

java sucks
java sucks - posted by Saravanan Jayachandran @ 10:20 PM Permanent Link (0) comments

Oracle Database Online Documentation 10g Release 1 (10.1)
Oracle Database Online Documentation 10g Release 1 (10.1) - posted by Saravanan Jayachandran @ 4:06 AM Permanent Link (0) comments

Oracle Database Online Documentation 10g Release 1 (10.1)
Oracle Database Online Documentation 10g Release 1 (10.1) - posted by Saravanan Jayachandran @ 3:58 AM Permanent Link (0) comments

Articles about MySQL
Articles about MySQL - posted by Saravanan Jayachandran @ 3:04 AM Permanent Link (0) comments

The Pragmatic Programmers, LLC
The Pragmatic Programmers, LLC - posted by Saravanan Jayachandran @ 3:03 AM Permanent Link (0) comments

Ease of Development in Enterprise JavaBeans Technology
Ease of Development in Enterprise JavaBeans Technology - posted by Saravanan Jayachandran @ 3:03 AM Permanent Link (0) comments

JSP 2.0 Simple Tags Explained [Java and J2EE]
JSP 2.0 Simple Tags Explained [Java and J2EE] - posted by Saravanan Jayachandran @ 3:03 AM Permanent Link (0) comments

Prakash's Chronicle: ET Awards - Entrepreneur of The Year
Prakash's Chronicle: ET Awards - Entrepreneur of The Year - posted by Saravanan Jayachandran @ 10:35 PM Permanent Link (0) comments

Oracle Certification @ internetcareerresources.com
Oracle Certification @ internetcareerresources.com - posted by Saravanan Jayachandran @ 4:15 AM Permanent Link (0) comments

Oracle Certification @ internetcareerresources.com
Oracle Certification @ internetcareerresources.com - posted by Saravanan Jayachandran @ 3:39 AM Permanent Link (0) comments

CEO Bloggers' Club
CEO Bloggers' Club - posted by Saravanan Jayachandran @ 8:23 PM Permanent Link (0) comments