when i try to enter decimal numbers like 0.5 infields given it is instantly changing to .5 in oracle forms
If I enter values as 0.5 the zero before . is getting removed and displayed as .5 this is happening when i move to other field. is there any settings need to be done plz help
Solution
Open item's Property Palette and set Format mask to desired value. For example:
- How can I count only NULL values in Oracle/PLSQL?
- Oracle parallel query wait stats not in tkprof's report
- Query execution errors after upgrading spring boot 3.2.0 to 3.2.1 - ORA-00933 - command not properly ended
- I am updating table's column values with UPDATE and SELECT statement. But its not working
- I want to insert data into a column from its own table data?
- How to resolve ORA 00936 Missing Expression Error?
- Cypress 10 and connecting to an Oracle database
- Oracle SQL - Select oldest of 3 dates, but ignore NULLs
- Sleeping for a random amount of time in a stored procedure
- Keep getting error: PLS-00103: Encountered the symbol "CREATE"
- How to utilize WebDev.WebServer.exe (VS Web Server) in x64?
- How to modify query converting DATEDIFF to Oracle accepted syntax?
- Oracle database dependencies in PL/SQL
- In Oracle: How to sort by group/cluster by a column value
- oracle SQL query - add date rows using different date
- Oracle Apex Change date picker format
- Can't login as sysdba in oracle sqlplus
- What is the cause of this problem "IO Error: The Network Adapter could not establish the connection" on Sql Developer?
- Getting error as ORA-01821: date format not recognized in Oracle
- Running a dynamically generated MERGE INTO statement in a loop throws "ORA-01489: result of string concatenation is too long" error
- How to compare two rows column by column?
- Translate excel formulas into SQL query
- Django: how to see the SQL query when running tests?
- ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
- How to partition an oracle table by a date column?
- Oracle 19c :: Failed to set ACL's for specified User
- C# Pass array of objects (UDT) to oracle stored procedure returns exception 'Column contains NULL data' on ExecuteReader
- Selecting from 1 table and put the result into 2 column
- Oracle DBMS_SQL giving ORA-1007 variable not in select list
- Oracle SQL Need to identify distinct PK values where a grouped set contains a specified value in a column