oracle11goracle10goracle-apexoracle-apex-5.1oracle-apex-5
Capitalize the First Letter of my item, oracle apex
I have an apex page item P10_NAME here i need to enter only capital letter , it should not allow users to enter lower case, while entering the data i need to restrict instead of checking while save the record.
How to perform this
Eg: P10_NAME : hjhjhj --- it should not allow lower case
P10_NAME : ASDASD ---- allow
Solution
It is Apex 20.2 (don't have 5.x any more so I can't check); it lets you use appropriate settings which take care about letter case:
If your Apex version doesn't support it, then navigate to "Advanced" set of properties and put this into Custom Attributes:
style="text-transform:uppercase"
- Oracle Invalid Identifier Can't Find Field in Subquery
- ORA-0020: Maximum number of processes (150) exceeded
- ORA-00932: inconsistent datatypes: expected - got BLOB
- Get table does not exist error, when trying to insert into table from a trigger
- How do I select everything after a certain position using REGEXP in Oracle
- How to calculate daily in out working hours
- Modify a column to NULL - Oracle
- Sleep function in ORACLE
- I am trying to alter a type in object relational model to add a member function to it, but it keeps giving me errors
- Logic on Oracle Tree
- SQL Error [900] [42000]: ORA-00900: invalid SQL statement
- How to get the comma seperated value of a column to display as next values in oracle apex grid
- Isolate null value with REGEXP_LIKE
- how to query a different view depending on oracle version
- INSERT INTO with validated (limited) values
- Why am I getting "A sql/plsql compilation error occured." error because of semicolons in trigger creation?
- compare comma seperated strings if there is the same number in them
- How to summarise data using CTE
- Function returned without value in Oracle
- Order of execution of trigger and statements in Oracle stored procedure
- Dynamic pivot in oracle sql - Procedure
- Why does CONNECT in SQL Developer not work the way it is expected to work
- How can I select from list of values in Oracle
- How to add more space between the concatenate of two columns in sql query
- Getting error in console : Failed to load resource: net::ERR_CONNECTION_RESET
- Oracle - Convert UTC Date to Local Date Time US Format
- Lock a table in oracle
- Prevent blank padding in query response from a char type column in oracle
- What are some online compilers to compile and run PL/SQL?
- Best way to run Oracle queries periodically