ical Sterile Medical Packaging Market worth $94.6 billion by 2028 By www.emailwire.com Published On :: Tue, 05 Nov 2024 00:00:00 -0800 (EMAILWIRE.COM, November 05, 2024 ) The report "Sterile Medical Packaging Market by Material (Plastic, Metal, Paper & paperboard, Glass), Type (Thermoform trays, Sterile bottles & containers, Pre-fillable inhalers), Sterilization Method, Application, and Region - Global Forecast to 2028" The global... Full Article
ical Medical Foam Market worth $43.3 billion by 2028 By www.emailwire.com Published On :: Wed, 06 Nov 2024 00:00:00 -0800 (EMAILWIRE.COM, November 06, 2024 ) The report "Medical Foam Market by Form (Flexible, Rigid, Spray), Material (Polymers, Latex, Metals), Application (Bedding & Cushioning, Medical Packaging, Medical Devices & Components, Prosthetics & Wound Care), and Region - Global Forecast to 2028 " The global... Full Article
ical Electronic Wet Chemicals Market worth $5.4 billion by 2028 By www.emailwire.com Published On :: Tue, 12 Nov 2024 00:00:00 -0800 (EMAILWIRE.COM, November 12, 2024 ) The report "Electronic Wet Chemicals Market by Type (Acetic Acid, Isopropyl Alcohol, Phosphoric Acid) Form (Liquid Form, Solid Form, Gas Form) Application (Semiconductor, IC Packaging, PCB), End-use Industry, And Region - Global Forecast to 2028" The global Electronic... Full Article
ical Cervical Cancer (Cancer of the Cervix) By www.medicinenet.com Published On :: Mon, 9 May 2022 00:00:00 PDT Title: Cervical Cancer (Cancer of the Cervix)Category: Diseases and ConditionsCreated: 12/31/1997 12:00:00 AMLast Editorial Review: 5/9/2022 12:00:00 AM Full Article
ical Musically Political By gloriousnoise.com Published On :: Mon, 26 Aug 2024 13:12:18 +0000 (Note: the following is political, so if that’s agitating, concerning or upsetting, please don’t read it. This is not an endorsement of any candidate. It is not a solicitation for membership in the UAW or other trade union. No matter your position, on November 5, 2024, vote.) The Chicks performed at the Democratic National Convention in Chicago last week; they sang the National Anthem. As you may recall, they used to be known as the “Dixie Chicks.” But they dropped the adjective in 2020 after the murder of George Floyd, recognizing that the term had associations with the Confederacy and connotations of racism. One can imagine that they lost some sales as a result of that. But one knows that in 2003 the group lost sales and fan support when lead singer Natalie Maines said during a concert in London, “Just so you know, we’re ashamed the president of the United States is from Texas.” She was referring to George W. Bush. She said that in relation to the impending war in Iraq. Nine days after she made the statement, the invasion occurred. Read more at Glorious Noise... Full Article Shorties AFM Features Kid Rock politics Ted Nugent The Chicks UAW unions
ical Political Mood 2024: None More Black By gloriousnoise.com Published On :: Wed, 06 Nov 2024 18:52:06 +0000 POLJUNK, the National Affairs desk of Glorious Noise Here we are again. In the year of someone’s Lord 2024, we are back in time. We had a slight reprieve with four years of competent governing that resulted in record economic growth, withdrawal from historically disastrous military entanglements in the mideast (brought to you by the formerly worst president in US history), and at least some sense of normalcy, but I guess we are going back. This was after what many thought was an aberrant Trump presidency–surely that was a blip in the American experience, right? As it turns out, the aberrant is the accepted. It’s America’s true face, one we occasionally veil but never actually change. I could list all the reasons Donald Trump is a terrible person and worse “leader,” but we all know them. And that’s the point: This isn’t some unknown or misunderstood element. This is Donald Trump. We know him and unfortunately, he knows us. Better than many of us know ourselves. Trump isn’t some genius, he’s just a guy who is willing to do what others won’t because most of us live between imaginary lines of decency. Read more at Glorious Noise... Full Article Articles Election Features politics POLJUNK
ical The Bio-Chemical Matrix - The Myths of Matrix Science By www.newmediaexplorer.org Published On :: 2012-03-30T11:56:03+01:00 by Jon Rappoport www.nomorefakenews.com The medical system kills 225,000 people a year. (Starfield, JAMA, July 26, 2000, "Is US health really the best in the world?") "In principle, gene therapy is a medical miracle waiting to happen ... after 17 years of trying, scientists are still struggling to make gene therapy work. Complications include rejection of DNA carriers ... [and] new genes end up where they shouldn't, or behave unpredictably." ("Gene Therapy: Is Death and Acceptable Risk?", Wired, Brandon Keim, August 30, 2007) MARCH 28, 2012 - In discussing Matrix Science, I'm reminded of Philip Dick's sensational novel, Lies, Inc. It proposes an invention that can teleport humans light-years to a planet where a better way of life exists. The author then spends the rest of the book deconstructing this utopian legend and revealing the truth and the titanic power-grab that sit behind it. Then there is HG Well's 1933 classic novel, The Shape of Things to Come, in which a world exhausted by war and economic collapse turns to a Global State as the only possible solution, after all other solutions have historically failed. This new ruling authority is based on Science. All religions are crushed. Education is designed to teach every child how to become a genius/global citizen. Eventually, the State withers away and is of course replaced by a spontaneous Utopia. Science/technology: the final all-encompassing answer. A significant aspect of Matrix propaganda revolves around myths about how human behavior can be transformed. Transformed through advances in biology and chemistry. Populations are being trained to expect these momentous changes. A major selling point: no effort is required. Just ingest this tablet. Accept this new gene. All will be done for you by experts. Technocrats will design the future so you will fit into it happily. The technocratic wing of Globalism has clout. It promises management of the planet through science, and who can argue with science? Central Planning will ensure proper benefits for all. My late friend and colleague, hypnotherapist Jack True, once told me in an interview:... Full Article
ical Philosophical Investigations By www.sellingwaves.com Published On :: 2005-01-06T19:47:23-05:00 As promised, quotations from Wittgenstein’s Philosophical Investigations are now available. Again, both German and English versions of each are reproduced, though the task was made considerably easier than in other cases by the fact that the edition I used was a dual-language edition. I (like, I suspect, many others) find Wittgenstein simultaneously fascinating and annoying. On the one hand, he makes interesting and insightful observations on all sorts of phenomena; on the other, he never really synthesizes those observations into a single, coherent argument. For example, when he says that “Uttering a word is like striking a note on the keyboard of the imagination” (I§6) or that “Philosophy is a battle against the bewitchment of our intelligence by means of our language” (I§109) or that “The fluctuation of scientific definitions: what to-day counts as an observed concomitant of a phenomenon will to-morrow be used to define it” (I§79) I find myself saying “Right on!”; but I also find myself frustrated by the fact that he can’t even decide on what, exactly, his purpose in writing this all down is. For example, at one point Wittgenstein claims that his “aim in philosophy” is “To shew the fly the way out of the fly-bottle” (I§309), while elsewhere he says: “My aim is: to teach you to pass from a piece of disguised nonsense to something that is patent nonsense” (I§464) and still elsewhere he suggests that he’s merely making obvious remarks that presumably everybody already knows: What we are supplying are really remarks on the natural history of human beings; we are not contributing curiosities, however, but observations which no one has doubted, but which have escaped remark only because they are always before our eyes. (I§415) As I say, this can be frustrating, but, in a way, is also understandable. In one sense, Wittgenstein isn’t trying to provide answers, but rather to show that there aren’t really any problems (as he says in Philosophical Grammar: “While thinking philosophically we see problems in places where there are none. It is for philosophy to show that there are no problems.”). And why aren’t there any problems? Because “philosophical problems arise when language goes on holiday” (I§38); our problems derive from an inability to properly express ourselves. (INTERPOLATION: This isn’t stated very well, so I want to expand just a bit. The idea, as I understand it, is that we ask too much of language; that is, we ignore the fact that “Explanations come to an end somewhere” (I§1), that, as quoted below, “language itself cannot be explained”, but, rather, that it can only be understood by its use. In failing to recognize this, we find ourselves unable to express the explanations we seek.) Within this context, I think Wittgenstein’s thesis (to the extent that he even has one) boils down to the following: What we have rather to do is to accept the everyday language-game, and to note false accounts of the matter as false. The primitive language-game which children are taught needs no justification; attempts at justification need to be rejected. (II.xi) Or, from a different direction: “So you are saying that human agreement decides what is true and what is false?”—It is what human beings say that is true and false; and they agree in the language they use. That is not agreement in opinions but in form of life. (I§241) Viewed from this perspective, then, it is, perhaps, not so surprising that Wittgenstein has a tendency to be frustratingly vague at times; after all, as he himself says, “What is most difficult here is to put this indefiniteness, correctly and unfalsified, into words” (II.xi). Personally, I find his perspective compelling, but I can understand why some might find it rather superficial, especially since it can lead to seemingly-trivial statements like: “One wants to say: a significant sentence is one which one can not merely say, but also think” (I§511). All this aside, though, there are two other things I really like about Wittgenstein. First, the fact that he has a real sense of humor and isn’t afraid to deploy it. For example, I couldn’t help laughing aloud at reading this: Think of a picture of a landscape, an imaginary landscape with a house in it.—Someone asks “Whose house is that?”—The answer, by the way, might be “It belongs to the farmer who is sitting on the bench in front of it”. But then he cannot for example enter his house. (I§398) Of course, it probably helps that his sense of humor has that bone-dry, literalistic bent that is characteristic of mathematicians (if you don’t see the humor in the above, re-read the last two sentences like a died-in-the-wool literalist). Which brings me to the second appeal Wittgenstein has for me: he has at least some understanding and awareness of mathematics. And, of course, I can’t help but be excited when someone seems to agree with my own quasi-Intuitionist perspective: Of course, in one sense mathematics is a branch of knowledge,—but still it is also an activity. And ‘false moves’ can only exist as the exception. For if what we now call by that name became the rule, the game in which they were false moves would have been abrogated. (II.xi) And, though it doesn’t explicitly refer to mathematics, Wittgenstein’s initial (or final, depending on how you look at it) conclusion has a distinctly mathematical feel to it (especially within the context of Russell’s paradox): What is spoken can only be explained in language, and so in this sense language itself cannot be explained. Language must speak for itself. (Actually from Philosophical Grammar, but echoed throughout Philosophical Investigations) Okay, enough book-reviewing; check out the quotations. Full Article
ical Topical Sermon: Praise Time! - Part 1 By www.preachtheword.com Published On :: Sat, 11 Jul 2020 12:00:01 GMT Enjoy the first of our new format of messages from David Legge, also available to watch on our YouTube Channel! In this two-part message, David encourages us to choose to praise - no matter what our circumstances - in order to affect our mood. Join us for this first part, as we find out what praise is and what it looks like. This sermon is available now from https://www.preachtheword.com in MP3 audio and on our YouTube Channel (https://youtube.com/PreachTheWord) in HD video... Full Article Religion & Spirituality
ical Topical Sermon: Praise Time! - Part 2 By www.preachtheword.com Published On :: Fri, 17 Jul 2020 12:00:01 GMT In this second part of his message 'Praise Time!', David looks at what praise does - the effects praise can have upon your life's circumstances and your own personal well-being. Learn some of the practical outcomes of what happens when you activate the power of praise! This sermon is available now from https://www.preachtheword.com in MP3 audio and on our YouTube Channel (https://youtube.com/PreachTheWord) in HD video... Full Article Religion & Spirituality
ical Topical Sermon: Fasting God's Way By www.preachtheword.com Published On :: Fri, 31 Jul 2020 18:02:01 GMT 'Fasting God's Way' is the subject of our latest Topical Sermon, as we consider the genuine motives behind the type of fasting God looks for in His people. What's the difference in fasting our way, and fasting God's way? What does our fasting achieve if we're not fasting God's way? How does He view it? Join us for the answers to these and other questions! This sermon is available now from https://www.preachtheword.com in MP3 audio and text formats... Full Article Religion & Spirituality
ical Topical Sermon: Stand Firm In The Battle By www.preachtheword.com Published On :: Fri, 01 Jan 2021 13:01:01 GMT As Christians we must be aware that we are in a battle of epic proportions, and therefore we MUST 'Stand Firm In The Battle'. To do this, we must have a working knowledge of what plain this battle is fought on, what weapons are at our disposal and the source of our victory. Only then will we know how to stand firm when so much is coming against us from the enemy's ranks. This message was originally aimed at a men's conference, hence the application to men - but, of course, the truths here apply to both genders! This message is available now from https://www.preachtheword.com in MP3 audio and on our YouTube Channel (https://youtube.com/PreachTheWord) in HD video... Full Article Religion & Spirituality
ical Topical Sermon: The Great Shaking! By www.preachtheword.com Published On :: Tue, 07 Dec 2021 11:02:01 GMT In this topical message for our current cataclysmic times, David brings light from a passage of scripture he considers as the most relevant for this moment - Hebrews 12:25-29. How do we survive, or even better, thrive and overcome in this time of great shaking? This message, entitled 'The Great Shaking', helps us to know how to receive the kingdom that cannot be shaken, whilst the things that can be shaken all around us are being removed. This timely sermon is available now from https://www.preachtheword.com in MP3 audio format... Full Article Religion & Spirituality
ical Topical Sermon: The Sunday After Easter By www.preachtheword.com Published On :: Fri, 14 Apr 2023 16:01:01 GMT For 'The Sunday After Easter', we visit the scenes depicted in John 20, when the risen Lord Jesus Christ appeared to His disciples. On the first occasion, Thomas is missing from the gathering and this causes doubt to rise in his heart and mind. But when Jesus appears again and speaks directly to Thomas, countering his doubts and fears, his faith is embolded to declare 'My Lord and my God!'. Join us as David Legge draws lessons from this encounter for 'The Sunday After Easter'. This message is available now from https://www.preachtheword.com in MP3 audio and on our YouTube Channel (https://youtube.com/PreachTheWord) in HD video... Full Article Religion & Spirituality
ical Helping Others To Freedom Pt9: Practicalities And Mysteries Of Healing And Deliverance By www.preachtheword.com Published On :: Mon, 15 May 2023 10:10:02 GMT In Session 9 of 'Helping Others To Freedom', David addresses many practical questions that often arise around healing and deliverance, also considering some of the mysterious matters that can confuse people. This episode on 'Practicalities And Mysteries Of Healing And Deliverance' should be extremely useful for anyone engaging in prayer ministry. This session is available at https://www.preachtheword.com now in MP3 audio format and in HD video on our YouTube Channel (https://youtube.com/PreachTheWord)... Full Article Religion & Spirituality
ical Practicalities Of Prayer By www.preachtheword.com Published On :: Thu, 01 Feb 2024 10:01:01 GMT All of us are learners when it comes to prayer and praying better. So whilst we must beware of gimmicks and quick-fix formulae, we also must recognise some helpful disciplines of prayer - ingredients that can help us 'arrange' our prayers better. Here in 'Practicalities Of Prayer', David shares some valuable and practical pointers to refresh our prayer lives. This message is available at https://www.preachtheword.com now in MP3 audio format and in HD video on our YouTube Channel (https://youtube.com/PreachTheWord)... Full Article Religion & Spirituality
ical Had My ESA Medical Yesterday. By nancythroughthelookingglass.blogspot.com Published On :: Wed, 11 Jul 2012 12:42:00 +0000 Regular readers will be aware that I have been campaigning against the austerity cuts our government is imposing on the UK and the effect they are having on disabled people. The benefiits system is being changed, and the benefit I currently recieve is called Income Support, this is being phased out and everyone is being put onto the new disability benefit ESA. As this happens many disabled people are having their benefits cut or completely stopped as a result of being unfairly declared fit for work by the flawed capability assessment, at the same time as services for us are also being cut, a huge accident waiting to happen I'm sure you'll agree. In fact things are already terrible, people are commiting suicide after having their benefits stopped or just from fear of having to go to the medical. Others have died from the stress of having to appeal whilst genuinely ill. I read only a couple of days about a woman who died as the stress of all these changes was too much, and a week later her mother also died after witnessing her daughters money being stopped and her eventual death at the stress of appealing. There are many cases like the one I have mentioned above yet the government are still pressing ahead with these cuts to disability benefits, even though almost daily rich people are being exposed as tax evaders and bankers who have actually failed us terribly are still receiveing pay offs and bonuses. I finally had my medical yesterday, it wasn't as bad as I thought as the asessment has been changed to suit people with mental illness better (previously everyone was given the same assessment regardless of their disability, which is grossly unfair to people with mental illness). So I wasn't asked to do any strange physical tests as others have, they just asked me about my mental health. The woman was really nice but it's not her decision what happens next. I will either be put into the "support" group where I will be repeated re-assessed but not have to go to the job center or be forced to try and find work. Or I could be placed in the "Work related activity group" where I will have to go to work focused interviews and after a year my disability benefits will completely stop and I will have to sign on to the benefit designed for people who are fit to work. If this happens then it will be the end for me as I am not fit to work, I've chronic anxiety based depression since childhood and as a result of that have social anxiety and insomnia. So I don't sleep, can't get up early and on some days can't even talk to anyone or leave the flat. Unemployment where I live is incredibly high compared to the rest of the country anyway so the chances of a woman who can't be on time for work or even come in some days beating someone who is in goood health are zero, I have no chance of finding work. In fact I don't even meet the criteria to sign on JSA so will probably end up homeless as my rent will not be paid. I just have to pray it's the support group. Full Article anxiety based depression ATOS medical depression and anxiety ESA mental health support group Work related activity group
ical Recursive WITH, part II: Hierarchical queries By www.orafaq.com Published On :: Fri, 03 Jun 2016 09:38:25 +0000 articles: SQL & PL/SQLIn 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 Full Article
ical Political FootBall Headlines By political-football.blogspot.com Published On :: Tue, 27 Sep 2005 12:57:00 -0700 SHOULD BE an interesting contest someday. Schwarzenegger and Affleck both vieing for the presidency. Ben Affleck is rumoured to be running for senator in Virginia next year. His spokespeople deny it, but in the next breath also say "he would be a superb candidate for public office in the future"...IS IT A COINCIDENCE that Brown criticizes everyone else except himself or Bush and is still on the FEMA Payroll...FEMA REINVENTS the word "charity" and plans to use taxpayer money to reimburse churches and other religious organizations that provided shelter, food and supplies to survivors...FORMER FEMA DIRECTOR Michael Brown blames others for most of the government failures in responding to Hurricane Katrina, especially Louisiana Gov. Kathleen Blanco and New Orleans Mayor Ray Nagin... RESIDENTS OF the Texas refinery towns hit hardest by Hurricane Rita are blocked from returning to their homes because of danger from debris-choked streets, toppled power lines and a shortage of ice and generators...DONALD TRUMP'S EMPIRE continues to expand, but his newest addition is on the home front. The 59-year-old real estate mogul and TV reality star's wife Melania, is pregnant...CHINA DEFENDS its new restrictions on online news content, saying that every country regulates the Internet...UNIVERSAL, EMI, Warner, Sony BMG and local subsidiaries have entered into mediation with Baidu.com, China's largest Internet search engine, over the recording companies' claims of copyright infringement....MORE HEADLINE NEWS at News Blog.tags: daily fisk political football news in the news current affairs current events opinion rant ramblings random thoughts news and politics politics political media news headlines headline news Full Article
ical Musical Christmas Love Greeting Cards, Romantic Christmas Cards By riversongs.com Published On :: Share romantic Christmas love cards with music from RiverSongs.com with spouse or boyfriend or girlfriend! Send I Love You Christmas ecards for email, mobiles, whatsApp, Facebook and Twitter! Full Article
ical Musical Valentine's Day Video Cards, Happy Valentine's Day Ecards By riversongs.com Published On :: Romantic Valentine's Day cards with music, Valentine's Day love ecards, Happy Valentine's Day Greetings and Video cards for mobile smartphones. Full Article
ical Happy New Year Video Cards, Musical New Year Greeting Cards By riversongs.com Published On :: Celebrate the New Year with style, see great fireworks cards, watch the new year countdown, and share happy new year ecards with your friends! Full Article
ical Musical Christmas Cards, Merry Christmas Greeting Cards By riversongs.com Published On :: Send the best Merry Christmas Ecards with music to friends and family! Listen to Christmas carols, share the Christmas Countdown Card and watch Christmas videos. Full Article
ical TNP - Cholesterol Medical Studies By www.the-natural-path.com Published On :: Provides links to medical study abstracts that find cholesterol control to be an effective means of slowing, stopping or reversing coronary artery disease. Full Article
ical LXer: Critical Linux CUPS Printing System Flaws Could Allow Remote Command Execution By www.linuxquestions.org Published On :: Sat, 28 Sep 2024 21:10:30 GMT Published at LXer: A new set of security vulnerabilities has been disclosed in the OpenPrinting Common Unix Printing System (CUPS) on Linux systems that could permit remote command execution under... Full Article Syndicated Linux News
ical How to Email Spreadsheets Automatically on a Recurring Schedule By www.labnol.org Published On :: Thu, 11 Jul 2019 06:05:25 +0000 Schedule and send Google Spreadsheets on a recurring schedule. Email Google Sheets as PDF, CSV or Microsoft Excel formats on daily, weekly, monthly or yearly schedules. The post How to Email Spreadsheets Automatically on a Recurring Schedule appeared first on Digital Inspiration. Full Article Software Archives Google Spreadsheet How-to Guides PDF Screencast
ical Politically Correct Handbaskets By harekrsna.com Published On :: .Understanding spiritual truth that sometimes appears contradictory from a material viewpoint. Full Article
ical SOUNDLOCATIONS - THE TIME FOR A NEW MUSICAL PATH HAS COME TO GO FORWARD TOGETHER By www.ionone.com Published On :: Germany, end of 2013: dark clouds hanging over the heads of analog musicians. A popular music magazine found out that the number of rehearsal rooms and venues for young bands is significantly decreased. Especially the situation for rehearsal rooms is dramatically: too less, too expensive, too dirty and hard to reach. But in cultivated countries there should be room for many different types of culture not only mainstream ... Full Article
ical Mar 15, How to Blog It Automatically and Relief Yourself from the Headache of blogging? By www.home-biz-trends.com Published On :: Tue, 15 Mar 2016 11:10:31 -0400 Blog It, is the smart solution to blog automatically and relief yourself from the headache of blogging. Read the smart features of blog-it carefully, to automate it and avoid the hard work. Full Article
ical Big Blue Ceiling Unveils AuRA: an AI-Powered Revolution in Medical Research Reporting and More By www.pr.com Published On :: Thu, 07 Nov 2024 03:00:00 -0500 Big Blue Ceiling, a leader in cutting-edge AI and autonomous research technology, is excited to announce AuRA (Autonomous Research Assistant), a groundbreaking AI-powered application set to transform medical research reporting. Built on IntellectCascade, Big Blue Ceiling’s Multiagentic and Multimodal AI framework, AuRA is poised to empower healthcare providers with real-time insights, reshaping patient engagement and [PR.com] Full Article
ical Generalized constructal law shows that evolution doesn't apply only to biological things By www.scienceagogo.com Published On :: A law of physics that explains why larger animals live longer and travel further can be extended to the simplest forms of mass migration on the planet - like rolling stones and turbulent eddies in water and air currents... Full Article
ical Elliptical Exercise Machines By www.popularfitness.com Published On :: January 4, 2010 About the total body workout benefits that Elliptical exercise machines and trainers provide. Full Article
ical Best Buy Elliptical Machine By www.popularfitness.com Published On :: August 31, 2011 The elliptical machine you buy should be based on the features of the elliptical trianer and a number of factors including your fitness goals, body and budget. Full Article
ical Sole E35 Elliptical Trainer Review By www.popularfitness.com Published On :: September 15, 2011 A comprehensive review article of the Sole E35 elliptical trainer including features, extensive warranty and its construction. Full Article
ical Elliptical vs Treadmill Machines By www.popularfitness.com Published On :: June 2, 2015 Comparison of elliptical to treadmill machines to determine which is best for your fitness workout. Full Article
ical Physical Training Fine Tunes the Body By www.popularfitness.com Published On :: May 17, 2016 Exercise and an active lifestyle help to enhance the health and well-being of your body. Full Article
ical Finding the Right Elliptical Trainer for Your Workout By www.popularfitness.com Published On :: November 8, 2017 Review of features and designs of elliptical machines to consider for your workouts. Full Article
ical 11 Key Benefits of Physical Activity By www.popularfitness.com Published On :: June 8, 2018 Benefits of exercising and staying active for the body and mind. Full Article
ical Practical Wellness Tips for Superior Head-to-Toe Health By www.popularfitness.com Published On :: May 6, 2019 Being healthy is a way of living. Practical wellness tips for superior health. Full Article
ical Jobs Requiring Best Physical Condition By www.popularfitness.com Published On :: June 25, 2021 Consider these jobs that require the best physical condition. Full Article
ical Simple At Home Physical Training Exercises By www.popularfitness.com Published On :: February 16, 2022 8 exercises that you can do from the comfort of your home. Full Article
ical Exploring Different Approaches to Medical Weight Loss Programs By www.popularfitness.com Published On :: March 19, 2024 Options to enable you to lose weight and improve your health using medical weight loss procedures, methods that are science-based and custom-made to meet your exact specifications. Full Article
ical 15 Practical Tips For Creating A B2B Podcast By www.podcasting-tools.com Published On :: Wed, 2 Sep 2020 11:31:25 -0400 1. Strive To Be Different 2. Pilot Your Idea 3. Do Not Do It Alone 4. Understand Your Audience 5. Do Not Think About The Audience 6. Help Businesses Solve Challenges 7. Establish Yourself as an Authority 8. Target A Specific Niche 9. Focus On Building New Relationships 10. Three Elements Every Episode 11. Bring In A Variety Of Voices 12. Define The Why Of The Podcast 13. Keep Your Podcasts Brief 14. Make It Fast-Paced And Entertaining 15. Be Careful Not To Niche Down Full Article
ical Practical Magic: The Best Business Apps for iPad By www.corporatetrainingelearningblog.com Published On :: Sun, 8 Jul 2012 13:42:00 -0400 With the introduction of tablets like the iPad, working outside of the office has become streamlined. No longer are employees and entrepreneurs chained to their desks and laptops. Here are some tablet applications that allow workers to share, create and record information easily and quickly, putting productivity and ingenuity at their fingertips. CloudOn If you need access to documents, CloudOn is a must for your iPad. The app gives you access to Microsoft Office and also syncs with your Dropbox account to make sharing easy. (Dropbox is a free file synchronization application for mobile professionals who use myriad devices on which files live.) CloudOn boasts a file viewer that can open any image, and you can also send your documents directly via e-mail as an alternative to sharing through Dropbox. Evernote This application is a huge hit with college students, and for good reason. Described as “an extension of your brain,” Evernote allows users to take notes using text, photos, video and audio – great for taking notes during meetings or conferences. One of the coolest things about Evernote is that it uses optical character recognition (OCR)to make the text in your photos searchable. This means you can take a photo of a slideshow or presentation and automatically search it later based on the subject matter. There is also the capability to sync Evernote with your desktop, which is a great safeguard in the face of damage or loss of a mobile device. OmniGraffle Users can use this to process a diagram, flow chart, Website wireframe or graphic design. OmniGraffle has a library of stencils, but you can also draw your own shapes. Once completed, you can share the graphic as a PDF and can save it to your photo library. The app comes with a hefty price tag of $50, and is probably more appropriate for project managers or other employees who work in project development or training. Fuze ProfessionalMulti-party HD video meetings are possible with this iPad app. You can include documents, images and presentations in the meeting by adding the files to the Fuze library. There are also some great features that allow you to zoom and pan to highlight visual data while you are running a presentation. In addition to the multi-party video option, participants have the option to IM (instant message) during the presentation or communicate via voice chat. Participants may also edit presentation documents on the fly to highlight certain points. Guest Blog Contributor By-line: A freelance writer and blogger hailing from the great state of Texas, Melissa Miller specializes in writing about the education field. If you're considering pursuing an associate degree online, Melissa's many posts on the subject can help light the way. Email her at melissamiller831@gmail.comwith any feedback. Full Article
ical Computer Help Technical Support Windows Help Tech Support Computer Technical Support Tech Support Windows 98 Windows 2000 Windows XP Live Windows Help By www.ebizindia.com Published On :: Mon, 13 Dec 2004 11:19:28 PST Computer Help and fast Technical support from trained technicians computer tech support fast computer technical support computer help with errors computer technical solutions Full Article Home & Family -- Students & School
ical Tropical Fish Secrets By www.ebizindia.com Published On :: Mon, 13 Dec 2004 11:19:28 PST Information on tropical fish, help for a beginner or advanced aquarist, starting an aquarium, breeding tropical fish and different species. Full Article Home & Family -- Pets
ical Stockmanship Dramatically Improved Since the 1990s By www.farmscape.com Published On :: Fri, 08 Nov 2024 00:00:00 GMT Farmscape for November 8, 2024 An Animal Science Professor with Colorado State University says the handling of livestock and the understanding of animal behavior have improved dramatically since the 1990s. "Pig Handling and Welfare" was the focus of the day one keynote address at Saskatchewan Pork Industry Symposium 2024, held this week in Saskatoon. Dr. Temple Grandin, an animal science professor with Colorado State University, says there is a much greater awareness of the benefits of superior stockmanship. Quote-Dr. Temple Grandin-Colorado State University: One thing that's really good is handling has improved. That's the good news but also attitudes toward welfare have changed. I started out in the 70s and was the livestock chairman for a group called LCI, Livestock Conservation Institute. It was a livestock organization and they had committees on preventing death losses in pigs, reducing bruises in cattle. It all had to do with economic losses. Then, when I first started out working with cattle, I emphasized how I could improve the economics. Nobody at that point was even talking about welfare then gradually things got more interested in welfare. Maybe 20 years ago there was a lot videos put out showing really horrible handling, really bad stuff, pitchfork in the milking parlor, knocking dairy cows over with a forklift, beating pigs with gate rods as hard as they could beat them, just really bad things and that started a lot of the things on handling. I did work with McDonalds, Burger King and Wendy's in 1999 on inspecting pork and beef slaughter plants and it was very interesting taking high executives out and when they saw something really bad it was a true undercover boss moment. They realized that there were things that we did have to fix but that kind of stuff's not going on now. It took a long time for a lot of people to accept that pigs and other animals feel pain. Now the big emphasis has gone from, you've got to prevent suffering. Dr. Grandin suggests by measuring and scoring handling, including such factors such as slips and falls, electric prod use, body condition score, lameness, vocalization you can tell whether you're getting better or worse. For more visit Farmscape.Ca. Bruce Cochrane. *Farmscape is produced on behalf of North America’s pork producers Full Article
ical Getting Started with Artificial Intelligence: A Practical Guide to Building Applications in the Enterprise By tmarkiewicz.com Published On :: Fri, 09 Feb 2018 20:57:25 +0000 For the past several months I’ve been co-writing a book that was recently published by O’Reilly. Called Getting Started with Artificial Intelligence: A Practical Guide to Building Enterprise Applications, the book is currently offered by IBM as a free download. Written with Josh Zheng to introduce developers and technical managers to using artificial intelligence when […] The post Getting Started with Artificial Intelligence: A Practical Guide to Building Applications in the Enterprise first appeared on Tom Markiewicz. Full Article Books Machine Learning Programming Technology ai book deep_learning IBM machine_learning
ical Harbour: The Kalk Bay Musical By www.capetowntoday.co.za Published On :: If you are a Capetonian down to your roots, this is a production to see. Full Article
