Oracle: How do I convert hex to decimal in Oracle SQL?

by

If you are using 8.1.5 and above you can use:

To convert from hexadecimal to decimal:

select to_number('AA', 'xx') from dual;

To convert from decimal to hexadecimal:

select to_char(111, 'xxxx') from dual;

More Related Contents:

  1. Can we update primary key values of a table?
  2. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  3. How to display table data more clearly in oracle sqlplus
  4. Liquibase lock – reasons?
  5. How SID is different from Service name in Oracle tnsnames.ora
  6. Are foreign keys really necessary in a database design?
  7. Is it possible to generate django models from the database?
  8. What is a View in Oracle?
  9. What is the difference between Non-Repeatable Read and Phantom Read?
  10. Business Logic: Database or Application Layer
  11. Convert String ISO-8601 date to oracle’s timestamp datatype
  12. What is the default Precision and Scale for a Number in Oracle?
  13. How to select the nth row in a SQL database table?
  14. ORA-00904: invalid identifier
  15. Why am I getting “Data source name not found and no default driver specified” and how do I fix it?
  16. What’s wrong with foreign keys?
  17. How to get a count of number of documents in a collection with Cloud Firestore [duplicate]
  18. Would you store binary data in database or in file system? [closed]
  19. Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)
  20. Store query result in a variable using in PL/pgSQL
  21. How do ACID and database transactions work?
  22. Fabric.js – how to save canvas on server with custom attributes
  23. how to use Blob datatype in Postgres
  24. Are database triggers necessary? [closed]
  25. many-to-many relationship in database design
  26. HTML5 database storage (SQL lite) – few questions
  27. Adding a new value to an existing ENUM Type
  28. What’s the better database design: more tables or more columns?
  29. Android Room Persistence library and Kotlin
  30. How can I import a .sql file into my Heroku postgres database?

Leave a Comment