using ansi sql syntax for formatting Numeric

Posted by changed on Stack Overflow See other posts from Stack Overflow or by changed
Published on 2010-06-09T16:19:12Z Indexed on 2010/06/09 16:22 UTC
Read the original article Hit count: 188

Filed under:

formatting

|

ansi-sql

Hi

I am using two different databases for my project. Oracle and apache derby and trying to use as much as possible ansi sql syntax supported by both of the databases.

I have a table with column amount_paid NUMERIC(26,2), in a table.

My old code which was using oracle db need to retrieve value in this format

SELECT LTRIM(TO_CHAR(amount_paid,'9,999,999,999,999.99')) .

How can i do this using ANSI sql syntax.

© Stack Overflow or respective owner

Related posts about formatting

C++ Formatting like visual studio c# formatting

as seen on Stack Overflow - Search for 'Stack Overflow'
I like the way Visual studio (2008) format C# code; unfortunately it seems it doesn't behave in the same way when writing C++ code. For example, when I write a code in this way: class Test { public: int x; Test() {this->x=20;} ~Test(){} }; in C# (ok this is C++ but you can understand… >>> More
Why do XSLT editors insert tab or space characters into XSLT to format it?

as seen on Programmers - Search for 'Programmers'
All XSLT editors I've tried till now add tab or space characters to the XSLT to indent it for formatting. This is done even in places within the XSLT where these characters are significant to the XSLT processor. XSLT modified for formatting in this way can produce output very different to that of… >>> More
Excel: conditionally format a cell using the format of another, content-matching cell

as seen on Super User - Search for 'Super User'
I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting. So for example, my key is as follows, with one value per cell and the visual formatting indicated in parentheses: A (red… >>> More
Globalize your Web Applications: PHP's Locale Formatting Classes

as seen on Internet.com - Search for 'Internet.com'
In part 3 of the Globalize your Web Applications series, we'll be exploring PHP's I18N_Number and I18N_Currency classes, both of which are part of the I18N Libraries. >>> More
Tip#102: Did you know… How to specify tag specific formatting

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Let’s see this with an example. I have the following html code on my page. Now if I format the document by selecting Edit –> Format document (or Ctrl K, Ctrl D) The document becomes I want the content inside td should remain on the same line Read More......(read more) >>> More

Related posts about ansi-sql

Using multiple aggregate functions in an (ANSI) SQL statement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have aggregate functions foo(), foobar(), fredstats(), barneystats() I want to create a domain specific query language (DSQL) above my DB, to facilitate using a domain language to query the DB. The 'language' comprises of algebraic expressions (or more specifically SQL like criteria) which I… >>> More
Combining aggregate functions in an (ANSI) SQL statement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have aggregate functions foo(), foobar(), fredstats(), barneystats() I want to create a domain specific query language (DSQL) above my DB, to facilitate using using a domain language to query the DB. The 'language' comprises of boolean expressions (or more specifically SQL like criteria) which… >>> More
Using multiple aggregate functions in an algebraic expression in (ANSI) SQL statement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following aggregate functions (AGG FUNCs): foo(), foobar(), fredstats(), barneystats(). I want to know if I can use multiple AGG FUNCs in an algebraic expression. This may seem a strange/simplistic question for seasoned SQL developers - however, the but the reason I ask is that so far… >>> More
ANSI SQL Hierarchical Data Processing Basics

as seen on Internet.com - Search for 'Internet.com'
The SQL-92 standard unknowingly and without planning introduced the capability to perform full hierarchical data processing with its introduction of the LEFT Outer Join operation. This natural hierarchical processing capability will be explained in this article. >>> More
Aggregate functions in ANSI SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to use multiple aggregate functions in a query. All the examples i have seem on aggregate functions however, are trivial. Typically, they are of the form: SELECT field1,agg_func1, agg_func2 GROUP BY SOME_COLUMNS HAVING agg_func1 OP SOME_SCALAR Where: OP: is a boolean operator (e.g. <… >>> More