OraFAQ Forum: SQL & PL/SQL » order member function

Home » SQL & PL/SQL » SQL & PL/SQL » order member function

Wed, 03 December 2003 10:29

maryum
Messages: 4
Registered: December 2003

Junior Member

i have written an order member function called sort_staff

how do i test the function.

thanks

Thu, 04 December 2003 01:33

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Make a table of the object type and try an ORDER BY query against it.

Thu, 04 December 2003 02:19

maryum
Messages: 4
Registered: December 2003

Junior Member

hi
thanks for replying
this is what im trying but it dosen't work

select value(s)
from staff s
order by s.sortstaff;

thanks

Previous Topic:	Where does the IOT and partitioned table go?
Next Topic:	Urgent: Inserting Rows form a Table on Other Database

Goto Forum:

]

Current Time: Fri Apr 19 18:10:38 CDT 2024