Script to find open active transactions and sessions at database level...

This quick XQuery script was created to answer a question asked on my blog recently. The following code uses the XQuery functions "position()" and "last()" to determine the last element....

We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....

We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....