1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

create table

Discussion in 'SQL PL/SQL' started by sarah, Jun 8, 2014.

  1. sarah

    sarah Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    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!
     

    Attached Files:

    • A.JPG
      A.JPG
      File size:
      42.7 KB
      Views:
      12
  2. sarah

    sarah Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    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?

    thank you so so much.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Your task to create the report?
    Or you have a task of one-time unloading of data?

    NOTE: your the report can be made in tools of creation of reports.
    for example :Oracle Reports Services
    Oracle_BI_Publisher
    .....


    For creation of reports there is a lot of tools.
    The choice is carried out according to your functional requirements.


    In the simplest case: if your report doesn't exceed several thousand lines, it is possible to use unloading of results of request in the form of XML

    https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:728625409049

    http://www.dba-oracle.com/t_create_spreadsheet.htm