Talk:SQLJ

From Wikipedia, the free encyclopedia

> It is more efficient than JDBC since the SQL statements are parsed and the access paths are optimized at compile time rather than runtime.

Ridiculous. SQLJ is simply a precompiler syntax. In Oracle, it's like all other precompilers. The ONLY difference, w/r to compiling, is that SQLJ, since it is a precompiler, will check the syntax is valid. It does NOT optimize at this point, since there is no way to save the optimized plan (other than manually creating a stored plan). So both SQLJ and JDBC will be parsed and compiled the wsame way at run-time.

> It provides better authorization control: Authorization can be granted to programs rather than users.

What the hell is this about??????