ri

Vijesti :: Blagdansko ozračje u restoranu Corner [nagradno darivanje]

Autor: Redakcija 031 Naslov: Blagdansko ozračje u restoranu Corner [nagradno darivanje]
Postano: 12.11.2024. 20:15 (GMT 1) Mjesec prosinac, mjesec darivanja i druženja s dragim ljudima. S prosincom završavamo i još jednu uspješnu godinu, a zašto ju ne bi završili uz nama drage ljude.

Restoran Corner vas povodom toga poziva na božićno okupljanje. Idealna prilika da se opustite i uživate u ukusnoj hrani i veseloj atmosferi.

Božićni domjenak traje od 20:00 sati do dva sata iza ponoći.

Restoran Corner je pripremio i buffet menu:
Predjela:

- Roastbeef s Waldorf salatom, tostirana focaccia
- Winter Rolls, rolice od hrskavog tijesta punjene carskim mesom i kiselim kupusom s umakom od hrena
- Domaći kroketi punjeni pilećim prsima i sirom s curry makom
- Rižoto od cikle s dimljenim šaranom, orasima i sirom
- Domaći krumpir & sir s umakom od majoneze i tartufa
- Arančini

Glavno jelo:
- Zalogajna jela s roštilja
- Pork belly s rižom i coleslaw salatom
- Pileći odrezak punjen celerom, šunkom i sirom s njokima od bundeve u umaku od sira
- Pohani Šokački odrezak s pireom od krumpira
- Gulaš na Tikveški s lovačkom roladom
- Punjene lignje, parisienne krumpir s espumom od blitve

Salate:
Turšija iz lokalnog OPG-a
- Šopska
Pečena paprika s uljem češnjaka i peršina
- Zelene salate
- Povrće sa žara na salatu s maslinovim uljem i tostiranim pinjolima

Desert:
- Slatke domaće štrukle s malinama
- Štrudla s jabukama
- Torta od mrkve
- Božićni tiramisu

Piće (No limit):
od 20:00 do 02:00 sata
ŽESTOKA PIĆA I LIKERI: Dewars, Pelinkovac, Višnja, Šljivovica, Jagermeister, Gin
PIVO: Karlovačko pivo, Karlovačko crno, Karlovačko radler, Crni radler
VINA: Graševina Belje, Cabernet Sauvignon Belje, pjenušac La Belle Grand
VODA I SOKOVI: Jamnica, Jana, Coca cola, Fanta, Tonic, Pago Jabuka, Pago Naranča
KAVA: Instant kava (samoposluživanje)

Božićna interakcija:
- Foto kutak s božićnim motivima
- Svečano osvjetljenje i dekoracije

Cijena po osobi (za hranu i piće u neograničenim količinama) je 60 eura, a za sve informacije i rezervacije možete se javiti na broj: 091 250 00 24 ili putem e-mail adrese: uprava@corner-osijek.hr.

Kako do restorana Corner? Corner Osijek nalazi se u Osijeku u Velebitskoj ulici u gradskoj četvrti Jug II.

[Nagradno darivanje]

Portal Osijek031 daruje Alasov pladanj za dvije osobe. Nagradno darivanje možete pronaći na našoj Facebook stranici.


[klik za uvećanje]




ri

Vijesti :: Sezona je grijanja, a osječki dimnjačari imaju pune ruke posla

Autor: Redakcija 031 Naslov: Sezona je grijanja, a osječki dimnjačari imaju pune ruke posla
Postano: 13.11.2024. 9:31 (GMT 1) Sezona je grijanja i osječki dimnjačari imaju pune ruke posla. Mnogi se građani zbog različitih razloga "vraćaju" grijanju na kruta goriva, no najčešći je razlog poskupljenje energenata. Problem predstavljaju dimnjaci koji ne zadovoljavaju europske uvjete.

Stanje s dimnjacima u Hrvatskoj daleko je od idealnog. No, postoje vidovi i tehnička rješenja koja su izvediva i koja bi pružila sigurnost građanima. Naime, riječ je o dimovnim objektima koji se nisu obnavljali, a nalaze se na zgradama građenim 60-tih, 70-tih ili 80-tih godina prošlog stoljeća, pojasnio je dimnjačar Denis Balažić.

- Plin je i dalje dobar kao energent, samo treba uskladiti tip dimnjaka sa samim energentom. Što se tiče trovanja i požara, imam višegodišnje iskustvo. Neka su iskustva su loša, no uvijek ima i pozitivnih priča. U svakom slučaju - opreza nikad dosta, poručio je Balažić.


Tekst: Radio Osijek
Foto: Pixabay.com/Ilustracija




ri

Događaji - najave i recenzije :: GISKO: Predstavljanje knjige "Ironwoman: moja priča"

Autor: Redakcija 031 Naslov: GISKO: Predstavljanje knjige "Ironwoman: moja priča"
Postano: 13.11.2024. 9:50 (GMT 1) Gradska i sveučilišna knjižnica Osijek organizira predstavljanje knjige pod nazivom “Ironwoman: moja priča!” autorice Đurđice Orepić.

Predstavljanje će se održati u četvrtak, 21. studenog 2024. s početkom u 17.00 sati u prostoru Studijske čitaonice Gradske i sveučilišne knjižnice Osijek. Program će moderirati Saša Drinić i Željko Garmaz.

