zad5

zad5



*• Oracle SQL Developer : Oracle


n x


File Edit View Navigate Run Vers ioning Tools Help


1 X HA iQ • © •



[^jConnections x

[i^ Connections

r—1

Ś) ^ Oracle


& Oracle x ^

0

O l?a?aQ, ,142^<§l

Q Oracle'*'

Worksheet Query Builder


Tables (Filtered) i i CENY $ @ ETATY ś) a KLIENCI $ a POZIOMY.PENS fflB PRACOWNICY $ a SIEDZIBY Ś a WIERSZE_ZAMC $ B WYDZIAŁY Ś-S WYROBY Ś) a ZAMÓWIENIA Views

i-a lndexes a Packages $ ca Procedures ® Functions i ca Queues Ś-® Queues Tables ® a Triggers ® 8l Types

Sequences

® Materialized Views i-® Materialized Views

® ta Synonyms


select data_zarnowieni a, wartość from zamówienia utiere wartość between 1000 and 3000 and data_zarnowienia>to_date(,10.05.1991l, 'DD.MM.YYVY') order by data_zarnowi eni a; |


O Query Result x

ft ^ ^ SQL Ali Rows Fetched: 9 in 0,008 seconds

| DATA_ZA MÓWIENIA

1| WARTOŚĆ

1 91/07/13

1217,4

/V

2 91/07/16

2073

3 91/08/02

1095,6

4 91/08/19

1200,5

5 91/10/06

1265,75

6 91/10/10

1627

7 91/10/10

1685

8 91/10/13

2058,9

9 91/11/19

2275,6



| Linę 4 Column 27    | Insert | Modified | Unix/Mac: LF


Wyszukiwarka

Podobne podstrony:
zad3 * Oracle SQL Developer : Oraclen x File Edit View Navigate Runa ^ a m v i x m i □ Versioning T
zad4 * Oracle SQL Developer : Oraclen x File Edit View Navigate Run Versioning Tools HelpQ W [ĄConne
zad6 * Oracle SQL Developer : Oraclen x File Edit View Navigate Runa ^ a m v i x m i □ Versioning T
zad7a * Oracle SQL Developer : Oracle File Edit View Navigate Run Versioning Tools Help W [ĄConnecti
zad7 * Oracle SQL Developer : Oracle File Edit View Navigate Run Versioning Tools Help iii iQ W [ĄCo
zad8 * Oracle SQL Developer : Oracle File Edit View Navigate Run Versioning Tools Help iii i Q W [ĄC
zadanie2 0 * Oracle SQL Developer : Oracle n x File Edit View NavigateSBOS W X Run Versioning Tools
a Applications Places Oracle SQL Developer © Sun 16:58 Ą « QOracle SQL Developer : system O X File E

więcej podobnych podstron