Q
Problem solve Get help with specific problems with your technologies, process and projects.

Test to check query in Toad

I want to test to make sure that a query is working in Toad. I would like to pull the top 10 rows, but select top 10, column, column, etc. doesn't seem to run.

I want to test to make sure that a query is working in Toad. I would like to pull the top 10 rows, but select top 10, column, column, etc. doesn't seem to run.
Below is an example of a Top-10 SQL: 
select empno, ename, sal
         from 
           (select empno, ename, sal
              from emp 
              order by sal desc)
         where rownum <=10;
This was last published in October 2006

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

Join the conversation

1 comment

Send me notifications when other members comment.

Register

Please create a username to comment.

Hi,

When I do a DESC on Toad on the following table:

temp_1
name varchar2(20),
zip number(5)

TOAD returns the following withe the DESC

name varchar2(80)
zip number(5)

all of the varchar2 values in the desc are multiplied by a factor or 4, the number datatypes stay the same.

in SQL Developer, for the same table, same schema, the varchar2 amounts are correctly illustrated in the DESC command.

I have never seen this before. 
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close