Ironwoman: moja priča knjiga je o ženi koja je, kako navodi urednica knjige Korana Svilar, “životu u inat i životu za ljubav odlučila da neće više samo ‘hodati’, nego trčati, plivati i pedalirati stotinama kilometara – ona će se natjecati u triatlonu, jer život se živi, a ne preživljava”. Iznenađujući sve koji svjedoče njezinoj odluci da pomiče vlastite granice, trpjet će bol i previranja, plakat će i smijati se, upoznat će vlastito tijelo u najekstremnijim uvjetima, prkosit će sebi i svima koji sumnjaju i natjecati se u Ironmanu, najtežoj utrci na svijetu. Ništa nije nemoguće onome tko ima volju pobijediti samoga sebe, dokazuje Đurđica Orepić, najbolja svjetska Ironwoman u svojoj dobnoj skupini.

U memoarskoj prozi Ironwoman: moja priča Đurđica Orepić nadahnuto ispisuje svoje nevjerojatno iskustvo, ne štedeći ni srce ni smisao za humor. I jedinstvena Đu pobjeđuje još jednom. No, ovoga puta ne osvaja trofeje, već srca čitatelja, kojima svakom stranicom prenosi svoju najveću strast – život sâm. U osvrtu na knjigu, Boris Dežulović je napisao da knjiga Ironwoman: moja priča „nije samo priča o uspješnoj ženi koja nikad u životu nije obula patike, pa u pedesetoj odluči postati svjetska prvakinja u triatlonu, ovo je i priča o uspješnoj ženi iza koje – kao iza svake uspješne i dovršene žene – stoji muškarac“.




ri

Događaji - najave i recenzije :: GISKO: Pričaonice u studenom [2024.]

Autor: Redakcija 031 Naslov: GISKO: Pričaonice u studenom [2024.]
Postano: 13.11.2024. 10:31 (GMT 1) Gradska i sveučilišna knjižnica Osijek u studenom će organizirati pričaonice i kreativnu radionicu u Središnjoj knjižnici prema sljedećem rasporedu:

Središnja knjižnica (E. avenija 24, br. tel: 031/211-472)
"Prstići pričaju" (za korisnike od rođenja do 3 godine):
- Srijeda, 20. studenog 2024. godine od 11.00 sati
- Srijeda, 27. studenog 2024. godine od 11.00 sati

"Vrijeme za priču” (za korisnike starije od 3 godine):
- Srijeda, 20. studenog 2024. godine od 17.30 do 18.30 sati
- Srijeda, 27. studenog 2024. godine od 17.30 do 18.30 sati

Kreativna radionica (za korisnike starije od 6 godina):
- Utorak, 26. studenoga 2024. godine od 17.30 do 18.30 sati
– "Kućica za ukrašavanje"




ri

Događaji - najave i recenzije :: Gastro pub Bulart 1887: Vinarija Matošević i Michelin star chef Goran Kočiš

Autor: Redakcija 031 Naslov: Gastro pub Bulart 1887: Vinarija Matošević i Michelin star chef Goran Kočiš
Postano: 13.11.2024. 10:41 (GMT 1) Još jedna senzacionalna Ljekarna u Tvrđi je pred nama. U četvrtak, 21. studenog 2024. u Gastro pub Bulart 1887 s početkom u 19:00 sati stižu Vinarija Matošević i Michelin star chef Goran Kočiš.

Da smo mogli birati idealno vrijeme za dolazak velikog Ivice Matoševića u Ljekarnu u Tvrđi, ne znam postoji li bolji termin od ovoga sada. Jer, nakon skoro 30 odrađenih berbi, Ivica Matošević posljednjih mjeseci ne prestaje nizati panegirike koje mu upućuju najveći svjetski vinski mediji. Vrhunac karijere ovog intelektualca među vinarima, spiritus movensa cijele istarske vinske scene!

Ugledni Wine Enthusiast je prije nekoliko dana čak četiri Matoševićeva vina honorirao s vrlo visoka 94 boda (Superb - A great achievement ), dok je, uvjetno rečeno, „najlošije“ prošla njegova bazna malvazija – 92 boda (Excellent - Highly recommended ). Časopis Decanter ga je prije mjesec dana za malvaziju iz akacije pohvalio sa 93 boda, Saša Špiranec je dvije Grimalde, koje ćemo kušati u Ljekarni u Tvrđi, nagradio sa 95, odnosno 94 boda, dok Ivo Kozarčanin, „Bakhov sin“, za njegova vina tvrdi da su – „čisti eros“.

Povod gostovanju Ivice Matoševića u Ljekarni u Tvrđi je predstavljanje posebne serije najboljih vina iz njegova podruma koju je nazvao Živjelo prijateljstvo, a koju je, kao pravi kolekcionarski biser, posvetio svom, nažalost preminulom, velikom prijatelju Vladi Divljanu. U prodaju je pušteno samo 100 sanduka s vinima iz linije Grimalda i Alba Antiqua, a umjetničke etikete, s podsjećanjem na šest pjesama Vlade Divljana – Radostan dan, Nebeska tema, Vodim te na more, Odnesi me, Ona to zna i Imala je snažnije ruke nego ja, osmislile su umjetnice iz Zagreba, Splita i Beograda - Maja Bosnar, Jana Oršolić, Svetlana Volić, Maja Rožman, Katarina Juričić i Ivana Grimani.

Broj gostiju smo ograničili na 40, tako da će prednost za sudjelovanjem na ovoj uistinu ekskluzivnoj Ljekarni u Tvrđi imati oni koji se prvi jave i spremni su za to izdvojiti 60 eura.

Svoje mjesto rezervirajte putem e-mail: zeljko.garmaz@gmail.com ili pozivom na broj 0916400527.




