Display the records between two range?

Display the records between two range?
by

1 Answer

Answer :

select rownum, empno, ename from emp where rowid in (select rowid
from emp where rownum <=&upto minus select rowid from emp
where rownum<&Start);
by

Related questions

Display Odd/ Even number of records?

Description : Display Odd/ Even number of records?

Last Answer : Odd number of records: select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp); Output:- 1 3 5 Even number of records: select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp) Output:- 2 4 6

How you will avoid duplicating records in a query?

Description : How you will avoid duplicating records in a query?

Last Answer : By using DISTINCT

A query fetched 10 records How many times does a PRE- QUERY Trigger and POST-QUERY Trigger will get executed ?

Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What are the Built-ins to display the user-named editor?

Description : What are the Built-ins to display the user-named editor?

Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

What are the built_ins used the display the LOV?

Description : What are the built_ins used the display the LOV?

Last Answer : Show_lov List_values

Display the number value in Words?

Description : Display the number value in Words?

Last Answer : SQL> select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp; the output like, SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP')) --------- ---------------------------------------- 800 ... ---------- 800 Rs. Eight Hundred only. 1600 Rs. One Thousand Six Hundred only. 1250 Rs. One Thousand Two Hundred Fifty only.

What buil-in routines are used to display editor dynamicaly?

Description : What buil-in routines are used to display editor dynamicaly?

Last Answer : Edit_text item show_editor LOV

What are the display styles of an alert?

Description : What are the display styles of an alert?

Last Answer : Stop, Caution, note

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

What are the different display styles of list items?

Description : What are the different display styles of list items?

Last Answer : Pop_listText_listCombo box

How do you display console on a window ?

Description : How do you display console on a window ?

Last Answer : The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window form ... the name of any window in the form. To include the console, set console window to Null.

What is the difference between Range Partitioning and Hash Partitioning?

Description : What is the difference between Range Partitioning and Hash Partitioning?

Last Answer : Range Partitioning maps data to partitions based on a range of column values (e.g. a date column) Hash Partitioning maps data to partitions based on a hashing algorithm, evenly distributing data between ... . This is typically used where ranges aren't appropriate, i.e. customer number, product ID

If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Description : If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Last Answer : The correct answer is(a) 22.167

A DVM has a 3 1/2 digit display. The 1 volt range can read upon

Description : A DVM has a 3 1/2 digit display. The 1 volt range can read upon

Last Answer : A DVM has a 3 1/2 digit display. The 1 volt range can read upon 1.999.

ADVM has a 4 ½ digit display. The 1 volts range can read up to :

Description : ADVM has a 4 ½ digit display. The 1 volts range can read up to :

Last Answer : ADVM has a 4 ½ digit display. The 1 volts range can read up to : 1.9999

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

Name two files used for network connection to a database.

Description : Name two files used for network connection to a database.

Last Answer : TNSNAMES.ORA and SQLNET.ORA

Give two methods you could use to determine what DDL changes have been made.

Description : Give two methods you could use to determine what DDL changes have been made.

Last Answer : You could use Logminer or Streams

Give two examples of referential integrity constraints.

Description : Give two examples of referential integrity constraints.

Last Answer : rential integrity constraints.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Give two examples of how you might determine the structure of the table DEPT.

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What are two parts of package ?

Description : What are two parts of package ?

Last Answer : The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema. Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

Explain the two type of Cursors ?

Description : Explain the two type of Cursors ?

Last Answer : There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

Two popup pages can appear on the screen at a time ? Two popup pages can appear on the screen at a time ? a. True. b. False?

Description : Two popup pages can appear on the screen at a time ? Two popup pages can appear on the screen at a time ? a. True. b. False?

Last Answer : a. True.

Name the two files that are created when you generate the form give the filex extension ?

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Can we create two blocks with the same name in form 3.0 ?

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

What are the two ways by which data can be generated for a parameters list of values?

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

What are the two panes that Appear in the design time pl/sql interpreter?

Description : What are the two panes that Appear in the design time pl/sql interpreter?

Last Answer : 1. Source pane. 2. Interpreter pane

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

What are the two repeating frame always associated with matrix object?

Description : What are the two repeating frame always associated with matrix object?

Last Answer : One down repeating frame below one across repeating frame.

What are the two phases of block coordination?

Description : What are the two phases of block coordination?

Last Answer : There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete ... with the new master record. These operations are accomplished through the execution of triggers.

If two groups are not linked in the data model editor, What is the hierarchy between them?

Description : If two groups are not linked in the data model editor, What is the hierarchy between them?

Last Answer : Two group that is above are the left most rank higher than the group that is to right or below it.

What are the two types of views available in the object navigator(specific to report 2.5)?

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

Which of the two views should objects according to possession?

Description : Which of the two views should objects according to possession?

Last Answer : view by structure.

Describe two phases of Two-phase commit ?

Description : Describe two phases of Two-phase commit ?

Last Answer : Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If ... , if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

What is Two-Phase Commit ?

Description : What is Two-Phase Commit ?

Last Answer : Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

Name two utilities that Oracle provides, which are use for backup and recovery.

Description : Name two utilities that Oracle provides, which are use for backup and recovery.

Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.

What is Oracle Block? Can two Oracle Blocks have the same address?

Description : What is Oracle Block? Can two Oracle Blocks have the same address?

Last Answer : Oracle formats the database files into a number of Oracle blocks when they are first created-making it easier for the RDBMS software to manage the files and easier to read data into the memory areas ... at 1. Two blocks can have the same block address if they are in different database files.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

Say two examples of DML, two of DCL and two of DDL

Description : Say two examples of DML, two of DCL and two of DDL

Last Answer : Say two examples of DML, two of DCL and two of DDL

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).