You just need double-quotes around it:

    to_char(date_updated, &#39;YYYY-MM-DD&quot;T&quot;HH:mm:ss&#39;)


I can select the first customer node and change its company name with the code below.

But how do I select customer node where ID=2?

        XDocument xmldoc = new XDocument(
            new XDeclaration(&quot;1.0&quot;, &quot;utf-8&quot;, &quot;yes&quot;),
            new XComment(&quot;These are all the customers transfered from the database.&quot;),
            new XElement(&quot;Customers&quot;,
                new XElement(&quot;Customer&quot;,
                    new XAttribute(&quot;ID&quot;, 1),
                    new XElement(&quot;FullName&quot;, &quot;Jim Tester&quot;),
                    new XElement(&quot;Title&quot;, &quot;Developer&quot;),
                    new XElement(&quot;Company&quot;, &quot;Apple Inc.&quot;)
                    ),
                new XElement(&quot;Customer&quot;,
                    new XAttribute(&quot;ID&quot;, 2),
                    new XElement(&quot;FullName&quot;, &quot;John Testly&quot;),
                    new XElement(&quot;Title&quot;, &quot;Tester&quot;),
                    new XElement(&quot;Company&quot;, &quot;Google&quot;)
                    )
                )
            );

        XElement elementToChange = xmldoc.Element(&quot;Customers&quot;).Element(&quot;Customer&quot;).Element(&quot;Company&quot;);
        elementToChange.ReplaceWith(new XElement(&quot;Company&quot;, &quot;new company value...&quot;));


&lt;h2&gt;ANSWER:&lt;/h2&gt;

Thanks guys, for the record, here is the exact syntax to search out the company element in the customer-with-id-2 element, and then change only the value of the company element:

    XElement elementToChange = xmldoc.Element(&quot;Customers&quot;)
        .Elements(&quot;Customer&quot;)
        .Single(x =&gt; (int)x.Attribute(&quot;ID&quot;) == 2)
        .Element(&quot;Company&quot;);
    elementToChange.ReplaceWith(
        new XElement(&quot;Company&quot;, &quot;new company value...&quot;)
        );


&lt;h2&gt;ANSWER WITH METHOD SYNTAX:&lt;/h2&gt;

Just figured it out in method syntax as well:

    XElement elementToChange = (from c in xmldoc.Element(&quot;Customers&quot;)
                                    .Elements(&quot;Customer&quot;)
                                where (int)c.Attribute(&quot;ID&quot;) == 3
                                select c).Single().Element(&quot;Company&quot;);

How to select a specific node with LINQ-to-XML

In python, a module doesn&#39;t *have* to have a main function, but it is common practice to use the following idiom:

    def my_main_function():
        ... # some code

    if __name__==&quot;__main__&quot;:  # program&#39;s entry point
        my_main_function()

I know Ruby doesn&#39;t *have* to have a `main` method either, but is there some sort of best practice I should follow?  Should I name my method `main` or something?

The [Wikipedia page about main methods][1] doesn&#39;t really help me.

----------
As a side-note, I have also seen the following idiom in python:

    def my_main_function(args=[]):
        ... # some code

    if __name__==&quot;__main__&quot;:  # program&#39;s entry point
        import sys
        sys.exit(my_main_function(sys.argv))

  [1]: http://en.wikipedia.org/wiki/Main_function_(programming)#Ruby

Should I define a main method in my ruby scripts?

I am trying to print a date in a select statement, but I need to add a letter to the output:

    to_char(date_updated, &#39;YYYY-MM-DDTHH:mm:ss&#39;)

Oracle does not like the T. I just want the T to be output like the colons and the dashes. Can I escape it with a backslash or something?

What is the best way to escape non-format characters in Oracle&#39;s to_char?

I am trying to print a date in a select statement, but I need to add a letter to the output:
<pre><code class="hljs language-scss">to_char(date_updated, 'YYYY-MM-DDTHH:mm:ss')
</code></pre>
Oracle does not like the T. I just want the T to be output like the colons and the dashes. Can I escape it with a backslash or something?

I want to parse SQL code using C#.

Specifically, is there any freely available parser which can parse SQL code and generate a tree or any other structure out of it? It should also generate the proper tree for nested structures.

It should also return which kind of statement the node of this tree represents.

For example, if the node contains a loop condition then it should return that this is a &quot;loop type&quot; of a node.

Or is there any way by which I can parse the code in C# and generate a tree of the type I want?


Parsing SQL code in C#

In SQL Server this inserts 100 records, from the Customers table into tmpFerdeen  :-

    SELECT top(100)*
    INTO tmpFerdeen
    FROM Customers

Is it possible to do a SELECT INTO across a UNION ALL SELECT :-

    SELECT top(100)* 
    FROM Customers
    UNION All
    SELECT top(100)* 
    FROM CustomerEurope
    UNION All
    SELECT top(100)* 
    FROM CustomerAsia
    UNION All
    SELECT top(100)* 
    FROM CustomerAmericas

Not too sure where to add the INTO clause.

Is it possible to use the SELECT INTO clause with UNION [ALL]?

I am lost in a big database and I am not able to find where the data I get comes from. I was wondering if it is possible with SQL Server 2005 to search for a string in all tables, rows and columns of a database?

Does anybody has an idea if it is possible and how?

Search for a string in all tables, rows and columns of a DB

How would I return the column names of a table using SQL Server 2008? i.e. a table contains these columns- id, name, address, country and I want to return these as data.


How do you return the column names of a table?



Can someone explain SQL injection?  How does it cause vulnerabilities?  Where exactly is the point where SQL is injected?



  [1]: https://stackoverflow.com/search?q=sql+injection

What is SQL injection?

When creating a column of type NUMBER in Oracle, you have the option of not specifying a precision or scale.  What do these default do if you don&#39;t specify them?

What is the default Precision and Scale for a Number in Oracle?

How can I select `count(*)` from two different tables (call them `tab1` and `tab2`) having as result:

    Count_1   Count_2
    123       456


I&#39;ve tried this:

    select count(*) Count_1 from schema.tab1 union all select count(*) Count_2 from schema.tab2

But all I have is:

    Count_1
    123
    456



Select count(*) from multiple tables

My application, which uses an Oracle database, is going slow or appears to have stopped completely.

How can find out which queries are most expensive, so I can investigate further?


How to check Oracle database for long running queries

When I run the following in an Oracle shell it works fine

    truncate table table_name

But when I try to put it in a stored procedure

    CREATE OR REPLACE PROCEDURE test IS
    BEGIN
        truncate table table_name;
    END test;
    /

it fails with

    ERROR line 3, col 14, ending_line 3, ending_col 18, Found &#39;table&#39;, Expecting:  @   ROW  or   (   or   .   or   ;   :=

Why?

Truncating a table in a stored procedure

Using SQL Plus, you can run a **script** with the &quot;@&quot; operator from the command line, as in:

    c:\&gt;sqlplus username/password@databasename @&quot;c:\my_script.sql&quot;

But is it possible to just run a **single command** with a similar syntax, without a whole separate script file?  As in:

    c:\&gt;sqlplus username/password@databasename @execute some_procedure

I am interested in this because I want to write a batch file that simply executes a command, without generating a bunch of two-line &quot;.sql&quot; files.


Content Type	Original Author	Original Content on Stackoverflow
Question	Sixty4Bit	View Question on Stackoverflow
Solution 1 - Sql	Chad Birch	View Answer on Stackoverflow

What is the best way to escape non-format characters in Oracle's to_char?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Should I define a main method in my ruby scripts?

How to select a specific node with LINQ-to-XML

Attributions