System & Database Related Solutions

by SaidRasel

Pages

▼

Showing posts with label Oracle SQL query. Show all posts

Showing posts with label Oracle SQL query. Show all posts

Tuesday, 6 December 2016

Find Oracle Database session from OS process

Execute the following query and find out the Database session SQL> select a.spid server, b.process client, b.username,b.status from v...

Thursday, 10 September 2015

Create a query to display the total number of employees and, of that total, the number of employees hired in 1995, 1996, 1997, and 1998. Create appropriate column headings

Create a query to display the total number of employees and, of that total, the number of employees hired in 1995, 1996, 1997, and 1998. Cr...

Wednesday, 18 June 2014

Basic Difference between CASE and DECODE Function in SQL (Oracle)

Before version 8.1, the DECODE was the only thing providing IF-THEN-ELSE functionality in Oracle SQL. Because DECODE can only compare dis...

Tuesday, 17 June 2014

Find position of current day in a year (Oracle SQL)

---Find the day against any number select to_date('365','ddd') find_date from dual; SQL> select to_date('365...

Tuesday, 3 June 2014

Find Top 100 SQL Statement based on CPU utilization

-----Find Top 100 SQL ID in Oracle---- select * from (select s.sql_id, RANK() OVER (ORDER BY (max(s.CPU_TIME_TOTAL)) DESC) cpu_rank, RA...

View web version

Powered by Blogger.