I want to find out how much zero come after 1 in SQL

by

For fun, I’ll guess this:

select length('101000010') - length(replace('101000010', '10', '1')) "ZerosAfterOnes" from dual;

Result:

ZerosAfterOnes
--------------
             3

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. Dynamic Pivot in Oracle’s SQL
  3. Best way to do multi-row insert in Oracle?
  4. Why does Oracle 9i treat an empty string as NULL?
  5. How do I reset a sequence in Oracle?
  6. LISTAGG function: “result of string concatenation is too long”
  7. ORA-00904: invalid identifier
  8. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  9. How do I use variables in Oracle SQL Developer?
  10. How to use Oracle ORDER BY and ROWNUM correctly?
  11. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  12. How to use a calculated column to calculate another column in the same view
  13. How can I create a copy of an Oracle table without copying the data?
  14. Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate]
  15. How to get second largest or third largest entry from a table [duplicate]
  16. Split String by delimiter position using oracle SQL
  17. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  18. ORA 00904 Error:Invalid Identifier
  19. Update with Join query in Oracle
  20. What does the colon sign “:” do in a SQL query?
  21. Autoincrement in oracle to already created table
  22. SQL not displaying null values on a not equals query?
  23. What can cause an Oracle ROWID to change?
  24. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  25. Oracle query to match all values in the list among all rows in table
  26. Inserting into Oracle and retrieving the generated sequence ID
  27. How do I call an Oracle stored procedure from an Excel VBA script?
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment