Re: [SQL] After updating dataset the record goes to the end of the dataset

2008-04-22 Thread Padam J Singh
Nacef, Simply add a SERIAL column to your table. When you add a new row, a new value will be stored in this column if you do not specify the column name in the insert query. In your select query, always order by this column. When doing an update , do not update this column. When re-ordering, u

[SQL] Function Dependency

2006-02-01 Thread Padam J Singh
Hello, I am maintaining an application that has over 400 procedures and functions written in plsql, and around 100 tables. I want to generate a function dependency chart to depict the following: 1. Inter function/procedure dependencies 2. function-tables dependencies 3. function-sequences dep