473,320 Members | 2,164 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

how to changing number to word in oracle forms

1
dear
how to changing number to word in oracle developer? i have an attachment like this, i am beginner in oracle forms and this site also. Can any one please help me out from this problem.
Attached Images
File Type: jpg number to word.jpg (147.2 KB, 145 views)
Jan 13 '19 #1
2 9813
Kkshivanii
4 Nibble
if you want to change 500 in words
input = 500
output = FIVE HUNDERED/=

SELECT UPPER(TO_CHAR(TO_DATE(500,'J'),'Jsp')) || '/=' AS new_value FROM dual;
Sep 24 '22 #2
pritikumari
23 16bit
I have written a very simple query which result a value 500, i need to convert this value like following:-

old value = 500

new value = FIVE HUNDERED/=

You can opt Oracle Training In Noida.
Feb 9 '23 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Kaix | last post by:
Hello, is there a possibility to control oracle forms form a external application. I like to push a value in a text field in a oracle forms app and "press" a button in this form. Maybe i can...
2
by: Azhar Bilgrami | last post by:
Hi: I want to Migrate Oracle form 3 to Oracle forms 6i, but I couldnt find that software on Oracle Website, can u please Help me?. Take care of ure self. Azhar
1
by: Chris | last post by:
Our company developed the last couple of years a development tool: using this tool we configure and program (using SQL, and Java-Script) very, very easy an application. The output of the effort is...
2
by: Thomas Kindermann | last post by:
Hello everyone, I'm an oracle database adminstrator and I search some information about possibilities to create easy forms for data input (for example for test data). My Oracle release is now...
1
by: chaticathe | last post by:
I am trying to determine the record number of a record in Oracle Forms so I can navigate to that record. I am using the code below but it only gives me the record number of the record I am currently...
0
by: anuj13singhal | last post by:
Hi, I am trying to open a word document on the client machine. the document is present on the oracle application server (on windows). For that I have created a java class file wordbean.class....
0
by: zellipa | last post by:
I am trying to imbed crystal in oracle. I got the following steps from the web. when i try to run the created from , iget the error frm-41344. Any suggestions. Regards, Zellipa STEPS TO...
5
by: paulnamroud | last post by:
Hi all, We have an application written with Oracle Forms 5.0 and report builder 3.05. We are using Oracle 8i as a database. We have around 50 forms and 10 reports. I'm in a process of...
6
by: ghssal | last post by:
HI how can run PL/SQL application as: create or replace function getChecksiffra (in_string varchar2) return number is xSvar number := 0; xNR number := 0; xSumma number := 0; ...
0
by: 987456321 | last post by:
We are using ERP software package based on Oracle forms 11g & Oracle DB 11g. For customization we need to integrate JSP page with Oracle forms 11g. Please suggest the way to integrate JSP with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.