Answer: How to update base table (data dictionary) automatically in every 5 sec or 5 min?
February 02, 2009 05:45:23
#1
saikatrana
Member Since: February 2009 Total Comments: 3
RE: Base Table Update
If you want to update a base table you will have to run this command. Suppose, my
base table is Student & its columns are Name&Age, then use this command to update:
update student set Name='Graham', Age=30;
Then all the records of the table will be updated containing name as "Graham'' & Age as 30
If you want to update only your desired columns against a defined column value follow the statement written below:
update student set Name='Graham', Age=30 where name='Carey';