As a software vendor, let me tell you that what we are talking about here is not encrypting at all, just obfuscation. In order for code to run it...

Exactly what is the advantage of DBMS_APPLICATION_INFO over a profiler? What can DBMS_APPLICATION_INFO do that a profiler can't? Just seems a lot of work for nothing...

"So if you want to memorize functions that you can't remember the syntaxes for, write an article for SQLServerCentral.com. "

Thats good advice.

I think this whole role based security thing is obsolete. What we need is a three or four dimensional security model. The dimensions are user group (admin/data entry...

"Unless you think that no level of scrutiny is reasonable, and that all should pass unhindered."

Scrutiny by customs assumes that it is the international travelers who are the greatest threat...

"So you don't lock your car or house right and never encrypt anything?"

So you are saying racial segregation is Ok? So is it ok for White people to lock out...

Another question: If a texan goes on a shooting rampage would you start screening all texans at your state border to see if they are hostile to your state?

"Just what do you think the Chicoms, Venezuelans or Cubans would do? It CAN be much worse. "

WTF? Is this some new kind of apartheid? Doesn't anyone here support a...

I think in this modern world, we can't expect much privacy, so we should get over it. Anyway I don't think we can do much about it if prospective...

Abnormal exit (like a throw or return or error exception) of a try block has a big performance hit. Normal entry and exit of a try block has no...

I think that the best 'soft' skills teacher is the book 'How to win friends and influence people' by Dale Carnegie. This book should be read once a year. ...

Even if Oracle does lock, I still think that this locking concept itself is primitive. Queuing is much better than locking. Both for reading AND WRITING. What do you...

"add 3 column as share (S), fixedincome(FI) , components(C) ,

and make entries as 1 and 0 values,

if 1 then present and 0 for Not present,"

Don't add columns for different data....

Partitioning is available only for SQL 2005 and above. Also only a maximum of 1000 partitions can be made on a table.

It seems primitive to require locks for any read operation. In Oracle I think readers don't lock/block anything.