I have an update query below written in Microsoft Access and I would like to convert that to Oracle SQL Developer 17.2.0.188. There is also an image in the attachment showing the query expression.   The query said: "update the Products.UnitsInStock to UnitsInStock-Quantity if the ShippedDate is not null and This_Order_Was_Shipped = "YES"  UPDATE Products INNER JOIN (            Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID        ) ON Products.ProductID = [Order Details].ProductID SET    Products.UnitsInStock = [UnitsInStock] -[Quantity] WHERE  (            ((Orders.ShippedDate) IS NOT NULL)            AND ((Orders.This_Order_Was_Shipped) = "YES")        );
Software Name: Oracle SQL Developer Version 17.2.0.188  I have three tables: orders, order_details, and products.  I wanted to run a query to update units_in_stock in the products table based on quantity in order_details, where the associated orders row has been marked as shipped, and has a shipping date.  Here's what I tried:  UPDATE Products SET (Products.Unit_In_Stock = Products.Unit_In_Stock - Order_Details.Quantity) INNER JOIN (     Orders INNER JOIN Order_Details ON Orders.Order_ID = Order_Details.Order_ID     ) ON Products.Product_ID = Order_Details.Product_ID WHERE (         ((Orders.Shipped_Date) IS NOT NULL)         AND ((Orders.This_Order_Was_Shipped) = "YES")         );   When I run this, I get:  Error at Command Line : 1 Column : 45   Line 1, Column 45 is the equal sign in the very first statement that said  Products.Unit_In_Stock = Products.Unit_In_Stock - Order_Details.Quantity   Can you help me get this working?
Is the universe really "fine-tuned for life"? I understand what is meant when we say , but I've seen it claimed it's is fine tuned "for life". Is it?  When I look at known or even speculated life in our universe, I see life clinging to a tiny crumbs separated by vast voids. Our life needs baryonic matter, only 5% of the universe. Its density is $10^{-30}  g/cm^3$, but it clumps together leaving vast voids between the clumps. 99% is in stars and black holes and nebula utterly inhospitable to known life.  That leaves the parts "fine tuned for life" to be 0.05% of the universe. The planets, asteroids, and comets seem like just debris separated by  than the life-sustaining clumps preventing life from spreading.  Even that seems to be used very inefficiently. Life requires the energy of a star, but it's spewed out in all directions. We only receive a tiny fraction of it. Similarly, life requires heavier elements created in supernova, but these are also spewed out in all directions. And it took billions of years to develop a being capable of asking "is the universe fine tuned for life?"  It seems like we live on the crumbs of creation warmed by a rounding error of the heat from our star. Taking this view, the universe appears extremely inhospitable to life. It could be a lot better tuned.  Is it that the universe is fine-tuned for life? Or is it that the universe is so large and life requires such an infinitesimal fraction of the universe that it's a near guarantee were we to roll the dice again that some crumb, maybe not even baryonic matter, could develop something complex enough to ask "why is the universe fine tuned for life"? Am I just restating the weak anthropic principle?  I understand this is straying into philosophy. If that's off topic, are my  physical assumptions correct? Show $a\Bbb Z+b\Bbb Z = \gcd(a,b)\Bbb Z$ Executing Java programs through Python How do I do this? Is it possible to soft reset to a shiny Yveltal/Xerneas/Zygarde? I want to gain some rare and valuable shinies, and I looked towards the games mascots, Yveltal, Xerneas, and Zygarde. I know in previous games (like Diamond and Pearl) you could soft reset the game until the game would give you a Shiny in for the legendary. Can you still do this? 80/90s UK children's drama series about an "alien" boy with radio weapon I've been trying to track down a live-action children's TV series (or short story perhaps) from the 1980s or 1990s, probably on CBBC or CITV.  A few people I've spoken to IRL have suggested The Boy from Space or Sky, but I'm pretty sure it's neither as a lot of the details don't seem to match.  The story was set on Earth (possibly England or Wales) and was about an "alien" boy who was being pursued by a group of people, though I don't remember who they were.  Somehow he encountered siblings, a girl and a boy, and made friends with them. I think they lived on a farm with their parents, as I remember quite a large barn or other building, and they hid(?) the boy in a car which was inside or next to this building. He also slept in this car with a dog (which might have been a German shepherd).  The "alien" boy had a portable "radio" (all silver, very 1980s) that repelled his pursuers by emitting a high-pitched sound when he turned a dial on it, and he used it when out and about with the other children whenever they encountered a pursuer. I seem to remember lots of hills and valleys, lots of green.  In the end it turned out he wasn’t really an alien, but a human from the far future. He was pretending to be an alien as he was from 20000 years into the future and humans' appearance had changed by then, but he had the ability to make himself look like current-day humans. When he was in his car/bed he reverted to his normal appearance, so he would hide under the blankets until he was able to assume current-day human appearance.  In the finale, it was revealed that he was never in any danger – the pursuers were testing him as part of a kind of coming-of-age thing. I remember a scene on a spaceship or something where his elders/parents where shown telling him that he was safe all along and that he "passed".  I also seem to remember them referring to "ancestors" and making sure they didn't find out, so the either the girl or boy could well have been a direct ancestor. Why is the application of probability in  (QM) fundamentally different from its application in other areas? QM applies probability according to the same  as in other areas of physics, engineering, etc.  Why is there a difference?  Naively one would assume one of these possibilities:   It is not the same probability (theory?) It is a matter of interpretation (of the formalism?) Something else?   Many answers (which I am still studying) focus on the fact that the combined probability of two mutually-exclusive events in QM is not equal to the sum of the probabilities of each event (which holds classically by definition). This fact (appears to) makes the formulation of another probability (a quantum one) a necessity.   Yet this again breaks down to assumed independent, if this is not so, the "classic probability" is applicable (as indeed in other areas). This is one of the main points of the question. ConTeXt: Flush right formula numbers in cases environment I would like to have the formula numbers of the cases environment flush right like regular formulas (not at a fixed distant from the cases like it is by default with the default setting numberdistance=2.5\emwidth). How can I do that?  \starttext  \startplaceformula     \startformula         \startcases             \NC x = 1 \NR[+]             \NC y = 1 \NR[+]         \stopcases     \stopformula \stopplaceformula  \stoptext     What I want (but with the left bracket):  \starttext  \startplaceformula     \startformula         \startalignment[n=1]             \NC x = 1 \NR[+]             \NC y = 1 \NR[+]         \stopalignment     \stopformula \stopplaceformula  \stoptext Use template_include with custom post types I want to check for an appropriate template in the theme folder before falling back to the file in my plugin directory. Here’s my code:  add_filter('template_include', 'sermon_template_include'); function sermon_template_include($template) {     if(get_query_var('post_type') == 'wpfc_sermon') {         if ( is_archive() || is_search() ) :            if(file_exists(TEMPLATEDIR . '/archive-wpfc_sermon.php'))               return TEMPLATEDIR . '/archive-wpfc_sermon.php';            return dirname(__FILE__) . '/views/archive-wpfc_sermon.php';         else :            if(file_exists(TEMPLATEDIR . '/single-wpfc_sermon.php'))               return TEMPLATEDIR . '/single-wpfc_sermon.php';            return dirname(__FILE__) . '/views/single-wpfc_sermon.php';         endif;     }     return $template; }   Problem is, it doesn’t work! :-) It always picks the file in my plugin folder. Any idea what to do? I’ve tried alot of variations but I can’t seem to get anything to work! Thanks in advance! Jack  EDIT  I'm expecting the archive-wpfc_sermon.php to be returned from the theme folder if it exists. However, the file from my plugin always gets returned. Thanks for your help! This is from my Sermon Manager plugin available in the repository. Representing several points with same coordinates on map using ArcGIS Desktop? I'm working on Arcgis 10.  I have a point shapefile representing events with several points having coinciding coordinates (They have the same coordinates). For representing them in a dynamic way, I found a nice way - .  Problem is: I was asked to produce a static (paper) map of the events. Is there a tool that can take these events and shift them apart a bit so all will be seen?  (I know that spreading them about will alter their coordinates, but I am prepared to do so on a duplicate shapefile for the display on the map). How could we improve our planned post notice improvements? Megan has written a .  I've seen a bunch of discussion about it on chat - but it feels like having it purely on the blog is a little clunky.  So specifically - what does the MSE community feel about the proposed post notices for closed questions? What's missing, or what should be added? What are some of the lessons we've learnt that could be helpful here? Asume the following search queries: osx, cocoa, iphone, xcode, applescript, mac, carbon    Searching for osx, cocoa, iphone or xcode like:   http://stackoverflow.com/search?q=osx   Results into searching by tag:   http://stackoverflow.com/questions/tagged/osx   While searching for applescript, mac and carbon like:   http://stackoverflow.com/search?q=applescript   Results into searching by string.  Yes, I know how to search by tags using brackets: [applescript] But why are the queries above interpreted differently? All queries are valid Stack Overflow tags! Why not convert all queries into search by string or search by tag? What is the logic behind? Tag popularity? It seems rather inconsistent to me. Resolving heteroscedasticity in Poisson GLMM How to download a whole FTP site using command line? I need to download an FTP site (a web site source code actually) containing a very high quantity of relatively small files (downloading it with FileZilla took more than a day, but I believe it could be downloaded much faster if many files were downloaded at once). Unfortunately there is no SSH access to the site and no way to archive the files on the server side.  So at least the question is how to download a whole FTP site into a folder using command line tools. A better it'd be if the download could be parallelized by downloading many files simultaneously instead of one by one. Opening Ubuntu 20.04 Desktop on WSL2 I installed Ubuntu 20.04 (server/terminal) from the Windows 10 app store, and then after launching the Ubuntu Terminal via WSL2 (Windows Subsystems for Linux) , I installed Ubuntu Desktop and did several steps to try and get a desktop instance of Ubuntu 20.04 launched.  In short, the steps involved editing the .bashrc file, installing Xming, and then attempting to open the Ubuntu desktop in Xming with the &quot;startxfce4&quot; command.  However, &quot;startxfce4&quot; just doesn't open the desktop for me.  I can get programs to open with &quot;grun&quot; and the file explorer to open with &quot;gopen&quot; though, so it is working partially. Does anyone have any alternative suggestions to how I might get the terminal to open up the full Ubuntu Desktop?  Obviously, this wasn't what Windows had in mind with WSL2 so this is kind of a reach, but any input would be helpful.  Could I somehow do this from the file explorer or with a program that could opened from &quot;grun&quot; or &quot;gopen&quot;? Extract URLs from text in PHP A solid spherical cap of radius $R$ is the solid delimited by a sphere    of radius $R$ and a plane that intersects the sphere.   The height $h$ of the solid spherical cap is the largest distance from a point of the solid to the plane intersecting the sphere.   Show that the volume of a solid spherical cap is given by:  $$V = \frac{\pi h^2(3R-h)}{3}$$   It is enough to consider the solid spherical cap delimited by the sphere $x^2 + y^2 + z^2 = R^2$ and the plane $z = R-h$  use triple integrals by spherical or cylindrical coordinates. Give me a few min to try it out. How come if $\ i\ $ not of the following form, then $12i + 5$ must be prime? I know if $\ i\ $  of the following form $\ 3x^2 + (6y-3)x - y\ $ or $\ 3x^2 + (6y-3)x + y - 1, \ \ x,y \in \mathbb{Z}^{+},i \in \mathbb Z_{\ge 0}$,  then $\ 12i + 5\ $ must be composite number, because:  $12(3x^2 + (6y-3)x + y - 1) + 5 = 36x^2 + (72y - 36)x + (12y - 7) = (6x + 12y - 7)(6x  + 1)$  How come if $\ i\ $ not of the following form $\ 3x^2 + (6y-3)x - y\ $ and $\ 3x^2 + (6y-3)x + y - 1\ $,  then $12i + 5$ must be prime? $\ x,y \in \mathbb{Z}^{+},i \in \mathbb Z_{\ge 0}$.  For example: $\ 5 = \ 3*1^2 + (6*1-3)*1 - 1\ $ ,when $\ x = y = 1\ $, as proved before,$\ 5*12+5\ $ must be composite number;  $\ 0, \ 1. \ 2.\ 3.\ 4\ $ can't of the following form $\ 3x^2 + (6y-3)x - y\ $ and $\ 3x^2 + (6y-3)x + y - 1\ $,  $\ 12*0 + 5 = 5\ $, $\ 5 $ is prime,$\ 12*1 + 5 = 17\ $, $\ 17 $ is prime, and so on, I have an app to deploy in production that uses 'honor system' security. That is, all users connect to the DB using a SQL user/passwd credential and the app manages permissions itself. The latter part doesn't bother me as much as the fact that the connection object contains embedded credentials and can be copied around freely. I'm try to find some way to limit connections to a more limited set of clients. I can create firewall rules to limit by IP, of course. Is there any way to 'prequalify' SQL logins either by Machine account or domain membership? How do I bake multiple texture maps into 1 UV, In Blender Cycles? Using:  Blender V2.79 Cycles Render Engine  After creating a complex interior scene consisting of 3 different texture types, each having 3 associated maps (Diffuse, Gloss, Normal) I noticed the texture and baking options will not successfully combine to create a texture for the exported mesh once I bring it into Unity 3D. The mesh is a single object with the different textures assigned to specified faces.  I've played around with a default cube mesh for testing purposes, using the same 3 textures split among the 6 sides, but have only been able to successfully pull over the color info by baking a diffuse map to my UV and saving the image. When using the other baking options, Blender does not successfully create a map for either my Glossy textures, nor my normal map. Even using the "Combined" baking option, I am provided a flat dull diffuse image for my mesh, no gloss or normal info is saved.  My Node process for textures is displayed here  Here is the result of baking my textures as a Normal  The result of adding other textures made from Blender's baking, results in flat gloss at best.  What can I do differently in Blender, to have my assigned UV Diffuse, Normal, and Gloss maps all appear in a single object in Unity? For realism should I use the maximum number of Subsurf levels? I was wondering if I always need to use the maximum value of the options from the elements of "Add Modifier". For example, do I need to use the view 6 in Subdivision surface? I know it depends of what we are trying to achieve, but we all want the same. Make something look the most believable. So do you always use the maximum value Blender offers?