Can you fix the bug in the following code?

Here is the code:

begin
FOR c_d
IN (SELECT *
FROM table_a
)
LOOP
c_d.id := NULL;

INSERT INTO table_a values (c_d);
END LOOP;
end;

this gives an ORA-00947: not enough values
in the line of "INSERT INTO table_a values (c_d);"

How to fix it?

Today's mood

How to kill the right SQL Navigator session

Hi

If you have several SQL Navigator Sessions and want to kill one of them due to something (normally SQL Navigator hanged or is doing something and will not abort) try this:
1- open Quest SQL Tracker
2- select all the SQL Navigator processes
3- check which session is not the ones you want to maintain (for that you could, for instance, make a 'select 1 from dual' )
4- check the PID....and using windows's task manager kill the session with that PID (maybe you need to include that column in the task list)

it was very helpful today...

OracleJVM to Java SE Compatibility

Today a colleague asked me about the java version in Oracle 11g.
I answered him using a query to a 11g r2 DB (it has 1.5.0_10) ...but now i found this "compatibility table"

El Alma En Pie

El Alma En Pie

Digital version of Oracle Magazine May/June 2010 available

Digital version of Oracle Magazine May/June 2010 available

Update: direct link for facebook version (it doesn't need subscription info)