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
Subscribe to:
Post Comments (Atom)
XLA to GL Link
https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT acr.cash_receipt_id, acr.receipt_number, ...
-
https://plsqlquery.blogspot.com/2018/05/using-outer-joins-in-plsql-query.html We use Outer Join when mismatched Values to be displayed ...
-
https://plsqlquery.blogspot.com/2018/05/using-trim-in-plsql-query.html The Oracle/PLSQL TRIM function removes all specified characters eit...
-
https://randomsrsolutions.blogspot.com/2018/05/using-trunc-function-with-numbers-in.html The TRUNC function Truncates the Column, Expressi...
No comments:
Post a Comment