Re: How to Export Database into csv files
Date: Wed, 2 Jul 2008 07:30:07 -0700 (PDT)
Message-ID: <06cb73d1-665f-43c9-bf3d-59f739b30ae9@d77g2000hsb.googlegroups.com>
On Jun 26, 12:27 pm, Ed Prochak <edproc..._at_gmail.com> wrote:
> On Jun 12, 9:54 am, timmg <tmillsgronin..._at_gmail.com> wrote:
>
> > What's the problem, Ed? The table prefix? Querying the MSysObject
> > table?
...
>
> The table name prefix is the problem. Its a form of Hungarian notation
> and NOT a reasonable naming convention IMHO....
Ah, the benefits of civil responses over flames - turns out we're on common ground. I have some troubles with tbl as a prefix as well. I tend to use it in VB/Access, where knowledge of the datatype - query v. table makes sense in code. Within Oracle it is, I agree, a bit of a repetitive redundancy.
And I think that we're in agreement that _some_ kind of naming convention is a good thing.
Right now I'm working on an application where some of the data will reside in Oracle - CONTROL_LIST, for example. Within Access there is a link to that table called tbl_CONTROL_LIST. It's enough to give me what I need to manage the Access code without worrying about unnecessary overhead in Oracle.
Tim Mills-Groninger Received on Wed Jul 02 2008 - 09:30:07 CDT