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)

Erros de palmatória...para quem?

(...)Quanto maiores são as deficiências dos estudantes, menor é o grau de exigência dos professores. Miguel Morgado reconhece que se foi tornando mais tolerante com as falhas dos alunos e hoje há erros que já não considera "assim tão graves". João Gouveia Monteiro admite que entre a classe docente há uma tendência para nivelar por baixo: "Eu, por exemplo, no primeiro semestre do ano passado, chumbei 75% dos meus alunos e, mesmo assim, considero que não fui rigoroso." Isabel Ferreira confessa que teve necessidade de tornar a sua linguagem mais básica para poder ser entendida pelos alunos. O nível de exigência foi descendo sobretudo porque os alunos têm deficiências de base não só a português como a matemática e a física: "Seria impensável fazer testes com enunciados de há 15 anos. Os resultados seriam desanimadores." João Gouveia Monteiro usa outro exemplo para defender a mesma ideia. "A classificação de 18 valores numa prova de hoje equivale aos 12 valores de há 15 anos", conclui.

http://www.ionline.pt/conteudo/55357-erros-palmatoria-cada-vez-mais-frequentes-universitarios

De quem é a culpa? Quem merece a palmatória?

Outlook stored rules problem

Today I got in Outlook "Your stored rules appear to have a bad format." when trying to create a rule (and the rules window also got me that problem).

Solution: to start Outlook by command line cleaning all the previous existing rules

C:\Program Files (x86)\Microsoft Office\Office12\Outlook.exe /cleanrules
(change the folder according to your Office installation version and OS version)

Oracle 11g R2 Available for windows 32 bits and x64

Finally Oracle 11 Release 2 is available for windows systems!

PL/SQL Challenge already started!

"The Challenge is free and simple: you play the quiz each weekday. We keep score. You get ranked. Every three months, the top-ranking players compete in a quarterly championship to award first, second and third prizes. Cash prizes, among others. But that's not all. Every month, we will raffle off other prizes to anyone who played the quiz that month. And the more you play, the greater your chance of winning."

Go play!
http://plsqlchallenge.com/