9
Can anyone query the oracle SQL query to convert a 10 digit figure into words?
source link: https://www.codesd.com/item/can-anyone-query-the-oracle-sql-query-to-convert-a-10-digit-figure-into-words.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Can anyone query the oracle SQL query to convert a 10 digit figure into words?
advertisements
can anyone tell the oracle sql query for converting 10 digit number into words? for example I have numbers like 9876543210 and i would to convert these numbers as NINE EIGHT SEVEN SIX FIVE FOUR THREE TWO ONE ZERO.
Actually, for this purpose, you can use a bunch of replace()s:
select replace(replace(. . . . replace(col, '0', 'ZERO '
), '1', 'ONE '
. . .
)
You'll need 10, one for each digit. You might want to throw in a TRIM() after the last one to remove the final space.
Related Articles
What is the most efficient way to convert an eight-digit number into a date?
I am using ColdFusion 9.0.1 and some database that I cannot change. I am accessing a database that stores a date as an eight digit numeric with zero decimal places like this: YYYYMMDD I need to be able to read the date, add and subtract days from a d
How to run the .sql file in the Oracle SQL Developer Tool to import the database?
I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB. I read about running scripts here, but I didn't understand the way. Is theere any command or query by which we can run this
JasperReport: How do I get the date of the "oracle.sql.TIMESTAMP" field?
I am using iReport 4.5.1 and i need to get the date from the oracle.sql.TIMESTAMP. Inside the expression i tried with these two: $F{DELIVERY_DATE}.dateValue() $F{DELIVERY_DATE}.timestampValue() but i am getting the same runtime error JasperReport Err
Can anyone explain the release?
Can anyone explain the output? #include<iostream> using namespace std; int &fun(){ static int x = 10; return x; } int main(){ fun() = 30; cout << fun(); return 0; } output is 30That's how static locals work - they persist the value between
Can anyone explain the following PHP code?
Can anyone explain the following PHP Code ? function get_param($param_name, $param_type = 0) { global $HTTP_POST_VARS, $HTTP_GET_VARS; $param_value = ""; if (isset($_POST)) { if (isset($_POST[$param_name]) && $param_type != GET) $param_v
Can anyone improve the Fuzzyfind function below for VBA?
This function lets you find similar strings from a range without having to do an exact search. The formula looks like this: =FuzzyFind(A1,B$1:B$20) assuming the string you are performing a search for is in A1 and your reference or options table is B1
How can I see the actual SQL of an ASP SqlDataSource will be executed (after linking)
This is a very simple question, but one I can't find an answer to. If I have an SqlDataSource that takes parameters, how can I see the actual SQL that will be executed against the DB after the binding takes place? (I have tried adding a breakpoint to
How can I rewrite the following SQL query in the LINQ query?
I want to rewrite the following sql query in LINQ. But my problem is that I don't know how to write add AND(&&) operator with a LINQ LEFT JOIN(look at my 2nd left join). Can anyone help please? SELECT emp.EmployeeId, dsg.Name, pob.CompanyContribut
Get the record range of the Oracle SQL query
I want to use this SQL query to get only the records between 8 and 10: select * from( SELECT a.*,rownum rn FROM ACTIVESESSIONSLOG a ORDER BY USERID ASC) WHERE rn >= 8 and rn <= 10 When I implement this SQL query into pagination I get every time 1 ro
Can I get the T-SQL query generated from a LinqDataSource?
I´m using the LinqDataSource to populate a grid. But now I need the SQL query that the LinqDataSource generates, to pass around throught methods (no, I can't modify the methods to not need a SQL query). Is there a way to obtain the generated SQL quer
The Oracle SQL query does not display the correct value
I have a table with following columns: id technology name_event time_event I count the number of values in a table with the following query select 1, 'Folder' as "Technology", 'Status' as "Name_Event", count(dm1.id) as "number of
How can I avoid this blocking in the Oracle.sql.ARRAY type?
We've come across the deadlock situation below when running multiple Java EE MDB instances that are trying to write to the DB: [deadlocked thread] [ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)': Thread '[ACTIVE] Execut
What causes the Oracle SQL execution plan to change based on the value of the where clause?
Why does the Oracle execution plan change based on a where clause value alone? I'm not talking bind variables, but in-place values in the SQL. For example running Explain Plan on these queries in SQL Developer: select col1, col2 from table1 where col
How to format the Oracle SQL text selection output only
I am using Oracle SQL (in SQLDeveloper, so I don't have access to SQLPLUS commands such as COLUMN) to execute a query that looks something like this: select assigner_staff_id as staff_id, active_flag, assign_date, complete_date, mod_date from work wh
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK