Reputation
12,976
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 22 36
Newest
 Yearling
Impact
~617k people reached

Aug
25
revised How far should bind variables go in Oracle?
added 2282 characters in body
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - The guideline I'd give to users is that is a value might ever change, it should be a bind variable. If it's a simple hard-coded value that will never change, it should be a literal.
Aug
25
comment How far should bind variables go in Oracle?
@Michael-O - If the status will always be 2, every instance of the query will have the same sql_id and will appear once in the cache (barring cases where Oracle has two different plans for the same SQL statement). There won't be any benefit to converting status to a bind variable in that case.
Aug
25
answered How far should bind variables go in Oracle?
Aug
25
answered Estimate a Database Size
Aug
23
comment Updating Multiple Rows with Data from Column A into Column B?
@Phil - Yup. Fixed.
Aug
23
revised Updating Multiple Rows with Data from Column A into Column B?
added 1 characters in body
Aug
23
awarded  Nice Answer
Aug
23
revised Reason to not use nullable number in Oracle?
added 98 characters in body
Aug
23
answered Updating Multiple Rows with Data from Column A into Column B?
Aug
22
answered Reason to not use nullable number in Oracle?
Aug
22
answered Oracle: deleting data from tables leads to data file fragmentation?
Aug
21
comment Why Oracle sessions are still alive after two weeks being Inactive
I assume you meant IIS (Microsoft's HTTP/ app server), not ISS (the International Space Station) :-)
Aug
21
comment Why Oracle sessions are still alive after two weeks being Inactive
@Phil - I'd happily upvote that as an answer!
Aug
9
comment Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
OK, so there is no need to be able to apply any of the committed transactions that were made after you captured your copy of the data? You just want to be able to restore the point-in-time data that was present in the database when you generated the logical backup?
Aug
8
comment Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
What is the business problem you are trying to solve? Normally, when people talk about backing up an Oracle database, they are trying to generate a physical backup. Not a logical backup using the Oracle export utility.
Jul
29
revised How to store several lists and their items
added 28 characters in body
Jul
29
revised How to store several lists and their items
added 40 characters in body
Jul
29
comment How to store several lists and their items
@bernk - If each list relates to a single project, then I would get rid of the project_list table and add the project_id to the LIST table. It seems odd that you wouldn't want to potentially reuse a list across multiple projects though-- it seems like that would force users to do a lot of redundant data entry.
Jul
29
answered How to store several lists and their items