=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student ; f1
=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student ; f1
=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student ; f1
teledb=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student
=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student ; f1
=# set enable_oracle_compatible to on; SET teledb=# create table student(f1 int,f2 int); CREATE TABLE teledb=# insert into student values(1,1); INSERT 0 1 teledb=# update student st set st.f2=2 where f1=1; UPDATE 1 teledb=# select * from student ; f1