All,
How can I do "update statement" updates changed columns only?
Ex: TABLE A (
ID NUMBER,
DESC VARCHAR,
CAT VARCHAR)
I need update only CAT field, but the code generate for p6spy is:
UPDATE A
SET DESC = 'XXXXXXXXXXXX',
CAT = 'P'
WHERE ID = 1
[],
Francisco Bruno
Analista de Sistemas
OFM Tecnologia & Informa��o
-----------------------------------------------------------------------------------------------------------------
"Fa�a as coisas o mais simples que voc� puder, por�m n�o as mais simples."
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
