Use -1 as the start position:

    INSTR(&#39;JD-EQ-0001&#39;, &#39;-&#39;, -1)

I would like my script to act differently in an interactive shell session and when running with redirected stdout (for example when piped to some other command).

How do I recognize which of these two happen in a Python script?

Example of such behavior in existing program: grep --color=auto highlights matches when running in interactive shell, but doesn&#39;t when piped to something else.

How to recognize whether a script is running on a tty?

How can you display a long string, website address, word or set of symbols with automatic line breaks to keep a div width? I guess a wordwrap of sorts. Usually adding a space works but is there a CSS solution such as word-wrap?

For example it (very nastily) overlaps divs, forces horizontal scrolling etc. 
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww 

What can I add to the above string to fit it neatly within a few lines in a div or within the browser window?

wordwrap a very long string

I need to find the last index of a string (e.g. `-`) within another string (e.g. `JD-EQ-0001` in Oracle&#39;s SQL (*version 8i*).  Is there a way to do this with `INSTR()` or another function?

Finding last index of a string in Oracle

<p>I need to find the last index of a string (e.g. <code>-</code>) within another string (e.g. <code>JD-EQ-0001</code> in Oracle's SQL (<em>version 8i</em>).  Is there a way to do this with <code>INSTR()</code> or another function?</p>


I&#39;m trying to optimize a query but don&#39;t quite understand some of the information returned from **Explain Plan**. Can anyone tell me the significance of the OPTIONS and COST columns? In the OPTIONS column, I only see the word FULL. In the COST column, I can deduce that a lower cost means a faster query. But what exactly does the cost value represent and what is an acceptable threshold?

Understanding the results of Execute Explain Plan in Oracle SQL Developer

I have a PL/SQL function (running on Oracle 10g) in which I update some rows. Is there a way to find out how many rows were affected by the UPDATE? When executing the query manually it tells me how many rows were affected, I want to get that number in PL/SQL.

Number of rows affected by an UPDATE in PL/SQL

What is the difference between a user and a schema in Oracle? 

Difference between a user and a schema in Oracle?

In Oracle, what is the the default ordering of rows for a select query if no &quot;order by&quot; clause is specified. 

Is it 

 1. the order in which the rows were inserted
 2. there is no default ordering at all
 3. none of the above.

Default row ordering for select query in oracle

Are there non obvious differences between NVL and Coalesce in Oracle?

The obvious differences are that coalesce will return the first non null item in its parameter list whereas nvl only takes two parameters and returns the first if it is not null, otherwise it returns the second.

It seems that NVL may just be a &#39;Base Case&quot; version of coalesce.

Am I missing something?

Oracle Differences between NVL and Coalesce

I am looking to find out why strncpy is considered insecure.  Does anybody have any sort of documentation on this or examples of an exploit using it?

Why is strncpy insecure?

How do I remove the carriage return character `(\r)` and the new line character`(\n)` from the end of a string?

Removing carriage return and new-line from the end of a string in c#

How can I find out if a string ends with another string in C++?

Find out if string ends with another string in C++

I&#39;m a beginner with both Python and RegEx, and I would like to know how to make a string that takes symbols and replaces them with spaces. Any help is great.

For example:

    how much for the maple syrup? $20.99? That&#39;s ricidulous!!!

into:

    how much for the maple syrup 20 99 That s ridiculous



How to remove symbols from a string with Python?

Coming from Perl, I sure am missing the &quot;here-document&quot; means of creating a multi-line string in source code:

    $string = &lt;&lt;&quot;EOF&quot;  # create a three-line string
    text
    text
    text
    EOF

In Java, I have to have cumbersome quotes and plus signs on every line as I concatenate my multiline string from scratch.

What are some better alternatives?  Define my string in a properties file?

**Edit**: Two answers say StringBuilder.append() is preferable to the plus notation.  Could anyone elaborate as to why they think so?  It doesn&#39;t look more preferable to me at all.  I&#39;m looking for a way around the fact that multiline strings are not a first-class language construct, which means I definitely don&#39;t want to replace a first-class language construct (string concatenation with plus) with method calls.

**Edit**: To clarify my question further, I&#39;m not concerned about performance at all.  I&#39;m concerned about maintainability and design issues.

Content Type	Original Author	Original Content on Stackoverflow
Question	JDunkerley	View Question on Stackoverflow
Solution 1 - Oracle	jim0thy	View Answer on Stackoverflow

Finding last index of a string in Oracle

Oracle Problem Overview

Oracle Solutions

Solution 1 - Oracle

wordwrap a very long string

How to recognize whether a script is running on a tty?

Attributions