12,522 reputation
12036
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 11 months
seen 18 mins ago
Oracle ACE

16h
comment DB Design storing products sold in bulk, priced by vastly different units
Is each product always sold by a single unit? Or are there products that can be sold by multiple units? It sounds like you are saying that a particular product will always be sold by a single unit.
Dec
14
revised Dual site active-active highly available database
edited tags
Dec
10
comment Extract from Oracle at given time
Total recall/ flashback data archive was introduced in 11g, I believe, so it wouldn't be available to the original poster that is trying to use 9i and 10g. Since you mention licensing, flashback data archive becomes part of the database license in 12.1, it's no longer an extra cost option.
Nov
23
awarded  Nice Answer
Nov
23
answered Professor told us to store serialized Java objects as blobs instead of defining relational tables
Oct
23
comment The most important oracle database performance metrics
What is the problem that you're trying to solve? Identifying 10 metrics which are most relevant to my systems probably does you little good because your systems probably have very different characteristics. Some systems have I/O as their primary bottleneck, some have CPU, some have networking, some have user locks. My systems might be more (or less) memory constrained than yours leading me to care about different metrics than you.
Oct
21
comment Is there anyway to search PL/SQL reserved words with contains function?
What do you consider "Oracle reserved words"? "do", for example, is not a reserved word in v$reserved_words.
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
Are you trying to search the text of code stored in Oracle (which is what I initially read your question as asking)? Or are you trying to search for data stored in a user-defined table? If you're searching for data in a user-defined table, can you create an Oracle Text index on that table?
Oct
20
comment Is there anyway to search PL/SQL reserved words with contains function?
@Andy - Sorry, I'm afraid that comment doesn't clarify anything for me. It may be useful to expand your question to include, say, a few example pieces of code, the types of searches you want to run, and the expected results of those searches on that sample code. Neither "for test" or "do test" are keywords in PL/SQL-- "for" is a keyword but neither "do" nor "test" are.
Oct
20
answered Is there anyway to search PL/SQL reserved words with contains function?
Oct
17
comment grant permissions in oracle from one database to another
@KyleM - It would be whatever the TNS alias on the EmployeeDB database for the ContractorDB database is. That's generally going to be the same as the name of the database but that's just a naming convention-- your TNS alias might be different.
Oct
17
answered grant permissions in oracle from one database to another
Oct
17
awarded  Enlightened
Oct
17
awarded  Nice Answer
Oct
14
comment What do these pstart and pstop values mean?
@jubil - Short of tracing the session, I don't know of a way to do that.
Oct
13
answered What do these pstart and pstop values mean?
Oct
13
comment work with json in oracle
What version of Oracle? 12c introduces native JSON types.
Oct
12
answered How to design tables such that a person can work for many companies?
Oct
9
comment Is it impossible to iterate table rows in Oracle PL/SQL without using a cursor?
Why do you ask? What problem are you trying to solve? "without using a cursor" is also rather problematic since each and every SELECT statement opens a cursor. Both your examples use exactly the same number of cursors (or would if they worked). A SELECT ... INTO that returns anything other than 1 row will throw an exception no_data_found or too_many_rows so it would never make sense to check the rowcount (which I assume you meant rather than rownum) after doing a SELECT INTO.
Sep
30
awarded  Explainer