answersLogoWhite

0

rownum returns the number to indicatin th sequence,it always returns sequentially no. 1,2,3

so when we fired query for row 1

select * from emp where rownum=1 then first it gets 1 and show the result.

but,so when we fired query for row 2

select * from emp where rownum=2 then first it gets 1 and criteria is not match.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How many Indians work in oracle?

18%


How can i find a job at the Oracle?

Finding a job at Oracle requires a bachelors degree (computer science related), at least some work experience in the field and an Oracle Certification, which can be acquired in special courses held by Oracle.


Do inversion tables work?

Inversion tables do indeed work. As long as the user knows how to read the inversion table it should work well.


How do you delete row in oracle table from vb?

you right click it and you scole down to delete row in oracle table that should work


How does Zeus' oracle work?

Um, it's 'Zeus' and by magic.


Where can I find work tables for my home?

Sears is one of the top brands of work tables. At sears you can find the unique table you want, and also the price that you want it at. They have a wide variety of tables.


Where can you buy a work table?

You can buy work tables at ergomotion. These work tables are great and you can even get adjustable worktables, just in case your too short or tall for the work table you have.


What is a multiplication story for 4x6?

In a school art class, there are 4 tables, and each table has 6 paintbrushes. To find out how many paintbrushes there are in total, you can multiply the number of tables by the number of paintbrushes at each table. So, 4 tables times 6 paintbrushes equals 24 paintbrushes altogether. This way, every student can have a brush to work with!


Is there a prerequisite to oracle DBA training?

There are no specified prerequisites for the Oracle DBA training, if you do not have prior knowledge individuals will be given additional course work to complete.


Places where you work on objects such as tables forms and reports.?

Access Work Area


What should you study to be senior oracle?

To be senior we assume you are already at least junior or entry-level oracle - yes? And by "Oracle" we further assume you mean an Oracle database administrator (DBA) versus say a senior Oracle product manager. If you meant a DBA, then may we assume you already are familiar with Oracle publications like "Oracle Database 11g, The Complete Reference" ISBN 978-0-07-159875-0? Have you read the materials published by Oracle online at oracle's web site? If so, then to be considered a "senior" Oracle person, you will want to a) have at least three to five years work experience with Oracle technologies, and b) become accomplished with some of the soft skills, e.g., working with system administrators, working with application developers and customers, documenting your work, working with management. These are skills that separate the senior professional from the beginner. Piece of cake - go get them and prosper!


How exactly does Oracle BPEL work?

Oracle BPEL is a process manager which offers infrastructure for creating, deploying and managing BPEL business processes. It is both comprehensive and easy to use.