How to get all user name in forms 6i [message #537830] |
Sun, 01 January 2012 10:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
Re: How to get all user name in forms 6i [message #537837 is a reply to message #537830] |
Sun, 01 January 2012 11:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
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.
|
|
|