Re: How to insert a space after each Manager Starts.

CREATE TABLE t (id number, name VARCHAR2(100); /
-- create some test data

BEGIN
FOR i IN 1 .. 5 LOOP
  FOR ii IN 1 .. 10 LOOP
    INSERT INTO T VALUES (i,'Name '||ii);   END LOOP;
END LOOP;
END;

• and your query is (in Oracle 8i and up only):

SELECT DECODE(name_group,0,ID,NULL) ID,NAME  FROM ( SELECT ID, NAME,GROUPING(ID) id_group, GROUPING(NAME) name_group  FROM t
 GROUP BY ROLLUP (ID,NAME))
   WHERE id_group=0;

Jan Received on Tue Jul 01 2003 - 06:30:54 CDT