Home » SQL & PL/SQL » SQL & PL/SQL » CREATE TABLE (4.0.2)
CREATE TABLE [message #615733] Sun, 08 June 2014 12:45 Go to next message
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 65 times)
Re: CREATE TABLE [message #615734 is a reply to message #615733] Sun, 08 June 2014 12:48 Go to previous messageGo to next message
BlackSwan
Messages: 23151
Registered: January 2009
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 Go to previous messageGo to next message
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
Re: CREATE TABLE [message #615737 is a reply to message #615733] Sun, 08 June 2014 12:55 Go to previous messageGo to next message
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.
Re: CREATE TABLE [message #615738 is a reply to message #615737] Sun, 08 June 2014 12:59 Go to previous messageGo to next message
BlackSwan
Messages: 23151
Registered: January 2009
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
Re: CREATE TABLE [message #615739 is a reply to message #615738] Sun, 08 June 2014 13:04 Go to previous messageGo to next message
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
Re: CREATE TABLE [message #615741 is a reply to message #615739] Sun, 08 June 2014 13:22 Go to previous messageGo to next message
BlackSwan
Messages: 23151
Registered: January 2009
Senior Member
Tell your boss that this task should be assigned to somebody else who knows how to login & issue SQL to Oracle database.
Re: CREATE TABLE [message #615742 is a reply to message #615737] Sun, 08 June 2014 13:27 Go to previous messageGo to next message
John Watson
Messages: 4859
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.
Re: CREATE TABLE [message #615743 is a reply to message #615742] Sun, 08 June 2014 13:35 Go to previous messageGo to next message
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.
Re: CREATE TABLE [message #615748 is a reply to message #615743] Sun, 08 June 2014 15:41 Go to previous messageGo to next message
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.
Re: CREATE TABLE [message #615749 is a reply to message #615748] Sun, 08 June 2014 20:35 Go to previous messageGo to next message
BlackSwan
Messages: 23151
Registered: January 2009
Senior Member
MS ACCESS is simpler software
Re: CREATE TABLE [message #615785 is a reply to message #615749] Mon, 09 June 2014 04:25 Go to previous messageGo to next message
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.
Re: CREATE TABLE [message #615789 is a reply to message #615785] Mon, 09 June 2014 04:35 Go to previous messageGo to next message
Littlefoot
Messages: 19889
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 Go to previous message
flyboy
Messages: 1780
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:
  


Current Time: Sat Dec 20 01:37:16 CST 2014

Total time taken to generate the page: 0.38841 seconds