ri

Vijesti :: Poznat datum isplate nacionalne naknade za starije osobe

Autor: Redakcija 031 Naslov: Poznat datum isplate nacionalne naknade za starije osobe
Postano: 13.11.2024. 11:49 (GMT 1) U petak 15. studenoga 2024. počinje isplata nacionalne naknade za starije osobe za listopad 2024. korisnicima računa otvorenih u poslovnim bankama.

Nacionalnu naknadu za starije osobe dobit će 17 388 korisnika (80,23 % žena i 19,77 % muškaraca), za što je osigurano 2.591.205,00 eura iz Državnog proračuna.

U skladu sa Zakonom o izmjenama i dopunama Zakona o nacionalnoj naknadi za starije osobe (NN 156/23), nacionalna naknada od 1. siječnja 2024. iznosi 150,00 eura, izvijestili su iz HZMO-a.


Foto: Osijek031.com/Arhiv




ri

Događaji - najave i recenzije :: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče"

Autor: knjizaraNOVA Naslov: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge p
Postano: 13.11.2024. 14:09 (GMT 1) Društvo hrvatskih književnika i Klub knjižare Nova pozivaju Vas na predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče".

Na predstavljanju sudjeluju: Nikola Đuretić, Tomislav Maretić i Mirko Ćurić.

Predstavljanje će se održati u Klubu knjižare Nova (Trg Ante Starčevića 4, Osijek) u subotu, 16. studenoga u 11 sati.

Radujemo se Vašem dolasku!




ri

Vijesti :: Grb grada Malog Lošinja dvojici pripadnika Jedinice specijalne i interventne policije Osijek

Autor: Redakcija 031 Naslov: Grb grada Malog Lošinja dvojici pripadnika Jedinice specijalne i interventne policije Osijek
Postano: 13.11.2024. 16:00 (GMT 1) Povodom Dana Grada Malog Lošinja dodijeljen je Grb Grada i dvojici pripadnika Jedinice specijalne i interventne policije Osijek, za izuzetnu hrabrost, stručnost i profesionalnost u realizaciji složene akcije izmještanja mine iz lošinjskog akvatorija 14. ožujka ove godine.

Robert Dorinka i Tomislav Slabinac su ronioci Jedinice specijalne i interventne policije Osijek, koji su sudjelovali u izmještanju mine zaostale iz 2. svjetskog rata, koja se nalazila u lošinjskom akvatoriju.

Da se radilo o opasnom podvigu, potvrđuje činjenica da je zbog bombe teške oko 1000 kilograma, uoči početka akcije zbog mjera sigurnosti u potpunosti evakuirano stanovništvo iz takozvane crvene zone, odnosno područja uvale Čikat. Osim toga je tijekom akcije bila na snazi privremena zabrana cestovnog, pomorskog i zračnog prometa.


Tekst i foto: PU osječko-baranjska




ri

Događaji - najave i recenzije :: CineStar Osijek [14.-20.11.2024.] [program] [nagradno darivanje]

Autor: Redakcija 031 Naslov: CineStar Osijek [14.-20.11.2024.] [program] [nagradno darivanje]
Postano: 13.11.2024. 21:00 (GMT 1)

Uronite u mračni svijet paranormalnih istraživanja s mlađim Hellboyem, smještenim u 1955. godinu, u rane dane B.P.R.D.-a (Biro za paranormalna istraživanja i obranu). Hellboy (Jack Kesy) se pridružuje istraživačici Bobbie Jo Song u misiji transporta opasnog pauka. No, kada pauk pobjegne, njihov lov kroz divljinu Apalačkih planina vodi ih do Toma Ferrella (Jefferson White), vještca koji se vraća nakon dugo vremena kako bi ispravio svoje grijehe. U njihovoj potrazi nailaze na Coru Fisher, djevojku koju je Tom davno napustio. Zajedno se suočavaju s nizom zlih sila koje prijete njenoj duši. Dok mračna magija i zlokobna stvorenja preplavljuju ovu atmosferičnu priču, Hellboy mora iskoristiti svoje vještine i nadnaravnu snagu kako bi porazio sile tame. Za sve ljubitelje Hellboy stripova i filmova, ova avantura donosi mješavinu horora, akcije i okultnih tema, te vraća omiljenog junaka u novom, mračnijem svjetlu.

[Nagradno darivanje]

Portal Osijek031 daruje 1x2 ulaznice za film "Hellboy: Izopačena sjena". Nagradno darivanje možete pronaći na našoj Facebook stranici.






CINESTAR OSIJEK
Portanova centar, Svilajska 31 a, Osijek, 060 32 32 33, Cijena 1,71kn/min za pozive iz fiksne mreže s PDV-om. Cijena 2,92kn/min za pozive iz mobilne mreže s PDV-om.
BLITZ-CINESTAR d.o.o., Branimirova 29, 10000 Zagreb
OIB 24146311117; MB 1734067,
Cinestarcinemas.hr


Moja CineStar srijeda

Ostvarite pogodnost kupovine ulaznica SRIJEDOM po povoljnijoj cijeni!

Mogućnost kupovine ulaznica i za IMAX i 4DX projekcije po povoljnijoj cijeni!

Ulaznice možete kupiti na blagajnama CineStar kina, Cinematima, putem iCineStar aplikacije ili ONLINE kupovinom.

Dodaci (4DX, 3D, eXtreme, VIP i LOVEBOX sjedala, te dodataci za filmove čija je dužina trajanja veća od 120 min, 140 min i više) se naplaćuju u punoj cijeni na povoljniju cijenu kino ulaznice unutar usluge Moja Cine Srijeda.

