Notes
Notes - notes.io |
SQL> select t.team_name
2 from team t NATURAL JOIN player_plays_in p
3 where p.player_id = (
4 Select p2.get_player_id()
5 from player p2
6 where player_first_name = 'ricardo' and player_last_name = 'kaka');
TEAM_NAME
--------------------
barcelona
2. Change the position of player Arjen Robben to Striker (Uses VALUE to update object table Player)
SQL> update player p
2 SET VALUE(p) = player_typ (113, 'arjen', 'robben', 'striker')
3 WHERE p.player_id = 113;
1 row updated.
3. Show all goals details from Liverpool vs Arsenal match from 2012 season. (Goal details are stored using VARRAY)
SQL> SELECT goal_list
2 FROM goal
3 WHERE game_id = (
4 SELECT game_id from GAME
5 where league_id = (SELECT league_id from league where season_id = 2012 and league_name = 'english premier league')
6 and team1_id = (select team_id from team where team_name = 'liverpool')
7 and team2_id = (select team_id from team where team_name = 'arsenal'));
GOAL_LIST(GOAL_ID, PLAYER_ID, GOAL_FOR, GOAL_AGAINST, GOAL_MINUTE)
--------------------------------------------------------------------------------
MULT_GOALS(MULT_GOALS_TYP(604, 110, 24, 28, 52), MULT_GOALS_TYP(604, 104, 28, 24
, 8), MULT_GOALS_TYP(604, 114, 28, 24, 18))
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
