How to publish an analysis to with RStudio on Windows

It seems a lot of people are facing the same issue while trying to upload a research on using the Publish button in RStudio.

     Error in function (type, msg, asError = TRUE)  : 
     SSL certificate problem, verify that the CA cert is OK. Details:
     error:14090086:SSL      routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
     Calls: rpubsUpload … <Anonymous> -> .postForm -> .Call ->           <Anonymous> -> fun
     Execution halted
That problem mostly affects Windows users. To get rid of it:
  1. Make sure you have the packages “bitops” and “Rcurl” installed
  2. In your RProfile file ( C:\Program Files\R\R-3.1.1\library\base\R) add these 2 lines:

It worked for me!



Oracle equivalent of MySQL group_concat

MySQL has a very useful function called GROUP_CONCAT() that concatenate the aggregated values of a group (GROUP BY). With Oracle 11G, you can use listagg to do the same, but Oracle 10G does not have an equivalent function.

If you are still working with Oracle 10G, this is the simplest way I found to concatenate aggregated values.

The separator used CANNOT be present in any of the concatenated values . It can be a problem if you deal with large text. I used “|” because I know it’s a character that cannot be present in my values.

Original Data:

Oracle Group Concat






Concatenated Data

Oracle Group Concat 2