OraFAQ Forum: Forms » How to get all user name in forms 6i

Home » Developer & Programmer » Forms » How to get all user name in forms 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get all user name in forms 6i [message #537830]

Sun, 01 January 2012 10:33

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How to get all user name in forms 6i like when we connect database and apply following command

select * from all_users

This Command returns all users name i want that this user list appears in forms datablock

Regards

Report message to a moderator

Re: How to get all user name in forms 6i [message #537837 is a reply to message #537830]

Sun, 01 January 2012 11:57

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Base your data block on ALL_USERS. If it doesn't work correctly (after all, "you" don't own ALL_USERS, and I can't test it right now as I don't have Forms installation here), you could create your own view and base data block on it. For example:

SQL> create view my_all_users as select username from all_users;

View created.

SQL> select * from my_all_users;

USERNAME
------------------------------
MY_SYS
MIKE
SCOTT
APEX_030200
APEX_PUBLIC_USER
TWODAYPLUS
FLOWS_FILES
<snip>
HR
SYSTEM
SYS

21 rows selected.

SQL>

You'd then base a block on MY_ALL_USERS view.

Report message to a moderator

Previous Topic:	Multiple items selection in a list item
Next Topic:	Trigger For Next Record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 07:24:15 CDT 2024