var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Updating From Cursor
when we are updating a table from cursor is it necessary that the curstructure and destination table structure is exactly same or with diff???
Re: Updating From Cursor
What do you mean by "updating a table from cursor" and "curstructure"?
You can certainly do this:
CREATE TABLE t1 ( a, b, c);
CREATE TABLE t2( x, y );
CURSOR c IS SELECT a,b,c FROM t1;
FOR r IN c LOOP
UPDATE t2 SET x = r.a WHERE y = r.b;
Is that what you meant?
If i have table1 structure
other table is empno varchar2(10)
so when i am selcting in to cursor is that selection should be in same order of updating table or it is not a problem..
What does your update look like? You can see from my previous post that order, number and name of columns is irrelevant in the type of update I was showing.