I want to get set of mail Ids  but in my Query this is not getting parsed properly as single row.Please hlep me to solve this.      SELECT LISTAGG ( EMAIL) WITHIN GROUP (ORDER BY EMAIL) EMAIL1 FROM USER   WHERE ID IN (107) GROUP BY EMAIL      Current Output :  abdul@eetmx.com joseph@eetmx.com ranjith@eetmx.com   Expected Output :  abdul@eetmx.com,joseph@eetmx.com,ranjith@eetmx.com
I have a simple query:  select * from countries   with the following results:  country_name ------------ Albania Andorra Antigua .....   I would like to return the results in one row, so like this:  Albania, Andorra, Antigua, ...   Of course, I can write a PL/SQL function to do the job (I already did in Oracle 10g), but is there a nicer, preferably non-Oracle-specific solution (or may be a built-in function) for this task?  I would generally use it to avoid multiple rows in a sub-query, so if a person has more then one citizenship, I do not want her/him to be a duplicate in the list.  My question is based on the similar question on .  UPDATE: My function looks like this:  CREATE OR REPLACE FUNCTION APPEND_FIELD (sqlstr in varchar2, sep in varchar2 ) return varchar2 is ret varchar2(4000) := ''; TYPE cur_typ IS REF CURSOR; rec cur_typ; field varchar2(4000); begin      OPEN rec FOR sqlstr;      LOOP          FETCH rec INTO field;          EXIT WHEN rec%NOTFOUND;          ret := ret || field || sep;      END LOOP;      if length(ret) = 0 then           RETURN '';      else           RETURN substr(ret,1,length(ret)-length(sep));      end if; end;
Is it possible to restore a MySql database only using files from Data directory? I have a mysql installed inside a windows virtual machine. The hard drive was crashed and the system is not able to restore all again. But I can have access to entire c: ROOT. So I went to  c:/ProgramData/Mysql/Mysql Server 5.5/data/myDatabaseName    There I can see different files like: .frm, .opt, .trg and .trn. In a regular way, I could run a mysqldump to backup and restore all database from command line, but the system is not able to be restored. So I had to copy all these files and past inside inside the same  directory inside same database in another physical instance.   The issue is some tables are not been recognized by this new instance. So I think copy and past is not enough to restore the database.   What am I missing?    Note: Database has innoDb and Myisam tables. How to change an input button image using CSS So, I can create an input button with an image using &lt;INPUT type=&quot;image&quot; src=&quot;/images/Btn.PNG&quot; value=&quot;&quot;&gt;  But, I can't get the same behavior using CSS. For instance, I've tried &lt;INPUT type=&quot;image&quot; class=&quot;myButton&quot; value=&quot;&quot;&gt;  where &quot;myButton&quot; is defined in the CSS file as .myButton {     background:url(/images/Btn.PNG) no-repeat;     cursor:pointer;     width: 200px;     height: 100px;     border: none; }  If that's all I wanted to do, I could use the original style, but I want to change the button's appearance on hover (using a myButton:hover class). I know the links are good, because I've been able to load them for a background image for other parts of the page (just as a check). I found examples on the web of how to do it using JavaScript, but I'm looking for a CSS solution. I'm using Firefox 3.0.3 if that makes a difference. I'm planning to travel to France a few times in the next few months (tourist). Since I need a Schengen visa, I just don't know how to fill out the forms (which only have questions about travel dates of ONE single trip).  How do I report that I am traveling a few times, because if I don't they might only give me a single entry visa (or a visa not valid long enough for my next trips). I can only see that I'm requesting a multiple entry visa, nothing else about how long I need it to be valid.  Do I need to provide proof of hotel/flight reservations and travel insurance for all the trips or would the first one suffice?  How do I approach this issue so that I get a Schengen visa for at least 4.5 months? I am applying in the UK at their London application centre. This is actually a two part question:   Which methods are there to calculate average slope by unit (say km²) for a given area? Are there any special requirements on the data - like additional information besides height measurements? Which open source GIS implement methods usable to calculate average slope on a grid (e.g. TIF file)? "To shoot out of cannon into sparrows" In Russian we have idiom/saying "To shoot out of cannon into sparrows" (literal translation) which is used to convey an idea of applying too drastic measures to small problems. I believe there should be some native-English equivalents to this saying. Can you share if there are any? Is there a way to closely approximate the CDF of a student-t distribution at a point $x$ without involving the hypergeometric function? For example, by using a series expansion, or expressing the CDF in terms of simpler functions?  The t-distribution can   $$t = \frac{X\sqrt{n}}{Y}$$  where $X$ is normally distributed with mean 0 and variance $\sigma^2$; $\frac{Y^2}{\sigma^2}$ has a chi-squared distribution. Maybe this expression can help simplify the t CDF?  I am trying to write an algorithm to compute the student-t CDF for any real number, so using the hypergeometric function will be extremely difficult. I am also trying to avoid integrating the PDF to get the CDF. Anyone know a quick easy way to migrate a SQLite3 database to MySQL? NOTE: I am not interested in calling /secur/logout.jsp since it ends all the active salesforce sessions.  I am developing a web application that is registered on salesforce as a connected app, so I am using salesforce credentials to authorize the user.  Application is developed in REST API and the communication with salesforce is happening in restful manner.   Auth url:   Authorization:  Method 1: If there is no salesforce session active, The user is taken to salesforce login page, where he enters his salesforce details to be authorized and after which he is taken to home page of my web application.  Method 2: If there is already a salesforce session active in another tab, the user is directly authorized and is taken to home page of my web application.  Now I am trying to implement logout button for my application, such that the following scenarios are covered,  Scene 1: The user is authorized using method1, and the user press the logout. Upon trying to logback the user is prompted for credentials.  Scene 2:  The user is authorized using method2, and the user should use logout to logout of the web application (not from active sessions). Upon login, the user should be again able to login using method2.  Can someone help me on how to implement the logout button such that it covers scenario 1 &amp; 2.  Thanks in advance. A very easy probability problem but opinions diverge greatly. Need some help. The question itself is a very easy one:     Somebody has got two kids, one of whom is a girl. Then what's the probability that he's got at least one boy?   My answer is that, since he's already got a girl, then "he's got at least one boy" amounts to "the other kid is a boy", whose probability is apparently $\frac{1}{2}$. But my friends argue that the probability should be $\frac23$: they say this is a binomial distribution, all the possible cases are (girl,girl),(girl,boy),(boy,girl) which yields that the probability is two cases out of three and is thus $\frac23$. But I think this is totally unacceptable. I don't think it is a binomial distribution at all, at least not what my friends explained to me. However, I just can't disuade them of their opinion, nor can I prove that I am wrong. So what on earth is the probability? and why? Any help is appreciated. Thanks in advance. Esp. Can anybody show why my explanation is wrong? Isn't it that whether the other kid is a boy or a girl a 50/50 event?  EDIT: Thanks for all the help you provided for me, and special thanks will go to @HammyTheGreek and @KSmarts, who have made it clear to me that there is in fact some ambiguity in my statement in this problem. As is pointed in  ,two distinct interpretation of the statement "one of whom is a girl" that gives rise to ambiguity:     From all families with two children, at least one of whom is a boy, a family is chosen at random. This would yield the answer of 1/3.   From all families with two children, one child is selected at random, and the sex of that child is specified to be a boy. This would yield an answer of 1/2. When I press F3 to see the debug screen in I use Minecraft 1.8.1, some information is missing.   Most notably, there are no X, Y, Z coordinates.     What happened to my debug overlay? Who is the Maker? C-3PO frequently speaks of “the Maker.” Is this a true droid religion, or is this a religious reverence by droids for their specific creators (in this case, Anakin, even though C-3PO has forgotten who he is)? Is this even a droid thing or is it just C-3PO? What else do we know about this “Maker”-worship? Files list file for package missing -- dpkg warning I want to install Open JDK or Oracle JDK to my machine but I got an error during installation. The error is:  Selecting previously unselected package oracle-java8-installer. dpkg: warning: files list file for package 'unity-scope-gourmet' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-guayadeque' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-gmusicbrowser' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-manpages' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-firefoxbookmarks' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-gdrive' missing; assuming package has no files currently installed dpkg: warning: files list file for package 'unity-scope-home' missing; assuming package has no files currently installed E: Sub-process /usr/bin/dpkg returned an error code (2)   I searched on Google and try to something for install/reinstall this packages. Finally i try to remove Unity. I faced this error for my every tries. I am using Xmonad. How can I fix this issue? How to convert an instance of std::string to lower case How do I boot from ISO file stored on hard disk? Why does thermal radiation only occur at infrared and visible frequencies? The resources that I've checked out seem to say thermal radiation only occurs in the infrared and visible spectrum. For example my heat transfer textbook and the Wikipedia page on .  In my mind thermal radiation is just energy emitted as a result of internal collisions from temperature. So, since temperature can range from 0K to huge numbers, I would think you would have a similar range of emitted energies. So then thermal radiation could occur throughout the whole of the electromagnetic spectrum. I tried writing a shell script which can do automatic login into a ssh server using password which is mentioned in the script. I have written the following code:  set timeout 30 /usr/bin/ssh -p 8484 root@172.31.72.103 expect  {    "root@172.31.72.103's password"     {       send "password\r"     } }   This code is not running properly, still it is asking for the password. Can somebody please help me in solving this Let $S = \{ax + by: x,y \in \mathbb{Z}\}$  and let $e &gt; 0$ be the smallest element in $S$. Prove that $e \mid a$, and hence prove that $e = \gcd(a,b)$  I'm afraid I can't provide much of my initial working here because I'm at a loss of how to start.  I suppose that to show $e\mid a$ I would have to show that $eg = a$ for some $g \in \mathbb{Z}$. But I have no idea how I would do this. Repeated ANOVA unbalanced data I did experiment on one group of rats, the group was tested during 8 days, this is the first stage. The same group was also tested again but this time the test phase was 7 days. I tried to do my analysis using ANOVA repeated measures but I had a problem with the days.. I want to know the difference in the 2 tests but the days are not the same number. I don't know how to handle it. If there is any way to do the analysis using repeated measures ANOVA.   I tried to use repeated measure anova within subjects effect. My first factor will be test with 2 levels (test 1 &amp; 2),second factor is day with the level of ?? Here is the problem! if I write 8 there will be extra day in test 2 and the analysis cant carry!! How to combine array items with string substitution? Suppose we have an object in space. say gravity is negligible, and the thing has a rocket on both sides. the thing fires one rocket for, say, 5 seconds. now it's moving. The object has kinetic energy. Now the other rocket fires for 5 seconds. Then it's stationary. where does the energy go? I know that some of the energy from the rockets would just go into space as heat and kinetic energy of the hydrogen particles flying out, but how does there seem to be more energy in the situation if the first rocket just goes for 10 seconds than if one goes for 5 and the other goes for 5?