11,403 reputation
11832
bio website ddbcinc.com
location Rochester Hills, MI
age 37
visits member for 3 years, 3 months
seen 7 hours ago
Oracle ACE

Mar
27
answered Update many rows in a table with a single statement?
Mar
27
comment How do I manage column order when using PL/SQL's %ROWTYPE records?
@GlennMoss - Why are columns getting added in different orders in different environments? Normally, you'd have a script that you ran in development to add a few new columns that would be run in test, then staging, then prod so that all the environments have exactly the same definition of the table. And, periodically, you'd refresh the lower environments with clones of production.
Mar
27
answered How do I manage column order when using PL/SQL's %ROWTYPE records?
Mar
22
comment How to convert postgresql dump files to oracle dump files?
@user534817 - How much data are we talking about? How many hours do you have? Can you connect from the server with the Oracle database to the server with the PostgreSQL database? How much bandwidth do you have between the two servers?
Mar
21
answered How to convert postgresql dump files to oracle dump files?
Mar
21
comment Is it safe to delete dummy tables Oracle 11g XE
@JoseDavidGarciaLlanos - Where are you seeing the table names displayed? Assuming that you are creating a new schema for your objects rather than trying to reuse a schema that Oracle delivers (and there are a number of them with a number of different tables none of which should be dropped or deleted from), you can just query the USER_TABLES view rather than DBA_TABLES or ALL_TABLES to see just the tables in your current schema.
Mar
21
answered Is it safe to delete dummy tables Oracle 11g XE
Mar
21
revised Is it safe to delete dummy tables Oracle 11g XE
deleted 94 characters in body
Mar
14
comment Product of n Rows
@LeighRiffel - Figured out how to do it with recursive CTE's as well. You could almost certainly do it with the MODEL clause too... I may be able to figure that one out later today.
Mar
14
revised Product of n Rows
added 994 characters in body
Mar
14
answered Product of n Rows
Mar
13
revised How to qualify variable inside trigger body (PL/SQL )?
Fixed the plsql tag (not plpgsql)
Mar
13
revised How to identify fragmentation level of the table data itself not the table indexes, and then defrag
edited tags
Mar
12
awarded  Nice Answer
Mar
12
revised oracle 11g seems to die every 2 days, how can i debug what's happening?
added 995 characters in body
Mar
9
answered Are there any fully declarative implementations of SQL
Mar
7
answered Temporary replication of data between continental datacenters
Mar
7
answered Does an IOT guarantee order in a select?
Mar
7
comment Should date formats be specified in SQL statements?
@LeighRiffel - Or 2000 years off. I've seem many times where dates entered with 2 digit years were interpreted as first century AD because YYYY was part of the format mask that was eventually used. That works for a while when people are generally only displaying 2 digit years but then someone starts to sort data or display it using 4 digit years and everything gets hinkey.
Mar
5
awarded  Enlightened