OraFAQ Forum: Reports & Discoverer » Limit workbook to retrieve X rows

Home » Developer & Programmer » Reports & Discoverer » Limit workbook to retrieve X rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Limit workbook to retrieve X rows [message #678574]

Mon, 16 December 2019 08:39

pschiume
Messages: 2
Registered: December 2019

Junior Member

I'm looking for a LIMIT sql-like to retrieve a portion of the data I'll be working with.

I've access to 30+ dbs, with plenty of tables, not well documented. I'd like to do some data recognition, exploring portions of the data, with excel/qlikview or other more dynamic alternatives.

I tried to change the row limit and max query time but the load was CANCELLED and no data was retrieved.

Do you know if there is anyway to explore dbs like this? Any ideas?

Thank you!

Report message to a moderator

Re: Limit workbook to retrieve X rows [message #678582 is a reply to message #678574]

Tue, 17 December 2019 01:44

John Watson
Messages: 8344
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Do you mean something like this:

orclz> select * from emp order by ename fetch first 4 rows only;

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7876 ADAMS      CLERK           7788 1987-05-23:00:00:00       1100                    20
      7499 ALLEN      SALESMAN        7698 1981-02-20:00:00:00       1600        300         30
      7698 BLAKE      MANAGER         7839 1981-05-01:00:00:00       2850                    30
      7782 CLARK      MANAGER         7839 1981-06-09:00:00:00       2450                    10

orclz>

Report message to a moderator

Re: Limit workbook to retrieve X rows [message #678591 is a reply to message #678582]

Tue, 17 December 2019 06:17

pschiume
Messages: 2
Registered: December 2019

Junior Member

Hey John, that would work, but I have only access to the discoverer interface and I can't find where can I query with a sql statament.

Report message to a moderator

Re: Limit workbook to retrieve X rows [message #678594 is a reply to message #678591]

Tue, 17 December 2019 07:27

John Watson
Messages: 8344
Registered: January 2010
Location: Global Village

Senior Member

Is the web viewer all you have? You would need the desktop client to write your own queries, see here,
http://www.orafaq.com/wiki/Discoverer_FAQ

Report message to a moderator

Previous Topic:	running report issue
Next Topic:	Select date wise record (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 19 20:59:05 CDT 2020