Use two single-quotes
 

    SQL&gt; SELECT &#39;D&#39;&#39;COSTA&#39; name FROM DUAL;
     
    NAME
    -------
    D&#39;COSTA

Alternatively, use the [new (10g+) quoting method][1]:

    SQL&gt; SELECT q&#39;$D&#39;COSTA$&#39; NAME FROM DUAL;
    
    NAME
    -------
    D&#39;COSTA


  [1]: http://docs.oracle.com/database/121/SQLRF/sql_elements003.htm#SQLRF00218

I found the above answer giving an error with Oracle SQL, you also must use square brackets, below;

``` SQL&gt; SELECT Q&#39;[Paddy O&#39;Reilly]&#39; FROM DUAL; ```

----------
Result: **Paddy O&#39;Reilly**

Often I find myself doing the following:

    print &quot;Input text: &quot;
    input = gets.strip

Is there a graceful way to do this in one line? Something like:

    puts &quot;Input text: #{input = gets.strip}&quot;

The problem with this is that it waits for the input before displaying the prompt. Any ideas?

One liner in Ruby for displaying a prompt, getting input, and assigning to a variable?

Currently I am working on a legacy web page that uses a ton of JavaScript, jQuery, Microsoft client JavaScript, and other libraries. The bottom line - I cannot rewrite the entire page from scratch as the business cannot justify it.  So... it is what it is. Anyway, I need to pollute (I really tried not too) the global namespace with a variable. There are the three options I was thinking about -

1. Just store/retrieve it using a normal JavaScript declaration - `var x = 0;`

2. Use jQuery to store/retrieve the value in a DOM tag - `$(&quot;body&quot;).data(&quot;x&quot;, 0);`

3. Use a hidden form field, and set/retrieve the value with jQuery - `$(&quot;whatever&quot;).data(&quot;x&quot;, 0);`

Is there a better way? I looked at the existing pile of code, and I do not believe the variable can be scoped in a function.


How to store a global value (not necessarily a global variable) in jQuery?

How do I insert a record in a column having varchar data type having single quote in it?

**Example**: first name is `ROBERT` and last name is **`D&#39;COSTA`**

How to handle a single quote in Oracle SQL

How do I insert a record in a column having varchar data type having single quote in it?
Example: first name is <code>ROBERT</code> and last name is <code>D'COSTA</code>

NoSQL has been getting a lot of attention in our industry recently. I&#39;m really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should trigger a developer into thinking that particular datasets are more suited to a NoSQL solution. I&#39;m particularly interested in [MongoDB][1] and [CouchDB][2] as they seem to be getting the most coverage with regard to PHP development and that is my focus.


  [1]: http://www.mongodb.org/
  [2]: http://couchdb.apache.org/

Use cases for NoSQL

I need to set schema path in Postgres so that I don&#39;t every time specify schema dot table e.g. `schema2.table`. 
Set schema path:

    SET SCHEMA PATH a,b,c

only seems to work for one query session on mac, after I close query window the path variable sets itself back to default. 

How can I make it permanent?

Permanently Set Postgresql Schema Path

I looked around some and didn&#39;t find what I was after so here goes.

    SELECT * FROM trees WHERE trees.`title` LIKE  &#39;%elm%&#39;

This works fine, but not if the tree is named Elm or ELM etc...

How do I make SQL case insensitive for this wild-card search?

I&#39;m using MySQL 5 and Apache.

How can I search (case-insensitive) in a column using LIKE wildcard?

When should I use a primary key or an index? 

What are their differences and which is the best?

When should I use primary key or index?

Can anyone point out how to check if a select query returns non empty result set?

For example I have next query:

    SELECT * FROM service s WHERE s.service_id = ?;

Should I do something like next:

    ISNULL(SELECT * FROM service s WHERE s.service_id = ?)

to test if result set is not empty?

Simple check for SELECT query empty result

I&#39;m developing a web application and need to page ordered results. I normaly use LIMIT/OFFSET for this purpose.

Which is the best way to page ordered results in Oracle? I&#39;ve seen some samples using rownum and subqueries. Is that the way? Could you give me a sample for translating this SQL to Oracle:

    SELECT fieldA,fieldB 
    FROM table 
    ORDER BY fieldA 
    OFFSET 5 LIMIT 14

