meta user
network profile
| bio | website | tonyandrews.blogspot.com |
|---|---|---|
| location | London, United Kingdom | |
| age | ||
| visits | member for | 2 years, 8 months |
| seen | Jan 4 at 13:50 | |
| stats | profile views | 21 |
I have been working with Oracle databases for over 15 years, including a couple of years working as a Senior Consultant for Oracle UK Ltd. Now I work as an independent consultant specialising in design and build of Oracle databases and applications, particularly using Oracle Application Express.
I also play lead guitar in a great band called The Love Handles.
|
Sep 21 |
awarded | Yearling |
|
Sep 22 |
awarded | Yearling |
|
May 13 |
awarded | Commentator |
|
May 13 |
comment |
What do you call a “cell” in database terminology? There is no "cell", no "placeholder" in a database. I would say you select/insert/update the "column" on the specified row(s). A "field" or "cell" only appears when you view the data in a screen or report of some sort. You could say I'm being pedantic; to which I would reply: it depends on exactly how you define "pedantic" ;-) |
|
May 13 |
comment |
Constraints in a relational databases - Why not remove them completely? Yes and don't forget - don't forget - that Ebay, like Facebook and Amazon - is a gazillion times bigger than 99.99% of databases, and what is good for them is probably very different from what is good for your database. |
|
May 13 |
comment |
What do you call a “cell” in database terminology? Well I imagine the W3schools definition of UCASE is less accurate than mine, unless "field" is a synonym for "value". What about UCASE('hello') - is 'hello' a "field" too? |
|
May 13 |
comment |
What do you call a “cell” in database terminology? Yes I just found that one myself. It is referring to internal physical storage of dates rather than the logical date value itself, though. |
|
May 13 |
comment |
What do you call a “cell” in database terminology? @Mark: 11,800,000 Google hits for "mark booth is wrong"! Proves...? |
|
May 13 |
comment |
What do you call a “cell” in database terminology? @lee, I can't follow the link you posted but I haven't managed to find any reference to columns or column values as "fields" in the Oracle docs I have searched so far. I stand by my "absurd" claim! |
|
May 13 |
comment |
What do you call a “cell” in database terminology? -1 It is never correct to use the term "field" in the context of a database. |
|
May 13 |
answered | What do you call a “cell” in database terminology? |
|
May 13 |
comment |
What do you call a “cell” in database terminology? W3schools is not the ultimate arbiter of correctness. I would say that function converts a value to uppercase. |
|
Apr 18 |
awarded | Critic |
|
Apr 7 |
awarded | Good Answer |
|
Apr 7 |
awarded | Nice Answer |
|
Feb 8 |
comment |
Foreign key restrictions -> yes or no? How many projects can you have done and yet ask both this and stackoverflow.com/questions/4932625/… ? Good grief! |
|
Feb 2 |
awarded | Editor |
|
Oct 12 |
awarded | Teacher |
|
Oct 12 |
answered | Is the agile approach too much of a convenient excuse for cowboys |
|
Sep 23 |
comment |
What are the arguments against or for putting application logic in the database layer? @ChrisB: for Oracle there is plunit.com/index.htm |
