Fahd Bahoo Blog for Oracle Database

Thursday, 13 March 2014

CONNECT BY LEVEL

Purpose: Get Serialno

SELECT LEVEL just_a_column FROM dual CONNECT BY LEVEL <= 365
Posted by Fahd at 03:13
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pages

  • Home

About Me

Fahd
View my complete profile

Blog Archive

  • ►  2016 (1)
    • ►  January (1)
  • ▼  2014 (8)
    • ▼  March (8)
      • Quoting a String Literals in Oracle PL/SQL
      • How to Delete duplicate rows in Oracle Database
      • How to Generate Gape free sequence oracle
      • How to make Matrix Report in Oracle SQL (PIVIOT)
      • How to Enable PLSQL WARNINGS in Oracle
      • CONNECT BY LEVEL
      • How to Calculate Running Total in Oracle SQL
      • How to APPEND Hint Affects Redo Generation
Simple theme. Powered by Blogger.