User Profile

Collapse

Profile Sidebar

Collapse
djspang
djspang
Last Activity: Aug 18 '08, 03:21 PM
Joined: Aug 7 '08
Location: Brighton, South Coast, UK
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • djspang
    started a topic How to specify person type in table creation
    in Oracle

    How to specify person type in table creation

    Hi - Newbie here - I'm a bit stuck on the part of the question below, where in create table I must specify person type. How would I do that please? Many Thanks

    Question: - Create a table called "Bakers" containing the following information:

    full name, person type, location name, involvement status; where

    ยท full name is a first and last name

    * person type is either...
    See more | Go to post
    • djspang
      replied to Newbie is stuck! How do I increase a cost by a percentage?
      in MySQL
      Duh! :-) There was me expecting something long and complicated!

      Thanks Atli - much appreciated!...
      See more | Go to post

        Leave a comment:

      • djspang
        started a topic Newbie is stuck! How do I increase a cost by a percentage?
        in MySQL

        Newbie is stuck! How do I increase a cost by a percentage?

        Hi - currently training on SQL - doing alright so far until this sub-question...

        Migrate all data from the JOB_COST table into the TOTAL_COST table. For those records that match the COST_ID, update the UPPER_LEVEL and increase the cost by 15%, otherwise insert the records.

        ...I've looked everywhere online but have no luck. How do I increase a cost by a percentage? Please?
        See more | Go to post
        No activity results to display
        Show More
        Working...