Prilikom korištenja Stars Club 2x Bonus kartice u svrhu plaćanja usluge Moja Cine Srijeda bilježe se bodovi na kartici.

Pogodnost Moja Cine Srijeda ne vrijedi:
- blagdanima i praznicima
- za pretpremijene projekcije
- za Gold Class projekcije
- za Spektakle u CineStaru (opera, balet, koncerti)
- za dokumentarne filmove u regularnim dvoranama, IMAX-u i Gold Class-u
- za ostale sadržaje koje CineStar odredi

Blitz-CineStar zadržava pravo da određene filmove i projekcije koje prikazuje srijedom, izdvoji iz akcije Moja Cine srijeda. Tada se ulaznica naplaćuje po punoj cijeni.

Za sva pitanja obratite nam se na: info@cinestarcinemas.eu




Tekući CineStar raspored je uvijek dostupan u tjednom pregledniku najava, pri vrhu naslovnice portala Osijek031.com i u mjesečnom pregledu - Najave 031




ri

Le PM chinois met l'accent sur l'am�lioration de la production agricole et la pr�vention des catastrophes

Le Premier ministre chinois Li Qiang a mis l'accent sur l'am�lioration de la capacit� globale de production agricole, ainsi que sur la pr�vention et la r�duction des catastrophes, afin de poser des bases solides pour assurer la s�curit� alimentaire....




ri

La Chine accueille les entreprises � capitaux �trangers pour approfondir la coop�ration mutuellement b�n�fique

La Chine promeut une ouverture de haut niveau du secteur financier et accueille les entreprises � capitaux �trangers pour approfondir la coop�ration mutuellement b�n�fique, a annonc� mardi � Beijing le vice-Premier ministre chinois He Lifeng. M....




ri

Alg�rie : des livres chinois attirent l'attention des lecteurs lors du Salon international du livre d'Alger

Le stand chinois a attir� un large public, en particulier de jeunes visiteurs d�sireux de d�couvrir la culture et la langue chinoises lors de la 27e �dition du Salon international du livre d'Alger (SILA), a constat� sur place Xinhua. Selon Liu...




ri

La Chine et les pays d'Am�rique latine et des Cara�bes b�n�ficieront de perspectives plus prometteuses au cours des dix prochaines ann�es

Guid�e par la diplomatie des chefs d'Etat, la communaut� d'avenir partag� Chine-pays d'Am�rique latine et des Cara�bes b�n�ficiera de perspectives plus prometteuses durant la d�cennie � venir, a d�clar� mardi un porte-parole du minist�re chinois des...




ri

La modernisation chinoise favorise un nouveau mod�le de d�veloppement humain

Un rapport conjoint intitul� "Un nouveau mod�le pour le progr�s humain et son importance mondiale" a �t� publi� lors du Forum des m�dias et des groupes de r�flexion du Sud global qui s'est tenu lundi � Sao Paulo, au Br�sil. R�dig� par des groupes...




ri

Chine : la partie continentale encourage les �changes entre les jeunes et appelle � lever les restrictions sur les voyages entre les deux rives du d�troit de Taiwan

La partie continentale de la Chine a r�affirm� son engagement � promouvoir les �changes entre les jeunes � travers le d�troit de Taiwan et a demand� aux autorit�s du Parti d�mocrate progressiste (PDP) de lever les restrictions sur les voyages �...




ri

Chine : la partie continentale d�clare que les consultations entre les deux rives du d�troit sont possibles en reconnaissant le Consensus de 1992

Les consultations entre l'Association pour les relations entre les deux rives du d�troit de Taiwan (ARATS) et la Fondation pour les �changes entre les deux rives du d�troit de Taiwan (SEF) pourraient reprendre si les autorit�s de Taiwan...




ri

Xi entame une tourn�e en Am�rique latine pour d�fendre la coop�ration et le multilat�ralisme

Le pr�sident chinois Xi Jinping entame mercredi une tourn�e en Am�rique latine, o� il assistera � la 31e r�union des dirigeants �conomiques de la Coop�ration �conomique pour l'Asie-Pacifique (APEC) � Lima, capitale du P�rou, et au 19e sommet du G20...




ri

Chine : la puissance de l'aviation et de la d�fense de la partie continentale est une protection solide pour les compatriotes taiwanais

Une porte-parole de la partie continentale de la Chine a qualifi� les r�sultats et la puissance de la partie continentale dans les domaines de l'aviation, de l'a�rospatiale et de la d�fense nationale de protection "solide et immense" pour les...




ri

Les �changes culturels entre les deux rives du d�troit se poursuivent malgr� les obstacles politiques

Une porte-parole de la partie continentale de la Chine a condamn� mercredi les politiciens du Parti d�mocrate progressiste (PDP) dans la r�gion de Taiwan, qui tentent de faire obstacle aux �changes normaux entre les deux rives du d�troit de Taiwan...




ri

Une porte-parole de la partie continentale condamne les autorit�s du PDP pour avoir "ruin� Taiwan"

Une porte-parole de la partie continentale de la Chine a vivement critiqu� mercredi les autorit�s du Parti d�mocrate progressiste (PDP) de Taiwan pour avoir cherch� � obtenir le soutien des Etats-Unis, d�clarant que plus leur d�pendance � l'�gard...




ri

La Chine et le Vietnam conviennent de renforcer leur coop�ration en mati�re de s�curit�

