INSERT ALL without a select statement? Hope someone can help me. I want to add many records into a table from a statement I build. For example:  ProjectSQL = "INSERT ALL " For each Proj in split(Request.Form("ShowProjects"))   ProjectSQL = ProjectSQL &amp; "  INTO proj_tbl (proj_id) VALUES ('" &amp; Proj &amp; "') " Next db.Execute ProjectSQL  The SQL is: INSERT ALL    INTO proj_tbl (proj_id) VALUES ('45)    INTO proj_tbl (proj_id) VALUES ('56)    INTO proj_tbl (proj_id) VALUES ('92)     Oracle SQL wants a Select statement at the end.   I don't want to hammer the database with each loop because there could be many records to add (and the dba will cut off my balls).  Can someone tell me how to do this?  Thanks.
Best way to do multi-row insert in Oracle? I'm looking for a good way to perform multi-row inserts into an Oracle 9 database.  The following works in MySQL but doesn't seem to be supported in Oracle.  INSERT INTO TMP_DIM_EXCH_RT  (EXCH_WH_KEY,   EXCH_NAT_KEY,   EXCH_DATE, EXCH_RATE,   FROM_CURCY_CD,   TO_CURCY_CD,   EXCH_EFF_DATE,   EXCH_EFF_END_DATE,   EXCH_LAST_UPDATED_DATE)  VALUES     (1, 1, '28-AUG-2008', 109.49, 'USD', 'JPY', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),     (2, 1, '28-AUG-2008', .54, 'USD', 'GBP', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),     (3, 1, '28-AUG-2008', 1.05, 'USD', 'CAD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),     (4, 1, '28-AUG-2008', .68, 'USD', 'EUR', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),     (5, 1, '28-AUG-2008', 1.16, 'USD', 'AUD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),     (6, 1, '28-AUG-2008', 7.81, 'USD', 'HKD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008');
Title used for an autokrat in an Asimov story? I want to make Morrocan-stye pickled lemons, but I was only able to find , and it says:  In On Food and Cooking, Harold McGee suggests that a solution of five to 10% salt is needed to achieve a good North African-style preserved lemon  I make sauerkraut with 20 grams of salt per kilogram of cabbage, so 2%. So lemons taking much more salt than cabbage is surprising and confusing; since they start out acidic, I would expect them if anything to require less salt. I'm not worried about harmful microbes growing; I'm worried about the fermentation microbes not being able to grow. It's my understanding that higher salt concentrations with cabbage not only slow down fermentation, but actually .  had the same issues:  I've never quite understood the need for such excessive salting when making preserved lemons. They still ferment great at normal levels of salt, and you then need to worry less about them being overly salty to use in future recipes. As far as I can tell it's solely from tradition. Also, from checking out On Food and Cooking, it seems that McGee only points out that originally they are done with 5 to 10% salt content. I'm curious where you read/saw that he recommended such?  Does anyone have any text- and/or experience-based opinion agreeing or disagreeing with the &quot;5 to 10%&quot; figure? Hill Cipher known plaintext attack I know a plaintext - ciphertext couple of length 6 for a hill cipher where its key is a [3x3] matrix.  Based on what I've read and learned, to attack and crack keys of [n x n], if we know a plaintext - ciphertext duo of length $n^2$ then we have our set of n equations with n variables, and this is generally solvable. However in my case there is only length of $6$ instead of $n^2 = 9$ .   My question is, how will I solve this problem and find the key? Or, since this is an obvious homework question, what should be my way of thinking? I cannot think of anything else but matrix multiplications and inverses but they do not help me at all. What is $48\div2(9+3)$? There is a huge debate on the internet on the value of $48\div2(9+3)$. I believe the answer $2$ as I believe it is part of the bracket operation in BEDMAS.  yields the same answer. I also believe that if $48\div2\times(9+3)$ was asked it would be $288$ which Mathway agrees with as well. However,  says it is $288$ either way. A friend of mine (who is better at math) told me that there is no such thing as 'implicit multiplication', only shorthand so that is in fact done after the division (going left to right, not necessarily because division occurs before multiplication. But he didn't explicitly give a reason) What is the answer and why? Partner with "traditional" forums to support open ended discussions I have some auto-generated T-SQL, which is probably valid, but I don't really understand.  ALTER TABLE [dbo].[MyTable] WITH CHECK CHECK CONSTRAINT [My_FORIEGN_KEY];   I know what a foreign key constraint is, but what's the CHECK CHECK? How to ensure that all traffic goes through VPN connection once it has been started? I connect to the internet through a VPN provider along with other precautions in order to ensure privacy (against traffic analysis by agencies of a repressive government). I currently use  to configure and establish the VPN connection. Tunnelblick does not allow automatically connecting to the provider at or before login so I need to connect manually each time, and sometimes the connection is lost.  I need any and all traffic to go through the VPN connection at all times; whenever the VPN isn't connectable for whatever reason, I want the fallback to be no connection. I need to ensure   that OS X does not connect to the internet on my regular internet connection, or at all, during boot (until the login screen, for time synchronization and other possible "call home" stuff etc.). What services, if any, try to do this, and how can I practically analyze and change what's going on with networking during boot? Is there a way to connect to VPN earlier than right after login? that if my VPN connection is temporarily lost, applications do not continue to communicate over my regular unencrypted connection.    I basically want the system to act as if the network connection is lost altogether if the VPN connection fails, but currently they just continue to work as if nothing happened. What can I do to my system so that once a VPN is established, all traffic can only flow through that connection and no traffic can flow if the connection drops? Why won't Amanita move in and settle down? How can you prove that a function has no closed form integral? In the past, I've come across statements  along the lines of &quot;function $f(x)$ has no closed form integral&quot;, which I assume means that there is no combination of the operations:  addition/subtraction multiplication/division raising to powers and roots trigonometric functions exponential functions logarithmic functions  which when differentiated gives the function $f(x)$. I've heard this said about the function $f(x) = x^x$, for example. What sort of techniques are used to prove statements like this? What is this branch of mathematics called?  Merged with &quot;&quot; by : Sometimes we are told that some functions like $\dfrac{\sin(x)}{x}$ don't have an indefinite integral, or that it can't be expressed in term of other simple functions. I wonder how we can prove that kind of assertion? How does the simulation hypothesis relate to the ethics of simulated violence? Say, for the sake of this question,  is real. Are we then hurting "persons"/conscious beings in "our simulations" - video games - when we fight them? Why (not)? If so, is this unethical? Think for example about shooting an alien in the game No Man's Sky.  Edit/answer on the comment of Joseph Weissman: My reasoning is like this:   It is unethical to harm a person (with a person being everything that has ). By the simulation hypothesis (assuming it's true), everything around us (everything that we know of), is simulated. By 1 and 2, all persons we know of are simulated. So it's unethical to harm the simulated persons around us. A game is a simulation just like we are in a simulation, so the game has simulated persons. Therefore -  - it's unethical to harm the persons in a video game.   I know that the premises - besides the simulation hypothesis itself - are debatable, but that's the reason I asked the question in the first place.  I was also thinking that the characters in the video game differ because they have far less to no intelligence, that much of it is scripted. But I neither have a proof that we ourselves aren't scripted, with free will being an illusion. Also, how intelligent does a character in a simulation/video game has to be to have personhood then? I think this is a case of the .  Just to be sure, please note that this question is not about whether the simulation hypothesis is true or how likely it is to be true. It is about (one of the) consequences if the simulation hypothesis is true. It's also not a question about violence in games in general. How does bash interpret the equal operator with no surrounding spaces in a conditional? The following script does not behave as I would have expected.  Adding spaces around the '=' in the conditional made it perform how I wanted, but it got me thinking, what is it actually doing inside the conditional?  #!/bin/bash S1='foo' S2='bar' if [ $S1=$S2 ]; then     echo "S1('$S1') is equal to S2('$S2') fi echo $S1 echo $S2   The output is:  S1('foo') is equal to S2('bar') foo bar   The contents of S1 and S2 don't change from what they are assigned, so the = doesn't perform an assignment. Define functions in structs Absolute Value Symbols What is the "best LaTeX practices" for writing absolute value symbols?  Are there any packages which provide good methods?  Some options include |x| and \mid x \mid, but I'm not sure which is best... Creating a temporary directory in Windows? What's the best way to get a temp directory name in Windows?  I see that I can use GetTempPath and GetTempFileName to create a temporary file, but is there any equivalent to the Linux / BSD  function for creating a temporary directory? Suppose $T$ is the subset of $M_2(\mathbb{Z})$ of lower triangular matrices, those of form $\begin{pmatrix} a &amp; 0 \\ b &amp; c\end{pmatrix}$. So $T$ is a subring. Now I know that the ideals of $M_2(\mathbb{Z})$ are all of the form $M_2(I)$ for $I$ and ideal of $\mathbb{Z}$.   However, is there a nice way to describe all the ideals in $T$ specifically, or does it not behave quite as nicely? Live USB for Ubuntu 13.10 does't recognize Windows 8 OS Why are my SVG imports so small? How to solve apt "package cannot be configured because package is in a different version" errors? are more efficient than ordinary upright bicycles, and  are even more efficient. Then why do we see them so rarely on the road? Is it because they are expensive, or are there some non-financial, significant disadvantages? Are vacuum fluctuations really happening all the time?