Select Menu
  • Home
  • About
  • Contact us
  • Tutorials
    • Oracle Apps
    • PL/SQL Programming
  • Flows
    • P2P Cycle
    • O2C Cycle
  • Interview
    • Oracle Apps
    • PL/SQL
    • XML Publisher
    • SQL
    • Others
  • Downloads
  • Resumes
  • Interfaces
  • D2K
    • Forms
    • Reports

AskHareesh.com

AskHareesh Blog | Oracle | Fitness by Hareesh Pothuguntla

Complex SQL Queries In Oracle

›
To fetch ALTERNATE records from a table. (EVEN NUMBERED) select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) fr...
4 comments:

Spool data from sql*plus to a .csv file

›
Spool data from sql*plus to a .csv file We need to login the sql*plus, create an empty 'test.xls' file in the 'c:' d...
2 comments:
›
Home
View web version