Chen Wenqing, haut responsable du Parti communiste chinois (PCC), a rencontr� Phan Dinh Trac, membre du Bureau politique et pr�sident de la Commission des affaires int�rieures du Comit� central du Parti communiste vietnamien (PCV), mardi � Beijing. ...




ri

Guide To Installing Fedora Core 6 On HP Pavilion dv2000 Series Laptops

This guide provides installation and configuration instructions for installing Fedora Core 6 on HP Pavilion dv2000 series laptops.




ri

Developing Rich EJB ClientsWith GlassFish

GlassFish provides features to make it easy to develop stand alone, Java Swing based EJB clients. In this article we explain how to take advantage of these features.










ri

Recursive WITH, part II: Hierarchical queries

articles: 

In my last post, I looked at using recursive WITH to implement simple recursive algorithms in SQL. One very common use of recursion is to traverse hierarchical data. I recently wrote a series of posts on hierarchical data, using Oracle’s CONNECT BY syntax and a fun example. In this post, I’ll be revisiting the same data using recursive WITH.

There are dozens of examples of hierarchical data, from the EMP table to the Windows Registry to binary trees, but I went with something more fun: the skeleton from the old song “Dem Dry Bones”.

Quote:
Toe bone connected to the foot bone
Foot bone connected to the heel bone
Heel bone connected to the ankle bone
Ankle bone connected to the shin bone
Shin bone connected to the knee bone
Knee bone connected to the thigh bone
Thigh bone connected to the hip bone
Hip bone connected to the back bone
Back bone connected to the shoulder bone
Shoulder bone connected to the neck bone
Neck bone connected to the head bone

Since every bone has only one ancestor, and there is a root bone with no ancestor, this is hierarchical data and we can stick it in a table and query it.

SELECT * FROM skeleton;
BONE                                     CONNECTED_TO_THE
---------------------------------------- ----------------------------------------
shoulder                                 neck
back                                     shoulder
hip                                      back
thigh                                    hip
knee                                     thigh
leg                                      knee
foot                                     heel
head
neck                                     head
toe                                      foot
arm                                      shoulder
wrist                                    arm
ankle                                    leg
heel                                     ankle
finger                                   wrist
a rib                                    back
b rib                                    back
c rib                                    back

You can see that I added some ribs and an arm to make the skeleton more complete!

Using Oracle’s CONNECT BY syntax:

SQL> col bone FOR a10
SQL> col connected_to_the FOR a9
SQL> col level FOR 99
SQL> col bone_tree FOR a27
SQL> col path FOR a65
 
SELECT bone, connected_to_the, level, 
lpad(' ',2*level, ' ') || bone AS bone_tree , 
ltrim(sys_connect_by_path(bone,'>'),'>') AS path
FROM skeleton
START WITH connected_to_the IS NULL
CONNECT BY prior bone=connected_to_the 
ORDER siblings BY 1

BONE       CONNECTED LEVEL BONE_TREE                   PATH
---------- --------- ----- --------------------------- -----------------------------------------------------------------
head                     1   head                      head
neck       head          2     neck                    head>neck
shoulder   neck          3       shoulder              head>neck>shoulder
arm        shoulder      4         arm                 head>neck>shoulder>arm
wrist      arm           5           wrist             head>neck>shoulder>arm>wrist
finger     wrist         6             finger          head>neck>shoulder>arm>wrist>finger
back       shoulder      4         back                head>neck>shoulder>back
a rib      back          5           a rib             head>neck>shoulder>back>a rib
b rib      back          5           b rib             head>neck>shoulder>back>b rib
c rib      back          5           c rib             head>neck>shoulder>back>c rib
hip        back          5           hip               head>neck>shoulder>back>hip
thigh      hip           6             thigh           head>neck>shoulder>back>hip>thigh
knee       thigh         7               knee          head>neck>shoulder>back>hip>thigh>knee
leg        knee          8                 leg         head>neck>shoulder>back>hip>thigh>knee>leg
ankle      leg           9                   ankle     head>neck>shoulder>back>hip>thigh>knee>leg>ankle
heel       ankle        10                     heel    head>neck>shoulder>back>hip>thigh>knee>leg>ankle>heel
foot       heel         11                       foot  head>neck>shoulder>back>hip>thigh>knee>leg>ankle>heel>foot
toe        foot         12                         toe head>neck>shoulder>back>hip>thigh>knee>leg>ankle>heel>foot>toe

The above CONNECT BY query uses the LEVEL pseudocolumn and the SYS_CONNECT_BY_PATH function. With recursive WITH, there’s no need for these built-ins because these values fall naturally out of the recursion.

Let’s start with the basic hierarchical query rewritten in recursive WITH.
The hierarchical relationship in our table is:
Parent(row.bone) = row.connected_to_the

WITH skellarchy (bone, parent) AS
 ( SELECT bone, connected_to_the FROM skeleton 
   WHERE bone = 'head'                         -- Start with the root
 UNION ALL
   SELECT s.bone, s.connected_to_the 
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           -- Parent(row.bone) = row.connected_to_the
 )
SELECT * FROM skellarchy;

BONE       PARENT
---------- ----------------------------------------
head
neck       head
shoulder   neck
back       shoulder
arm        shoulder
hip        back
wrist      arm
a rib      back
b rib      back
c rib      back
thigh      hip
finger     wrist
knee       thigh
leg        knee
ankle      leg
heel       ankle
foot       heel
toe        foot

Because we built up the SKELLARCHY table recursively, it’s easy to make an equivalent to the LEVEL pseudocolumn; it falls right out of the recursion:

