إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Urgent Dynamic Order Problem


لا توجد ردود على هذا الموضوع

#1 yousfecs

yousfecs

    عضو

  • الأعضــاء
  • 10 مشاركة

تاريخ المشاركة 08 July 2009 - 11:04 AM

I need to do dynamic sorting when I retrive data from table without using ORDER BY

I have this procedure.
CREATE OR REPLACE PROCEDURE Test(RC1 OUT SYS_REFCURSOR)
AS BEGIN execute immediate 'ALTER SESSION SET NLS_COMP=ANSI';
EXECUTE IMMEDIATE'alter session set nls_sort=GENERIC_BASELETTER' ;
OPEN RC1 FOR
SELECT * FROM COMMITMENTTREE ;

END;
/

when I display this cursor the data not sorted.

NOTE:- when I put at the SELECT clause one column (which contain constraint of NOT NULL) was sorted but with other columns retreived but not sorted!!!!

plz I need help to solve problem