meta user
network profile
| bio | website | |
|---|---|---|
| location | Ottawa.Ontario, Canada | |
| age | 54 | |
| visits | member for | 1 year, 11 months |
| seen | 8 hours ago | |
| stats | profile views | 37 |
Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS
|
Sep 15 |
comment |
How do I correctly design this database? You should also have columns in the group and user tables for date created, date last modified, created by, last modified by and whether the group or user is disabled |
|
Sep 15 |
accepted | Consequences of changing NLS_TIMESTAMP_FORMAT |
|
Sep 14 |
asked | Consequences of changing NLS_TIMESTAMP_FORMAT |
|
Sep 12 |
awarded | Citizen Patrol |
|
Sep 11 |
comment |
Revenue Assurance database creation More information is required: type of data that will typically be entered (VARCHAR2, NUMBER, CLOB), type of transactions (data entry, reporting), version of database would be helpful |
|
Sep 10 |
answered | Is it safe to let application administrators look at v$session, v$process, and v$sql? |
|
Sep 9 |
answered | Is there a reason to use extremely abbreviated table names? |
|
Sep 8 |
answered | Undo DDL statement on View in Oracle |
|
Sep 8 |
answered | What to do with those invalid JAVA CLASS object type objects in SYS prior to the upgrade the oracle db from 10g to 11g? |
|
Sep 7 |
answered | Oracle 11g setup closes without errors on pre-requisite check |
|
Sep 7 |
revised |
Materialized views master table expanded on op's comment |
|
Sep 6 |
awarded | Organizer |
|
Sep 6 |
revised |
Materialized views master table question applies to multiple versions of oracle |
|
Sep 6 |
suggested | suggested edit on Materialized views master table |
|
Sep 6 |
answered | Materialized views master table |
|
Aug 28 |
comment |
How to make a duplicate field cheap? How is the information entered in each table? Does one process write to each table consecutively? Or does the second entry get created later? |
|
Aug 27 |
answered | Join condition on complex views |
|
Aug 26 |
awarded | Analytical |
|
Aug 26 |
comment |
Can you trigger an action when a view is created? this is how you can comment on a view: comment on table aschema.myview is 'number of issues by calendar year'; (notice how even if it is a view you have to say table) SELECT * FROM all_tab_comments WHERE owner = 'aschema'; but you will need privileges to query these system data views |
|
Aug 26 |
answered | Full Name search query |