WITH skellarchy (bone, parent, the_level) AS
 ( SELECT bone, connected_to_the, 0 FROM skeleton 
   WHERE bone = 'head'                         
 UNION ALL
   SELECT s.bone, s.connected_to_the , r.the_level + 1
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           
 )
SELECT * FROM skellarchy;

BONE       PARENT      THE_LEVEL
---------- ---------- ----------
head                           0
neck       head                1
shoulder   neck                2
back       shoulder            3
arm        shoulder            3
hip        back                4
wrist      arm                 4
a rib      back                4
b rib      back                4
c rib      back                4
thigh      hip                 5
finger     wrist               5
knee       thigh               6
leg        knee                7
ankle      leg                 8
heel       ankle               9
foot       heel               10
toe        foot               11

and it’s also easy to build up a path from root to the current node like the “SYS_CONNECT_BY_PATH” function does for CONNECT BY queries:

WITH skellarchy (bone, parent, the_level, the_path) AS
 ( SELECT bone, connected_to_the, 0, CAST(bone AS varchar2(4000)) FROM skeleton 
   WHERE bone = 'head'                         
 UNION ALL
   SELECT s.bone, s.connected_to_the , r.the_level + 1, r.the_path || '->' || s.bone
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           
 )
SELECT * FROM skellarchy;

BONE       PARENT     THE_LEVEL THE_PATH
---------- ---------- --------- --------------------------------------------------------------------------------
head                          0 head
neck       head               1 head->neck
shoulder   neck               2 head->neck->shoulder
back       shoulder           3 head->neck->shoulder->back
arm        shoulder           3 head->neck->shoulder->arm
hip        back               4 head->neck->shoulder->back->hip
wrist      arm                4 head->neck->shoulder->arm->wrist
a rib      back               4 head->neck->shoulder->back->a rib
b rib      back               4 head->neck->shoulder->back->b rib
c rib      back               4 head->neck->shoulder->back->c rib
thigh      hip                5 head->neck->shoulder->back->hip->thigh
finger     wrist              5 head->neck->shoulder->arm->wrist->finger
knee       thigh              6 head->neck->shoulder->back->hip->thigh->knee
leg        knee               7 head->neck->shoulder->back->hip->thigh->knee->leg
ankle      leg                8 head->neck->shoulder->back->hip->thigh->knee->leg->ankle
heel       ankle              9 head->neck->shoulder->back->hip->thigh->knee->leg->ankle->heel
foot       heel              10 head->neck->shoulder->back->hip->thigh->knee->leg->ankle->heel->foot
toe        foot              11 head->neck->shoulder->back->hip->thigh->knee->leg->ankle->heel->foot->toe

and we can use our generated the_level column to make a nice display just as we used the level pseudocolumn with CONNECT BY:

WITH skellarchy (bone, parent, the_level) AS
 ( SELECT bone, connected_to_the, 0  FROM skeleton 
   WHERE bone = 'head'                         
 UNION ALL
   SELECT s.bone, s.connected_to_the , r.the_level + 1
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           
 )
SELECT lpad(' ',2*the_level, ' ') || bone AS bone_tree FROM skellarchy;

BONE_TREE
---------------------------
head
  neck
    shoulder
      back
      arm
        hip
        wrist
        a rib
        b rib
        c rib
          thigh
          finger
            knee
              leg
                ankle
                  heel
                    foot
                      toe

Now, the bones are coming out in a bit of a funny order for a skeleton. Instead of this:

    shoulder
      back
      arm
        hip
        wrist
        a rib
        b rib
        c rib
          thigh
          finger

I want to see this:

    shoulder
      arm
        wrist
          finger
      back
        a rib
        b rib
        c rib
        hip
          thigh

The rows are coming out in BREADTH FIRST ordering – meaning all siblings of ‘shoulder’ are printed before any children of ‘shoulder’. But I want to see them in DEPTH FIRST: going from shoulder to finger before we start on the backbone.

WITH skellarchy (bone, parent, the_level) AS
 ( SELECT bone, connected_to_the, 0  FROM skeleton 
   WHERE bone = 'head'                         
 UNION ALL
   SELECT s.bone, s.connected_to_the , r.the_level + 1
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           
 )
SEARCH DEPTH FIRST BY bone SET bone_order
SELECT lpad(' ',2*the_level, ' ') || bone AS bone_tree FROM skellarchy
ORDER BY bone_order;

BONE_TREE
---------------------------
head
  neck
    shoulder
      arm
        wrist
          finger
      back
        a rib
        b rib
        c rib
        hip
          thigh
            knee
              leg
                ankle
                  heel
                    foot
                      toe

And now the result looks more like a proper skeleton.

Now on to cycles. A cycle is a loop in the hierarchical data: a row is its own ancestor. To put a cycle in the example data, I made the skeleton bend over and connect the head to the toe:

UPDATE skeleton SET connected_to_the='toe' WHERE bone='head';

And now if we try to run the query:

ERROR at line 2:
ORA-32044: cycle detected while executing recursive WITH query

With the CONNECT BY syntax, we can use CONNECT BY NOCYCLE to run a query even when cycles exist, and the pseudocolumn CONNECT_BY_IS_CYCLE to help detect cycles. For recursive WITH, Oracle provides a CYCLE clause, which is a bit more powerful as it allows us to name the column which is cycling.

WITH skellarchy (bone, parent, the_level) AS
 ( SELECT bone, connected_to_the, 0  FROM skeleton 
   WHERE bone = 'head'                         
 UNION ALL
   SELECT s.bone, s.connected_to_the , r.the_level + 1
   FROM skeleton s, skellarchy r
   WHERE r.bone = s.connected_to_the           
 )
