Home » Developer & Programmer » Reports & Discoverer » Limit workbook to retrieve X rows
Limit workbook to retrieve X rows [message #678574] Mon, 16 December 2019 08:39 Go to next message
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!
Re: Limit workbook to retrieve X rows [message #678582 is a reply to message #678574] Tue, 17 December 2019 01:44 Go to previous messageGo to next message
John Watson
Messages: 8274
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>
Re: Limit workbook to retrieve X rows [message #678591 is a reply to message #678582] Tue, 17 December 2019 06:17 Go to previous messageGo to next message
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.
Re: Limit workbook to retrieve X rows [message #678594 is a reply to message #678591] Tue, 17 December 2019 07:27 Go to previous message
John Watson
Messages: 8274
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
Previous Topic: running report issue
Next Topic: Select date wise record (merged)
Goto Forum:
  


Current Time: Thu Jun 04 07:13:28 CDT 2020