Replies to This Discussion

Permalink Reply by Jesus Armand Calejero Roman on April 29, 2008 at 1:26am

Hello. third column, will be null or not null??

Not null and default value
alter table employees add co_workers varchar2(30) default ‘12345678901234567890′ not null;

▶ Reply to This

Permalink Reply by Stew Stryker on April 29, 2008 at 10:37am

Jesus,

If you respond to people who are too lazy to read the manual, you only encourage them to continue being lazy. I ask a lot of questions in the Oracle forums, but only after I've researched the topic through hardcopy and online reference sources.

At least that's my opinion. I'd be happy to hear others' thoughts on the subject.

- Stew

▶ Reply to This

Permalink Reply by Eddie Awad on April 29, 2008 at 10:49am

My thought is that in addition to answering the question like Jesus did, or even answering with RTFM, a link to the documentation may be helpful. For example, in this case, the SQL Language Reference, or even the whole DB documentation set.

However, there is something flawed in Manikandan's question in the first place. I believe that storing "co-workers" in "won column" is not the right design.

▶ Reply to This

Permalink Reply by Stew Stryker on April 29, 2008 at 2:27pm

Eddie,

Sounds like a plan, from now on when I see an incredibly basic question (as this seems to be), I'll reply with "RTFM" and include the link to the docset, so they can't say I wasn't helpful!

Given his question, do you think he's ready for following the Third Normal Form rule??? ;-)

▶ Reply to This

Permalink Reply by Jesus Armand Calejero Roman on April 29, 2008 at 1:56pm

Hi Stew.

I just tried to help but your comment is absolutely correct. Manikandan has to search his doubts and if he don't find any answer he make a post.

▶ Reply to This

Permalink Reply by Russell Gold on May 10, 2008 at 6:33am

Wow tough crowd!! Nothing like a bit of tough love.

How about a bit of prodding though? I see a deeper learning opportunity here.

Following Stew's comment.

Mani (if I may be familiar), is wanting to add a column with co-workers. To me this denormalizes his application.

1. What make one a co-worker? Consider the following -
A. Department - already there
B. Company - We could possibly assume this is for one company, if not see C
C. Sub-department/Work group - Make an additional table and add a work group column to the table. (

Just a different line of thinking and extra RTFMing and experimenting.

Russell

▶ Reply to This

Permalink Reply by Russell Gold on May 10, 2008 at 6:49am

Ran out of time to edit :)

Third Normal Form - Wikipedia

▶ Reply to This