SEARCH DEPTH FIRST BY bone SET bone_order
CYCLE bone SET is_a_cycle TO 'Y' DEFAULT 'N'
SELECT lpad(' ',2*the_level, ' ') || bone AS bone_tree, is_a_cycle FROM skellarchy
--where is_a_cycle='N'
ORDER BY bone_order;

BONE_TREE                                                    I
------------------------------------------------------------ -
head                                                         N
  neck                                                       N
    shoulder                                                 N
      arm                                                    N
        wrist                                                N
          finger                                             N
      back                                                   N
        a rib                                                N
        b rib                                                N
        c rib                                                N
        hip                                                  N
          thigh                                              N
            knee                                             N
              leg                                            N
                ankle                                        N
                  heel                                       N
                    foot                                     N
                      toe                                    N
                        head                                 Y

The query runs until the first cycle is detected, then stops.

The CONNECT BY syntax does provide a nice pseudocolumn, CONNECT_BY_ISLEAF, which is 1 when a row has no further children, 0 otherwise. In my next post, I’ll look at emulating this pseudocolumn with recursive WITH.


Republished with permission. Original URL: http://rdbms-insight.com/wp/?p=103




ri

NIP Friday #15 ...


This week’s photo's are an extension of the last installment of Nude In Public Friday. They were taken on the same day, just a little farther down the road.
I'll leave the possible captions for the pictures up to you... hee hee!

I've received a lot of email in response to my "Pop Machine" photo from a few weeks ago.



I would say that it was the most popular Nude In Public Friday so far! For those who have asked, yes, there are more hotel pictures and I'll be sharing them over the next few weeks.






ri

Right Here Baby... HNT

This weeks HNT offering might not have the exact meaning that first comes to your mind.
You may interpret it as saying... "aim that thing right here baby" or " yes that's right, I swallow... interested?" But trust me, you would be dead wrong, ( at least at the moment that is.)
No, what it does say is " I bit my fucking tongue this afternoon and the damned thing is still swollen and it hurts."
My dear hubby finds the photo's erotic... which is all fine and good as long as he realizes that blow jobs are out of the question for a couple of days...
Click the button to learn about HNT






ri

NIP Friday #16 ...

Well, it's the end of the week and time again for Nude In Public Friday.
This weeks picture was taken during an evening of flashing a little over a year ago in Denver's North Cherry Creek area.

I think most women, at one time or another, have either performed a quick boob flash in an elevator or have at least been tempted to. I mean it's exciting.There you are in public and all of a sudden you have few moments of privacy to go a little crazy. Add to this the excitement of the possibility of being caught should the elevator doors open, and you can really see why elevators play into so many fantasies .

I've had my share of experiences in elevators and it would be fair to say that I've went down more often than I've gone up in them.





ri

NIP Friday #17 ...

I picked this week’s picture for Nude In Public Friday for one reason... it reminded me of the warm summer evening that it was taken. Why do I find this so appealing you may ask? Four inches of fucking snow on May 1st, that's the reason! I awoke yesterday to the snow. I had to drive to a meeting in Castle Rock in it and got stuck in an hour long jam on the way back... Colorado weather, you've got to love it.


If my memory doesn't fail me, this picture was taken last summer on our way to dinner up in Longmont. It was warm, I was horny and I thought that I would show some boobage. I certainly didn't feel that way yesterday.





ri

NIP Friday #18 ...

This is the 18th installment of Nude In Public Friday and I've received a lot of positive feedback so far. Out of the previous 17 NIP posts, the two most popular seem to have been the hotel pop machine and elevator pictures.


I suspect that there's some kind of freudian correlation between my tits and the machines going on here, all I know is that I've received more email from those two posts, than all the rest combined.

Most of them wanted to know if I had more of these photo's and would I post them. In an attempt to fulfill these requests, I'll be posting a few more from those two occasions over the next couple of weeks.





ri

A Frigid... HNT

We had a high here yesterday of 61 warm and pleasant degrees. Currently, it's 22 degrees and snowing. Normally I would kind of enjoy this Christmas like weather change, were it not for the fact that I've been plagued by porch pests all evening. Seven times my doorbell has rang this evening, and seven times I've opened the door to find some idiot trying to get me interested in something that I really couldn't give a shit about. Each time I opened the door I could feel the cold air flowing in and the warm air rushing out. At first I tried to be nice and fain interest for a minute or two before pleasantly saying no. However, as the night went on and my furnace kept kicking on at a steady pace, I began loosing my temper. By the time the last poor bastard reached my stoop, he was met by the worlds biggest bitch spewing a plethora of language that would have made a trucker blush...
On a happier note, there's a much naughtier photo of me over at " The Other HNT " this week. Take a look and let me know if you can pick my picture out of the bunch.

Click the button to find out about Half-Nekkid Thursday







ri

Fireline Fused Cristal 0,06 mm nu voor maar € 10,00

Fireline Fused Cristal Merk: Berkley Lengte: 110 meter De nummer 1 transparante superlijn ter wereld. Kenmerken van de Fireline Fused Cristal: - 3x sterker dan een mono lijn - Ultiem gevoelig. - Schuurbestendig - Extreem sterk - Ook geschikt voor op de molen De lijnen zijn in drie verschillende diameters te verkrijgen. Iedere diameter heeft weer een andere draagkracht.




ri

7 Volt elektrische handschoenen van Gerbing

