Other News

Community

Use Oracle VARRAY Through JDBC

(Vijayanandraj Amaladoss) This code snippet demonstrates how to use Oracle VARRAY through JDBC. The code does three things: –It creates VARRAYs of different lengths. –It contains a table to store data of above array type. –Stores the objects in an array, and inserts them into database

Community

Lookup Table Design

(Leo Peysakhovich) When I begin to design a new database for a client, one of the dilemmas facing me is how to construct lookup tables. When we say that a table is a lookup table for another main table, we mean that the lookup table contains values that will be used as the content of a column lo