OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CREATE TABLE (4.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CREATE TABLE [message #615733]

Sun, 08 June 2014 12:45

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

Hello! I never learned oracle sql developer and my boss asked me to do this simple database with urgency (the content is made up for giving an example):SEE FIGURE.

I am very worried I will not be able to do it. Please help me. I would be so grateful for any help at all! So many many thanks!

Attachment: A.JPG
(Size: 42.67KB, Downloaded 593 times)

Report message to a moderator

Re: CREATE TABLE [message #615734 is a reply to message #615733]

Sun, 08 June 2014 12:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

What exactly do you call a "database"?

What exactly do you desire from us?

http://docs.oracle.com/cd/E16655_01/server.121/e17633/tablecls.htm#CNCPT88808

[Updated on: Sun, 08 June 2014 12:50]

Report message to a moderator

Re: CREATE TABLE [message #615736 is a reply to message #615734]

Sun, 08 June 2014 12:53

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

i apologise but i also do not know very all what it means. i know i have many data that i need to organise in a table (like the one i gave in the image) into a database using oracle sql developer . does this make sense?

thank you so so much for your help

Report message to a moderator

Re: CREATE TABLE [message #615737 is a reply to message #615733]

Sun, 08 June 2014 12:55

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

hello. i wrote the table in mocrosoft word just as an example. i never used oracle sql developer. can you help me please? thank you very very much for your answer and any help at all.

Report message to a moderator

Re: CREATE TABLE [message #615738 is a reply to message #615737]

Sun, 08 June 2014 12:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I have no idea what you have, what you see or what you do; unless you actually tell me!

> i never used oracle sql developer.
What have you used?
Did you install SQL Developer on your PC?
Do you have username & password to log into some Oracle database?
Can you successfully connect to any Oracle DB?

PLEASE answer each & every question above

Report message to a moderator

Re: CREATE TABLE [message #615739 is a reply to message #615738]

Sun, 08 June 2014 13:04

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

i have used other programming software. i just want to find some help with the code for the table, then i will try to learn how to use the software by myself.
yes,i have the version of oracle sql developer version 4.0.2.
i dont know what you mean with connecting to 'Oracle database'

thank you so much

Report message to a moderator

Re: CREATE TABLE [message #615741 is a reply to message #615739]

Sun, 08 June 2014 13:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Tell your boss that this task should be assigned to somebody else who knows how to login & issue SQL to Oracle database.

Report message to a moderator

Re: CREATE TABLE [message #615742 is a reply to message #615737]

Sun, 08 June 2014 13:27

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

Sarah, you need to realize that an Oracle database can be used to manage whole countries. You cannot learn to use software like this by yourself. I certainly didn't. The fact that you do not know what is meant by "connecting to an Oracle database" implies that your boss has misunderstood your skills in this area. If you describe your circumstances in greater detail (in an appropriate forum) perhaps someone can dvise you on how to manage this situation. It is not a technical issue.

Report message to a moderator

Re: CREATE TABLE [message #615743 is a reply to message #615742]

Sun, 08 June 2014 13:35

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

thank you very much for your replies.

i was just asking the code for the table i posted in the figure. the rest i will manage to do it.

but i understand it is not possible. thank you very much again.

Report message to a moderator

Re: CREATE TABLE [message #615748 is a reply to message #615743]

Sun, 08 June 2014 15:41

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

is there any simpler software you would advise me to use when i have a table (like the one i showed with hundreds of pages)?

thank you very very much.

Report message to a moderator

Re: CREATE TABLE [message #615749 is a reply to message #615748]

Sun, 08 June 2014 20:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

MS ACCESS is simpler software

Report message to a moderator

Re: CREATE TABLE [message #615785 is a reply to message #615749]

Mon, 09 June 2014 04:25

sarahhhh
Messages: 7
Registered: June 2014

Junior Member

thank you very much for your answer and help.

the goal of this work is, given the example (but what i have is a table with +- 3000 lines):

[question] which countries? [answer] uk, belgium

[question] in UK how many names? [answer] one

which simpler software would you advise me to use for this goal? ms access or other?

thank you so so much.

Report message to a moderator

Re: CREATE TABLE [message #615789 is a reply to message #615785]

Mon, 09 June 2014 04:35

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Excel? (I mean, as simpler software).

[Updated on: Mon, 09 June 2014 04:35]

Report message to a moderator

Re: CREATE TABLE [message #615791 is a reply to message #615785]

Mon, 09 June 2014 04:55

flyboy
Messages: 1903
Registered: November 2006

Senior Member

sarahhhh wrote on Mon, 09 June 2014 11:25

thank you very much for your answer and help.

the goal of this work is, given the example (but what i have is a table with +- 3000 lines):

I really doubt you have any table as the only source you provided is some Word excerpt.

Welcome in the world of relational databases. Here are just a few basic definitions:
http://en.wikipedia.org/wiki/Relational_database
http://en.wikipedia.org/wiki/Table_%28database%29
http://en.wikipedia.org/wiki/Database_normalization
Anyway,
Quote:

[question] which countries? [answer] uk, belgium

SELECT <country column> FROM <your table>;

Quote:

[question] in UK how many names? [answer] one

SELECT count(*) FROM <your table> WHERE <country columnn> = 'UK';

Quote:

which simpler software would you advise me to use for this goal? ms access or other?

Without understanding basic relational theory (see the links above), there is no easy software.
Analogically, do you know any simple text editor for unlettered person?

[Edit: If you do not insist on using (relational) database management systems (DBMS), Littlefoot gave you quite useful advice.
Excel (or any other spreadsheet editor) has some counting capabilities on data structured in sheets.]

[Updated on: Mon, 09 June 2014 05:15]

Report message to a moderator

Previous Topic:	pipeline?
Next Topic:	what is a nested loop join?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 05:24:32 CDT 2024