GROUP BY does not necessarily guarantee a sort.
eg. you still need an ORDER BY
On Fri, 2003-08-29 at 07:59, Mercadante, Thomas F wrote:
> Mike,
>
> Add a GROUP BY command:
>
> select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
> from EMP
> group by (rpad(employee_id,6,' ')) ||';'|| ssn
>
>
2003 06:44:40
>
>I have problem to use "distinct" with Function on
>select statement. Can anyone give me a hint?
>
>Thanks.
>
>SQL> select distinct (rpad(employee_id,6,' '))
>||';'||
>ssn from EMP
> 2 order by employee_id;
>select distinct (rpad(employee_id,6,' ')) ||';'||
>ssn
>from EMP
>
Title: RE: [Q] SQLPLUS help on "distinct"
Mike,
Try one of these:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
order by (rpad(employee_id,6,' ')) ||';'|| ssn;
or
select distinct employee_id, (rpad(em
Mike,
Add a GROUP BY command:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
group by (rpad(employee_id,6,' ')) ||';'|| ssn
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, August 29, 2003 10:45 AM
To: Multiple recipients o
Select distinct employee
>From (select rpad(employee_id,6,' ')) ||';'||ssn as employee
from EMP
order by employee_id)
Jack
-Original Message-
Sent: Friday, August 29, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
I have problem to use "distinct" with Function
Title: RE: [Q] SQLPLUS help on "distinct"
order by (rpad(employee_id,6,' '))
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOT
I have problem to use "distinct" with Function on
select statement. Can anyone give me a hint?
Thanks.
SQL> select distinct (rpad(employee_id,6,' ')) ||';'||
ssn from EMP
2 order by employee_id;
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
*
ERROR at l
You will have to write an anonymous block that declares the array
variable, and passes that array to your procedure under test.
--- "Basavaraja, Ravindra" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I want to test a procedure that accepts an array as input.I want to
> test
> this script from
> SQL*
Hi All,
I want to test a procedure that accepts an array as input.I want to test
this script from
SQL*PLUS.How can I pass array value from sql*plus
Procedure testproc(iarrPID IN PID_VArray).
I want to test it this way
SQL>Exec testproc(?)
Tried this was
SQL>EXEC testproc(33)
Title: RE: Passing array as input to procedure from sqlplus-HELP
exec testproc(pid_varray(1,2,3,4,5));
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal
Hi All,
I want to test a procedure that accepts an array as input.I want to test
this script from
SQL*PLUS.How can I pass array value from sql*plus
Procedure testproc(iarrPID IN PID_VArray).
I want to test it this way
SQL>Exec testproc(?)
Tried this was
SQL>EXEC testproc(33)
Please note that the HELP topics on 8.1.6 are a lot less than the ones on
8.0.6. And yes, 8.1.6 doesn't have INSERT topic in the HELP table.
You can load the ones missing on 8.1.6 using the scripts from 8.0.6. At least
that's what I did.
HTH.
Gunawan Yuwono
Oracle DBA
Kansas City, USA
--- Yusti
That is because you did not create SQL*Plus help tables/views (there is an
option when you create the database).
To enable it;
- Locate files named helpbld.sql (SQL*Plus help tables/views creation) and
helpus.sql (SQL*Plus help tables/views data).
- Login through SQL*Plus as SYSTEM
- run helpbld.s
Title: RE: SQLPLUS HELP
Hello all,
I want one help from you. We are working on Oracle 8.1.6 on Sun solaris 2.6 version.
We are not able to invoke help from sqlplus. eg..
sql> help insert I want help syntax and desc of insert.
It would be great if somebody suggest how to invoke h
Hello,
I executed the sql script & the sqlloader commands to create, load and
index the table SYSTEM.HELP.
When I launch the command HELP <...> in sqlplus environment installed in
the Server (HP-UX), it works fine.
>From an NT client, when I launch the command HELP <...>, I have the
following mess
15 matches
Mail list logo
