Saturday, May 5, 2018

Using LENGTH in PLSQL Query

https://randomsrsolutions.blogspot.com/2018/05/using-length-in-plsql-query.html

Shows the Length of a string as a numeric Value

Select LENGTH('ORACLE PLSQL') from dual;
12

Select ENAME  from EMP where LENGTH(ENAME) = 4;
KING
FORD
WARD

Select ENAME from EMP where ENAME Like '____';
KING
FORD
WARD

No comments:

Post a Comment

XLA to GL Link

  https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT             acr.cash_receipt_id,             acr.receipt_number,       ...