7V VERWARMDE HANDSCHOENEN Of je nu gaat skiën, paardrijden, hond uitlaten, fietsen of wat dan ook, het is nooit leuk als je het koud hebt. De handen zullen het eerste koud worden. Hiervoor hebben wij verschillende 7 volt verwarmde handschoenen ontwikkeld waardoor je met plezier de dingen doet die je leuk vindt. Ook mensen met een minder goede doorbloeding zullen merken dat onze verwarmde handschoenen een uitkomst zijn. Alle Gerbing 7 volt verwarmde handschoenen en andere kledingstukken uit het 7 volt assortiment worden standaard geleverd met 2 oplaadbare batterijen. Dat wil zeggen dat in tegenstelling tot onze 12 volt elektrisch verwarmde handschoenen, die standaard aangesloten worden op een motorvoertuigaccu, de 7 volt handschoenen alleen maar autonoom gedragen kunnen worden. Net als onze 12 volt verwarmde handschoenen zijn de 7 volt verwarmde handschoenen voorzien van het gepatenteerde micro wire (staaldraad). Dit draad is heel sterk en erg flexibel. Voor alle doeleinden heeft Gerbing handschoenen: S-7 verwarmde textiel handschoenen zijn te gebruiken voor o.a.skiën en fietsen vanwege de extra verstevigingen aan de binnenkant van de hand. De lederen O-7 verwarmde handschoenen en de H-7 verwarmde handschoenen zijn weer te gebruiken voor diverse outdoor activiteiten. Zo is de H-7 handschoenen speciaal gemaakt voor paardrijden en jagen. Maar vanwege zijn sjieke uiterlijk kan men ook leeker verwarmt rijden in een cabrio. De M-7 verwarmde wanten maken de collectie compleet. Deze textiele wanten zijn verkrijgbaar in drie maten en zijn voor heel veel activiteiten geschikt. Al deze 7 volt verwarmde handschoenen worden geleverd met een 7 volt batterij kitje (B7V-2500 KIT). Deze batterijen worden ook voor de 7 volt verwarmde jassen, 7 volt verwarmde sokken en alle overige 7 volt producten. De batterijen zijn eenvoudig te bedienen en zorgen voor uren plezier met warme handen.




ri

Svartzonker Signature series 8´6" 40-140g - Spin

Svartzonker is niet enkel een beroemde kunstaasbouwer, hij is ook een uitstekend hengelbouwer. We voelen ons vereerd om u een speciale roofvis serie aan te bieden waarvoor enkel uiterst lichte componenten gebruikt werden.




ri

Strike Wire Fluorocarbon

Strike Wire Fluorocarbon is echte Japanse fluorocarbon voor het maken van onderlijnen. Zeer soepel, super sterk bestand tegen schuren.




ri

Strike Pro Buster II Deep Crankbait

De Buster II Deep Crankbait is 12 cm lang en heeft uiteraard weer de bekende ratels. Het is het perfecte kunstaas met een multifunctionele actie. Door de 3 bevestigingsogen kunt u variëren met dieptes van 2, 4 en 6 meter. U hebt dus controle om met 1 type plug op verschillende dieptes te vissen en de vissen te vangen ongeacht de waterlaag waar ze zich bevinden. De Buster II Deep Crankbait is suspending, wat betekent dat hij langer in de “strike zone” blijft hangen!




ri

te koop visstation van matrix

te koop..een zeer mooi feeder visstation van het merk matrix.het is 1 klein jaartje oud maar in super mooie staat.er zitten heel veel extra bij.mocht je interesse hebben stuur ik graag wat foto s naar u.gr smeets




ri

E-commerce User Experience

Quest’anno il mio intervento a Better Software è stato dedicato all’ambito di cui mi occupo da qualche anno: la User Experience dei progetti E-Commerce. Quali sono le metodologie utili a guidare il processo decisionale? E quali sono le principali linee … Continua a leggere

L'articolo E-commerce User Experience proviene da Fucinaweb.




ri

Golf Rankings for Puerto Rico Open

Our expert picks the top 30 PGA tour golfers for this week's tournament: 1. Scott Brown, 2. Jerry Kelly, 3. Jonathan Byrd, 4. Patrick Rodgers, 5. William McGirt, 6. Freddie Jacobson, 7. Graham Delaet, ...




ri

PGA DFS: Puerto Rico Open (Premium)

Daily Fantasy Golf Expert Chris Garosi breaks down the top players to target in the Puerto Rico Open on DraftKings this week!:




ri

PGA DFS: Puerto Rico Open (Free Preview)

Fantasy Golf Expert Chris Garosi will help you cash in on DraftKings. This is a free preview of his PREMIUM PGA DFS Rundown!:




ri

Chicago Bears sign restricted free agent tight end Josh Hill to an offer sheet

The Bears have signed restricted free agent tight end Josh Hill. The New Orleans Saints have five days to match the offer.




ri

Dallas Cowboys Sign RB Alfred Morris

Fantasy Football Expert Mark Morales-Smith discusses the Fantasy impact of Alfred Morris moving from the Washington Redskins to the Dallas Cowboys!




ri

2016 Fantasy Baseball Injuries to Consider (Premium)

Dr. Roto looks at several MLB players recovering from injuries to determine whether or not you should be afraid to draft them this Fantasy Baseball season.




ri

Scouting The NBA DFS - Friday, March 25 (Free Preview)

Fantasy Basketball Expert Nate Weitzer will help you cash with your DFS NBA lineups. This is a free preview of his PREMIUM NBA DFS Rundown!