(I&#39;m using Oracle 10g, for what it&#39;s worth)

Thanks!

 


----------


 

**Answer:**
Using the link provided below by karim79, this SQL would look like:

    SELECT * FROM (
        SELECT rownum rnum, a.* 
        FROM(
            SELECT fieldA,fieldB 
            FROM table 
            ORDER BY fieldA 
        ) a 
        WHERE rownum &lt;=5+14
    )
    WHERE rnum &gt;=5



Alternatives to LIMIT and OFFSET for paging in Oracle

With help of this command ***`show databases;`*** I can see databases in *MySQL*.  

How to show the available databases in *Oracle*?

How to display databases in Oracle 11g using SQL*Plus

In SQL I (sadly) often have to use &quot;`LIKE`&quot; conditions due to databases that violate nearly every rule of normalization. I can&#39;t change that right now. But that&#39;s irrelevant to the question.

Further, I often use conditions like `WHERE something in (1,1,2,3,5,8,13,21)` for better readability and flexibility of my SQL statements.

Is there any possible way to combine these two things without writing complicated sub-selects?

I want something as easy as `WHERE something LIKE (&#39;bla%&#39;, &#39;%foo%&#39;, &#39;batz%&#39;)` instead of this:

    WHERE something LIKE &#39;bla%&#39;
    OR something LIKE &#39;%foo%&#39;
    OR something LIKE &#39;batz%&#39;

I&#39;m working with SQl Server and Oracle here but I&#39;m interested if this is possible in any RDBMS at all.

Is there a combination of &quot;LIKE&quot; and &quot;IN&quot; in SQL?

Is it possible to auto-generate a GUID into an Insert statement?

Also, what type of field should I use to store this GUID?


How to generate a GUID in Oracle?

i have a query like :

    SELECT column as averyveryveryverylongalias (more than 30 characters)
       FROM Table_name

it returns the error **ORA-00972 identifier is too long** , is there any tip to make it work without making the alias shorter?

Thanks

ORA-00972 identifier is too long alias column name

I am generating tables from classes in .NET and one problem is a class may have a field name `key` which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique)

    create table if not exists misc_info (
    id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
    key TEXT UNIQUE NOT NULL,
    value TEXT NOT NULL)ENGINE=INNODB;



How do I escape reserved words used as column names? MySQL/Create Table

Is there a function in PHP that can decode Unicode escape sequences like &quot;`\u00ed`&quot; to &quot;`&#237;`&quot; and all other similar occurrences?

I found similar question [here][1] but is doesn&#39;t seem to work.


  [1]: https://stackoverflow.com/questions/2045058/converting-these-types-of-unicode-to-utf8-in-php/2045105#2045105

How to decode Unicode escape sequences like &quot;\u00ed&quot; to proper UTF-8 encoded characters?

I have this code:

    a = &quot;xyz&quot;  
    g = &quot;abcd &quot; &amp; a  

After running it, the value of `g` is `abcd xyz`.

However, I want quotes around the value of `a` in `g`. After running the code, `g` should be `abcd &quot;xyz&quot;` instead.

How can I accomplish this?

Adding quotes to a string in VBScript

I have set up my coldfusion application to have dynamic urls on the page, such as 

    www.musicExplained/index.cfm/artist/:VariableName

However my variable names will sometimes contain slashes, such as 

    www.musicExplained/index.cfm/artist/GZA/Genius

This is causing a problem, because my application presumes that the slash in the variable name represents a different section of the website, the artists albums. So the URL will fail.

I am wondering if there is anyway to prevent this from happening? Do I need to use a function that replaces slashes in the variable names with another character?

slashes in url variables

When creating JSON data manually, how should I escape string fields? Should I use something like Apache Commons Lang&#39;s `StringEscapeUtilities.escapeHtml`, `StringEscapeUtilities.escapeXml`, or should I use `java.net.URLEncoder`?

The problem is that when I use `SEU.escapeHtml`, it doesn&#39;t escape quotes and when I wrap the whole string in a pair of `&#39;`s, a malformed JSON will be generated.


Content Type	Original Author	Original Content on Stackoverflow
Question	subhashis	View Question on Stackoverflow
Solution 1 - Sql	Vincent Malgrat	View Answer on Stackoverflow
Solution 2 - Sql	Mur3ph	View Answer on Stackoverflow

How to handle a single quote in Oracle SQL

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

How to store a global value (not necessarily a global variable) in jQuery?

One liner in Ruby for displaying a prompt, getting input, and assigning to a variable?

Attributions