ies Cyberattacks now cost small companies $200,000 on average, putting many out of business By www.small-business-software.net Published On :: Wed, 13 Nov 2019 19:15:30 -0400 - Forty-three percent of cyberattacks are aimed at small businesses, but only 14% are prepared to defend themselves, according to Accenture. - These incidents now cost small businesses $200,000 on average, reveals insurance carrier Hiscox, with 60% of them going out of business within six months of being victimized. - More than half of all small businesses suffered a breach within the last year. - Today it’s critical for small businesses to adopt strategies for fighting cyberthreats. complete article Full Article
ies Get Motivated Going Into the New Year With These Top Small Business Stories By www.small-business-software.net Published On :: Wed, 22 Jan 2020 19:31:19 -0500 The first weekly roundup of 2020 starts with some motivational quotes to get you up and running for the new year. Once you are all pumped up, an article about the economy should also get you excited. The report says all 50 states have improved their GDP since the 2016 election. And if the rally of the stock market on January 2, 2020 is an indicator of things to come you can expect even better numbers. The optimism for the coming year is also being shared by business leaders. Over two thirds or 76% of them say they see similar or more profits in 2020. The data comes as part of a survey that polled 940 business owners in this article. complete article Full Article
ies These Companies Found a New Niche in Coronavirus Disinfection By www.small-business-software.net Published On :: Wed, 10 Jun 2020 12:08:12 -0400 The pandemic is revealing to small businesses just how versatile they are. So: A home-decor company, a skirt designer, and a business that makes boots for horses all realize they can craft face masks. A manufacturer of pet supplements and a hot sauce company join myriad craft distilleries in production of hand sanitizers. The task of disinfecting workplaces tainted by or vulnerable to coronavirus also has attracted a variety of unexpected entrants. At AK Wet Works, the partners set out at once to reengineer their dustless blasters to produce a cold vapor fog that can sterilize 20,000 square feet an hour. In 100 hours, they produced a working model and began converting all 10 of their machines. Seeking validation for their plan, the founders reached out to FQE, a local chemical company with an EPA-approved coronavirus disinfectant, to create a blend for them. Thinking their idea might have legs outside the Houston-area market, they next approached MMLJ, the original blaster manufacturer, which agreed to mass-produce the modified parts and market them to its large client base. MMLJ is paying a royalty to AK Wet Works, Bland says. Full Article
ies Pricing Strategies for a Strong Bottom Line By www.small-business-software.net Published On :: Tue, 7 Jul 2020 12:52:17 -0400 A price strategy is every bit as important as what you have got to sell. After all, they dictate what you will charge for the goods and services you have on the market. In the end, getting these pricing strategies right is a bit of a balancing act. You will need to find that sweet spot between market demand and maximum profits. 1. Competition Based Pricing Strategy If you are selling things that are similar, this is the pricing strategy your small business should be looking at. Here’s how competitive pricing works. First off, this works best for products rather than services. It works when the price for those products has reached a balancing point between your business and others. This pricing strategy starts out using the going market rate to set a price. 2. Value-Based Pricing Basically this is pricing based on what customers are willing to pay. There are several steps to this pricing model. You need to do a bit of detective work here to find a competitive product. Next, you will need to list all the ways your product is different. Stress the financial value on these differences. This is a reasonable way to defend your pricing strategy. Full Article
ies 3 Promising Industries for Starting a Business Right Now By www.small-business-software.net Published On :: Tue, 20 Oct 2020 15:50:59 -0400 Entrepreneurs have seized the opportunity to start new companies in a wide variety of industries during the Covid-19 pandemic. While not all of these ventures will be successful, businesses that help alleviate some of the new challenges created by the pandemic are poised for long-term growth. Here are three industries that hold promising opportunities for entrepreneurs looking to start new businesses. 1. Contactless Tech 2. Telehealth 3. Education Tech Full Article
ies How Long Do Cell Phone Batteries Last By www.small-business-software.net Published On :: Fri, 8 Jan 2021 15:07:14 -0500 The length of time that a cell phone battery lasts depends on a variety of things. Battery life can be influenced by the type of the cell phone, the type battery, the age of the battery, the applications being used on the phone, even the temperature where the phone is stored and used can impact battery life. How Long Do Cell Phone Batteries Last? Full Article
ies 7 Strategies for Running a Successful Small Business By www.small-business-software.net Published On :: Mon, 25 Jan 2021 18:05:37 -0500 1. Organize your business documents 2. Have a scalable technology plan ready 3. Plan to spend money to earn money 4. Prepare to outsource tasks 5. Create a blueprint for business continuity 6. Develop a strategy for balancing work and life 7. Build your team Full Article
ies Google Is Scrapping Cookies This Year, And Other Small Business Tech News By www.small-business-software.net Published On :: Thu, 1 Apr 2021 14:59:29 -0400 Here are five things in technology that happened this past week and how they affect your business. Did you miss them? 1 — Google plans to scrap third-party cookies by 2022. Google announced this past week that it plans to stop the use of tracking cookies on Chrome by next year and— instead— will replace cookies with a profiling system 2 —Recruiting startup SeekOut raised $65M to take on LinkedIn and other talent acquisition companies. 3 —Small business owners adopted new software in 2020 and increased tech budgets in 2021. Full Article
ies 12 Resources and Communities Entrepreneurs Should Follow for Industry Insight and Tips By www.small-business-software.net Published On :: Tue, 13 Apr 2021 15:05:32 -0400 Staying tuned in to the pulse of your industry is key to becoming a successful entrepreneur. Public groups, online forums and the like are among the most valuable resources for gathering and contributing industry information. But if someone is looking for in-depth insight into their business niche, locating the right groups where this discussion occurs is the first step. T Full Article
ies Men of the Blogosphere: This One's for the Ladies By www.resurrectionsong.com Published On :: 2005-03-07T21:40:02-07:00 Since Playgirl editor-in-chief, Michele Zipp, has outed herself as a Republican, can a Conservative Men of the Blogosphere special... Full Article
ies Dietary Supplements Market: Opportunities for Manufacturers and Investors By www.emailwire.com Published On :: Fri, 25 Oct 2024 00:00:00 -0700 (EMAILWIRE.COM, October 25, 2024 ) The global dietary supplements market is projected to grow at a compound annual growth rate (CAGR) of 7.4%, increasing from $167.5 billion in 2023 to $239.4 billion by 2028. Key factors driving this growth include the rising elderly population, a shift from traditional... Full Article
ies Wheat Protein Market Growth: Key Trends and Opportunities for Industry Leaders By www.emailwire.com Published On :: Fri, 25 Oct 2024 00:00:00 -0700 (EMAILWIRE.COM, October 25, 2024 ) The global wheat protein market is expected to expand from $2.5 billion in 2023 to $3.2 billion by 2028, achieving a compound annual growth rate (CAGR) of 4.9%. This growth is driven by the rising popularity of meat-free diets, increasing obesity rates leading to... Full Article
ies Smart Cities Market worth $1,114.4 billion by 2028 By www.emailwire.com Published On :: Wed, 30 Oct 2024 00:00:00 -0700 (EMAILWIRE.COM, October 30, 2024 ) The smart cities market is expected to reach USD 1,114.4 billion by 2028 from USD 549.1 billion in 2023, at a CAGR of 15.2 % during 20232028. The adoption of smart cities has witnessed a remarkable surge in recent years, driven by advancements in technology,... Full Article
ies Future of EV Batteries Market worth 62 million units by 2035 By www.emailwire.com Published On :: Wed, 30 Oct 2024 00:00:00 -0700 (EMAILWIRE.COM, October 30, 2024 ) The global future of EV batteries market is projected to grow from 16 million units in 2024 to 62 million units by 2035, at a CAGR of 12.7%. Higher standard batteries have been introduced due to recent developments in the EV market. Even though new batteries... Full Article
ies ***** ASA-100 Accredited Companies (rank 20) By www.gigaalert.com Published On :: Fri, 20 Jan 2023 11:37:45 +0000 3TOP Aviation Services Ltd. Leatherhead, Surrey, Se United Kingdom: ASA 100 Accreditation Expires: 27 January 2024: 53 North Aviation Ltd Manchester UNITED KINGDOM: ... Prime Air Europe Hemel Hempstead, Herts UNITED KINGDOM: ASA 100 Accreditation Expires: 29 July 2023: Heico Aerospace Corp. - Seal Dynamics, LLC Full Article
ies Interview with We Hate Movies, including the Spooktacular! By www.dvdtalk.com Published On :: 2018-10-15T08:25:04-08:00 We Hate Movies entered it's ninth season earlier this year and is mid-way through its annual October Spooktacular, as of this writing. Far more than another "bad movie podcast," the gang includes film programmer for the Jacob Burns performing arts... Full Article
ies The Creators and Actors of "Batman: The Animated Series" By www.dvdtalk.com Published On :: 2018-10-25T10:00:47-08:00 New York Comic Con 2018: Batman: The Animated Series At the 2018 New York Comic Con, DVDTalk’s Francis Rizzo III sat down with Batman: The Animated Series creators Bruce Time and Eric Radomski, and actors Kevin Conroy, Loren Lester,... Full Article
ies Beate Raudies: Die schwarz-grüne Sparpolitik ist zum Scheitern verurteilt By www.ltsh.de Published On :: Full Article
ies Marc Timmer: Günther muss diese verunglückte Reform sofort stoppen! By www.ltsh.de Published On :: Full Article
ies Landtagspräsidentin Kristina Herbst liest am diesjährigen Bundesweiten Vorlesetag in der Grundschule Dänischenhagen vor By www.ltsh.de Published On :: Full Article
ies Would You Like Fries with That? By gloriousnoise.com Published On :: Mon, 14 Oct 2024 16:55:06 +0000 Once McDonald’s fries were something that plenty of people enjoyed, even if they were a bit dubious about the hamburgers, to say nothing of the McRib (if there ever was an item on the franchise’s menu that the term “mystery meat” could apply to, that’s the one), which apparently will soon be coming back to an Arches outlet near you. But last week Lamb Weston, the largest french fry producer in the U.S., announced it has closed a plant in Washington state because people are opting for small fries, not medium or large. According to McDonald’s: “Everyone wants to know why McDonald’s French Fries taste so good—it’s a simple answer. McDonald’s World Famous Fries® are made with premium potatoes such as the Russet Burbank and the Shepody. With 0g of trans fat per labeled serving, these epic fries are crispy and golden on the outside and fluffy on the inside.” Evidently the notation about the lack of trans fats isn’t enough to convince people that the 480 calories of a large order is something they want to eat, premium potatoes notwithstanding. (A bag of small fries is 230 calories.) Time change, and with it things that were once familiar. Read more at Glorious Noise... Full Article Shorties Features RIAA sales
ies Sparkommissar im Steuerparadies By www.rechtliches.de Published On :: Selbst für die Pflichtausgaben reicht das Geld nicht mehr, weitere Kreditaufnahme sieht die Aufsichtsbehörde aber auch nicht gern - Szenen, wie man sie sonst aus manchen Städten im Ruhrpott kennt, spielen sich jetzt auf den Kaiman-Inseln ab. Chris Bryant heißt der Staatsminister im britischen Außenministerium, der in der britischen Kolonie die unbeliebte Rolle des Sparkommissars spielt und dem Ländchen, das mit rund 50.000 Einwohnern eher kleiner ist als die Städte im Ruhrpott, die Genehmigung zur weiteren Kreditaufnahme verweigert. Full Article
ies Glary Utilities Free 6.18.0.22 (Freeware) By www.snapfiles.com Published On :: Glary Utilities Free is an all-in-one package that includes a variety of system tools to help you clean your PC from junk files, remove Internet traces, find invalid registry entries, manage startup .... Full Article
ies Nelories By www.bibabidi.com Published On :: Mon, 11 Oct 2021 19:53:00 -0700 Two Japanese ladies, who look like they could be sisters, one accordion, a bag of campy lyrics, and an orchestra comprised of canned horns and soft strings for the backing band—would you believe their one and only U.S. release arrived through They Might Be Giants' John Flansburgh's Hello Recording Club? An ebullient zip through an alternative timeline, where Shonen Knife is committed to doo-wop and rockabilly, and kitted out in poodle skirts and kitten heels. Full Article Indie Japanese Pop
ies Life with Lucy: The Complete Series By www.dvdtalk.com Published On :: Tue, 29 Oct 2019 10:58:13 PDT Recommended For Lucille Ball completists, the release of Life with Lucy (1986), her ill-fated final sitcom, is most welcome. I Love Lucy/The Lucy-Desi Comedy Hour (1951-60), The Lucy Show (1962-68), and Here's Lucy (1968-74) kept her on the network airwaves nearly constantly for a quarter of a century, but her return to theatrical features with Mame (1974) flopped badly, with Ball singled out for atypically harsh reviews. After that she did annual television specials for a few years, and was a frequent presenter at award shows. In November 1985 she starred in The Stone Pillow, a TV-movie in which she played an elderly homeless woman, and while that program received mixed reviews it did well enough in the ratings to prompt Ball and her (second) husband, comedian-producer Gary Morton, to dip into the sitcom well that had served her so reliably well and for so long....Read the entire review Full Article DVD Video
ies Helping Others To Freedom Pt4: Soul-Ties By www.preachtheword.com Published On :: Wed, 15 Feb 2023 10:10:02 GMT In the fourth episode of our video series on 'Helping Others To Freedom', we take time to consider 'Soul-Ties' - a term that describes a heart tie in any relationship, good or bad. When these ties are bad they can exert a negative influence upon our lives, hindering us moving forward to maturity in Christ. In this session we talk about what soul-ties look like in the positive and the negative, and how to break free from such spiritual bondage in order to experience release and any healing necessary. 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
ies 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
ies 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
ies Le commerce de la Chine avec les autres �conomies de l'APEC a atteint un niveau record entre janvier et octobre By chine.in Published On :: 2024-11-13T21:47:46+01:00 Le commerce de la Chine avec les autres �conomies de l'APEC a atteint un niveau record de 21.270 milliards de yuans (environ 2.950 milliards de dollars) au cours des dix premiers mois de 2024, selon les donn�es publi�es mercredi par l'Administration... Full Article APEC
ies Guide To Installing Fedora Core 6 On HP Pavilion dv2000 Series Laptops By www.ensode.net Published On :: This guide provides installation and configuration instructions for installing Fedora Core 6 on HP Pavilion dv2000 series laptops. Full Article
ies TORENHOGE AMBITIES IN HET PSG TRAININGSPAK By voetbal.blog.nl Published On :: Tue, 11 Apr 2017 07:44:26 +0000 Het PSG trainingspak opent een boek. De voorsteden en de forensensteden presenteren de stad als één geheel. Een boek met ...... Lees verder: TORENHOGE AMBITIES IN HET PSG TRAININGSPAK Full Article .Algemeen
ies Three impossibilities with partitioned indexes By www.orafaq.com Published On :: Sun, 01 Sep 2013 16:22:11 +0000 articles: RDBMS ServerThere are three restrictions on indexing and partitioning: a unique index cannot be local non-prefixed; a global non-prefixed index is not possible; a bitmap index cannot be global. Why these limitations? I suspect that they are there to prevent us from doing something idiotic. This is the table used for all examples that follow: CREATE TABLE EMP (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) ) PARTITION BY HASH (EMPNO) PARTITIONS 4; the usual EMP table, with a partitioning clause appended. It is of course a contrived example. Perhaps I am recruiting so many employees concurrently that a non-partitioned table has problems with buffer contention that can be solved only with hash partitioning. Why can't I have a local non-prefixed unique index? A local non-unique index is no problem, but unique is not possible: orclz> create index enamei on emp(ename) local; Index created. orclz> drop index enamei; Index dropped. orclz> create unique index enamei on emp(ename) local; create unique index enamei on emp(ename) local * ERROR at line 1: ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index You cannot get a around the problem by separating the index from the constraint (which is always good practice): orclz> create index enamei on emp(ename) local; Index created. orclz> alter table emp add constraint euk unique (ename); alter table emp add constraint euk unique (ename) * ERROR at line 1: ORA-01408: such column list already indexed orclz> So what is the issue? Clearly it is not a technical limitation. But if it were possible, consder the implications for performance. When inserting a row, a unique index (or a non-unique index enforcing a unique constraint) must be searched to see if the key value already exists. For my little four partition table, that would mean four index searches: one of each local index partition. Well, OK. But what if the table were range partitioned into a thousand partitions? Then every insert would have to make a thousand index lookups. This would be unbelievably slow. By restricting unique indexes to global or local prefixed, Uncle Oracle is ensuring that we cannot create such an awful situation. Why can't I have a global non-prefixed index? Well, why would you want one? In my example, perhaps you want a global index on deptno, partitioned by mgr. But you can't do it: orclz> create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4; create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4 * ERROR at line 1: ORA-14038: GLOBAL partitioned index must be prefixed orclz>This index, if it were possible, might assist a query with an equality predicate on mgr and a range predicate on deptno: prune off all the non-relevant mgr partitions, then a range scan. But exactly the same effect would be achieved by using global nonpartitioned concatenated index on mgr and deptno. If the query had only deptno in the predicate, it woud have to search each partition of the putative global partitioned index, a process which would be just about identical to a skip scan of the nonpartitioned index. And of course the concatenated index could be globally partitioned - on mgr. So there you have it: a global non-prefixed index would give you nothing that is not available in other ways. Why can't I have a global partitioned bitmap index? This came up on the Oracle forums recently, https://forums.oracle.com/thread/2575623 Global indexes must be prefixed. Bearing that in mind, the question needs to be re-phrased: why would anyone ever want a prefixed partitioned bitmap index? Something like this: orclz> orclz> create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4; create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4 * ERROR at line 1: ORA-25113: GLOBAL may not be used with a bitmap index orclz> If this were possible, what would it give you? Nothing. You would not get the usual benefit of reducing contention for concurrent inserts, because of the need to lock entire blocks of a bitmap index (and therefore ranges of rows) when doing DML. Range partitioning a bitmap index would be ludicrous, because of the need to use equality predicates to get real value from bitmaps. Even with hash partitions, you would not get any benefit from partition pruning, because using equality predicates on a bitmap index in effect prunes the index already: that is what a bitmap index is for. So it seems to me that a globally partitioned bitmap index would deliver no benefit, while adding complexity and problems of index maintenance. So I suspect that, once again, Uncle Oracle is protecting us from ourselves. Is there a technology limitation? I am of course open to correction, but I cannot see a technology limitation that enforces any of these three impossibilities. I'm sure they are all technically possible. But Oracle has decided that, for our own good, they will never be implemented. -- John Watson Oracle Certified Master DBA http://skillbuilders.com Full Article
ies 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
ies Svartzonker Signature series 8´6" 40-140g - Spin By www.hengelspullen.nl Published On :: zat, 04 okt 2014 07:01:31 GMT 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. Full Article
ies 2016 Fantasy Baseball Injuries to Consider (Premium) By www.fulltimefantasy.com Published On :: Fri, 25 Mar 2016 18:31:13 EST 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. Full Article Fantasy Baseball
ies Dr. Roto's Fantasy Baseball Auction Strategies (Premium) By www.fulltimefantasy.com Published On :: Sun, 27 Mar 2016 14:23:18 EST Senior Fantasy Baseball Expert Dr. Roto lays out a few guidelines to help you triumph in your Fantasy Baseball auctions this season! Full Article Fantasy Baseball
ies Feliz Navidad! Tarjetas de Navidad y Felices Fiestas By riversongs.com Published On :: Tarjetas de Navidad, Postales de Navidad Gratis, Tarjetas de Feliz Navidad, Felicitaciones de Navidad, Tarjetas de Felices Fiestas desde RiverSongs.com Tarjetas virtuales de Navidad musicales! Full Article
ies Liveblog zu Neuwahlen: ++ Kukies erwartet keine Haushaltssperre ++ By www.tagesschau.de Published On :: 2024-11-12T21:09:10Z Der neue Bundesfinanzminister Kukies geht nicht davon aus, dass es eine Haushaltssperre geben wird. BSW-Chefin Wagenknecht sieht für ihre Partei durch den Zeitdruck Herausforderungen. Die Entwicklungen vom Dienstag zum Nachlesen. Full Article
ies Finanzminister Kukies im Haushaltsausschuss By www.tagesschau.de Published On :: 2024-11-13T02:05:05Z Der neue Finanzminister Kukies wird heute im Haushaltsausschuss erklären müssen, wofür noch Geld da ist und wie es weitergeht. Was sind die größten Baustellen? Von Nicole Kohnert. Full Article
ies Commercial Fundraisers Companies: California Releases Report Detailing Use of Funds of Commercial Fundraisers By communitydispatch.blogspot.com Published On :: Fri, 24 Dec 2010 03:52:00 +0000 The annual report on commercial fundraisers released today found commercial fundraisers in California raised $391.5 million in 2009 but charitable organizations received less than 43% of those funds Commercial Fundraisers Companies: California Releases Report Detailing Use of Funds of Commercial Fundraisers Full Article
ies IRS Identifies Organizations that Have Lost Tax-Exempt Status By communitydispatch.blogspot.com Published On :: Thu, 09 Jun 2011 18:05:00 +0000 The Internal Revenue Service today announced that approximately 275,000 organizations under the law have automatically lost their tax-exempt status because they did not file legally required annual reports for three consecutive years. IRS Identifies Organizations that Have Lost Tax-Exempt Status Full Article
ies Save $200 on Roll-N-Lock M-Series Tonneau Covers! By www.dieseltruckresource.com Published On :: Wed, 06 Nov 2024 04:10:50 GMT Image: Thinking about adding a stylish and functional tonneau cover to your truck bed? We've got some great options for you. The Roll-N-Lock M-Series Hard Manual Retractable Tonneau Cover... Full Article Diesel Truck Resource Sponsors
ies This Wednesday-Byrd Baggett Part 3 of a 4 Part Series! By work-from-home-success.blogspot.com Published On :: Tue, 14 Aug 2007 02:24:00 +0000 Since June, Byrd Baggett has been a regular guest on the SU faculty teleseminar as he shares a 4 part series called "Going Deep - How to Grow Your Career and Life to the Level of Significance"The earlier sessions were powerful! Instructive! Emotionally stirring! In short the first two calls were some of the most touching events I have ever been involved in... until now!If you think this all sounds like hype, I challenge you to discover the power of this message by joining us on Wednesday August 15 at 8pm Central as we continue on this potentially life changing journey.Byrd BaggettWednesday, August 15 at 8pm Central(512) 225-9483Pin 486309# Hi Millionaire,When you are ready to "Go Deep" in your life and you grow to the level of significance, you would be wise indeed to carefully select a guide for your journey. We want to inspire you to celebrate your entrepreneurial spirit and challenge you to be your best.Byrd Baggett is one of the best people I could ask to guide us to the other side, to that place of freedom, success and happiness. A significant life.In this session, entitled "Drought Proof" - How to harness the transformational power of perseverance" Byrd Baggett will show us how to incorporate the power of perseverance into our lives. You will learn how to look at life through the windshield, not the rear-view mirror.Following are some of the powerful, practical, and applicable insights that will be shared:How to conquer fearHow to overcome the addiction of perfection"The Rule of Ten" - You will learn five simple acts of daily disciplinethat will transform your life, both personally and professionally.Success University listeners will be the first to hear these powerful insights!Make plans to join us, as Byrd shows us how to grow to the richly rewarding Season of Significance. As participants from Byrd's previous sessions will attest, this promises to be a transformational experience. Who is Byrd Baggett?Byrd Baggett's passion and expertise is helping people and teams grow to the level of significance. His presentations are as original and memorable as his name. His mission is to transform people and teams by teaching them the skills essential to developing relationships that stand the tests of time and change.Byrd is the world's most prolific creator of original quotes and acronyms. He is the author of over 2,500 quotes and acronyms that have been published in thirteen best-selling books, including four on the topic of leadership. These books have sold in excess of one million copies and have been published in nine languages. His quotes and articles on leadership, sales, motivation, and customer service have been featured in many publications, including Reader's Digest, Bits & Pieces, Guide Posts, and Selling Power magazine.He achieved All American status as a collegiate athlete, had successful careers with two Fortune 500 companies, and built a successful multi-million dollar business. Byrd's powerful words, coupled with his engaging real-life stories, celebrate the winning spirit and challenge people to discover the winner within. A standing ovation for Byrd Baggett:I can't remember when I've received 100% positive comments from any company-sponsored event. What you accomplished is beyond the reach of your peers. Your passion for your Mission, your love for people, and your commitment to excellence is a combination that I've not experienced before in my 30 years in the business world. Thanks to you, we at Protective Life have a renewed sense of purpose and a developing vision on what it takes to become effective leaders.~Dave Keyes, Senior Vice President, Protective Life CorporationI have been associated with training and development for thirty years and have heard some truly excellent presentations, and yours is as good as it gets! As long as there are individuals like you delivering the powerful message of servant leadership, there is hope for organizations.~Gary Sullivan, Indian River Community CollegeI just wanted to thank you for the positive impact you've had on my life. I now have a new enthusiasm about my business and personal life. I have become a better husband, father, friend, and leader of my business from listening to you speak.~Andy Malone, 2005 Agent of the Year, Farmers InsuranceI would like to highlight several unique characteristics that make your work so specialÉ An incredible ability to connect with people on a personal level, a sincere passion and interest in helping people grow, and the ability to positively impact everyone with several memorable quotes to call upon in times of reflection in our daily lives. I recommend your services to anyone wishing to inspire and expand their capabilities for achieving true success and happiness, both professionally and personally.~Joel Goode, Gilead SciencesAs a member of Success University you get access to all these faculty calls plus lots more as part of your membership. Has the cost of a cup of coffee a day ever brought you so much?John O'Driscollmlm-successsite.com Full Article New Event
ies Tulsa TV Memories on This Land today By thislandpress.com Published On :: Wed, 29 Feb 2012 14:05:00 CDT This Land Press is featuring my article about TTM today. They also have a new TV show debuting March 7. Check it out. Full Article
ies 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
ies Content + Community Strategist Looking For New Opportunities By www.lynnedjohnson.com Published On :: 2013-09-11T14:48:14-05:00 Hi there. I'm currently getting my grind on, looking for consulting and freelance opportunities but also open to FT gigs as well. (see my resume below after the details) Looking for new clients now Currently working as a Content +... Full Article
ies Social Media Opportunities and Challenges in Digital Signage By www.lynnedjohnson.com Published On :: 2013-11-19T13:07:50-05:00 Back in 2010, when I was SVP of Social Media at the Advertising Research Foundation, a member in the mobile industry was interested in learning whether the opportunities in digital signage were right for the company to explore. I ended... Full Article
ies 21 municipalities in Eastern Visayas attains Stable Peace and Security Status By samarnews.com Published On :: Wed, 23 Oct 2024 10:30:00 +0800 A total of 21 Local Government Units in Eastern Visayas have been declared with a Stable Internal Peace and Security (SIPS) status, showcasing significant advancements in the region's anti-insurgency efforts. Full Article
