Siva Academy
Siva Academy
Youtube.com/SivaAcademy
Oracle SQL |  PLSQL |
SQL PLSQL Interview Questions
|
PLSQL Scenario based Interview Questions
|
Subscriber Questions & Answers
| SQL practical Question |
SQL Performance Tuning
| New Features |
Trigger
|
View
Saturday, June 22, 2019
Reverse the String without using reverse function
WITH t AS (
SELECT 'WELCOME TO SQL CLASS' d
FROM dual
) SELECT LISTAGG(s) WITHIN GROUP(ORDER BY l DESC)
FROM
(
SELECT level l,substr(d,level,1) s
FROM t
CONNECT BY level <= length(d)
);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
SQL to Find number of saturday and sunday in the current month
SQL to Find number of saturday and sunday in the current month SELECT TO_CHAR(c_date,'DAY') day, COUNT(*) FROM ...
profile PLSQL code using DBMS_PROFILER
Create the profiler tables from the table creation script available in oracle home directory @C:\orclee18c\WINDOWS.X64_180000_db_home_OR...
PLSQL Block to print list of employee name
1. Oracle PLSQL Practical Interview Questions Write a PLSQL block to print the list of employee names set serveroutput on DECLA...
No comments:
Post a Comment