473,486 Members | 2,424 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Distinct function in TOAD

1 New Member
select distinct (npa+nnx)

Can anybody tell me what the missing expression from the above statement? Or just provide any example of using distinct function in TOAD?

Thanks a lot!
Oct 23 '06 #1
1 5037
saravanankm
47 New Member
Hi

Select qry Minimum two Clause Needed
For Ex Select & From clause

select distinct (5+6) from dual;

Or

Select distinct (xxxx + yyyyy) from Table_name;

With Regards,
Captain
Oct 24 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1675
by: Colin Steadman | last post by:
This may be slightly off topic, but this is probably a better place to ask than an Oracle group as folk here are more likely to use the feature I'm asking about. In Toad (Quest Software) there...
1
6847
by: Joel Racicot | last post by:
Hi Everyone, I recently had to rebuild my test server and decided to install 9i. Done and works fine. Can connect to DB using SQL*Plus. Then installed TOAD on same box and can't connect to DB...
2
9630
by: Salvador Valencia | last post by:
Hi, I'm getting the message "NO CREATE statement found to execute" in the procedure edit window of TOAD (v7.3.0.0). The code COMPILED last night and now this morning I get this message. There...
0
3576
by: BobG | last post by:
-- The issue This following query works fine on Toad and PowerBuilder yet when it is run on SQLPlus I get: "ORA-03113: end-of-file on communication channel" When I remove the distinct from the...
2
2462
by: luku | last post by:
Hello J have a problem with connecting to database using toad for ss on windows XP. the error is: class unregistered Please help thanks
1
5592
by: camurtha | last post by:
I have the following code: SELECT DISTINCT ON (REQUEST_ID) BATCH_ID, REQUEST_ID FROM VOLUNTEER_REQUEST I am recieving the error 'ORA-00936: missing expression' what am I doing wrong? ...
1
19744
by: smita81 | last post by:
Hi, I have a problem while trying to login to toad. My operating system is WINDOWS XP. I have Oracle 9i at my system. I installed the Toad into the system.When I start the Toad "Toad Server...
0
1711
by: sherifffruitfly | last post by:
Hi all, After finishing a script in Toad for MSSQL, I saved and closed the file in Toad. I then kicked off our staging process which moves the file from the save location to somewhere else. The...
0
2599
by: vamsioracle | last post by:
Hi All, I have a function that return some static value, based on the grade of a person. It takes the person id as the input. This is my code create or replace function...
0
7100
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7126
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6842
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5434
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4865
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4559
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3070
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
262
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.