Query to display first n records of the table
Structure and data of the table i used
query to display first n records of the table. where &n is a substitution variable in oracle, whose values can be assigned at runtime, very much similar to scanf function in C language
rownum column i used here is a pseudo-column supplied from oracle with every table that you create. Be sure with the behaviour of rownum. check the below queries to understand the behaviour
Structure and data of the table i used