CREATE OR REPLACE FUNCTION rev_str_f(str VARCHAR2) RETURN VARCHAR2ISv_str VARCHAR2(10); –you can specify your own sizev_str_rev VARCHAR2(10); –specify same size as […]
Function to display reverse string of the given string in PL/SQL Read More »
Replace will replace the character or string with the given character/string for every occurrence of the character/string.Translate will replace the
Difference between REPLACE and TRANSLATE in SQL? Read More »
Procedure without Parameters: CREATE OR REPLACE PROCEDURE dept_sal_pISCURSOR C1 ISselect d.department_name,e.tot_sal from(SELECT department_id,sum(salary) tot_salFROM employeesGROUP BY department_idHAVING SUM(salary) > 50000)
Procedure to display the departments, which are having total salary greater than? Read More »
For even rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)WHERE rn =0; For odd rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2)
Write a SQL query to display alternate records from a table? Read More »
select manager,count(employee), rtrim(xmlagg(xmlelement(e,employee||’,’)).extract(‘//text()’),’,’) as “Employees under the Manager” from (select e2.first_name manager,e1.first_name employee from employee e1,employee e2 where e1.reporting_to=e2.employeeid) group
Write a query to display manager and employees under them? Read More »
