Powerbuilder Object Naming Standards

Listed below, only that i seldom used in my PB application for my quick reference :-
What about the rest?...hmmm...here's a link for more detail,
He's one of my favourite 'Guru'.

OBJECT	PREFIX
ArrayBounds	ab_
CheckBox	cbx_
CommandButton	cb_
Datastore	ds_
Datawindow	dw_
DatawindowChild	dwc_
DragObject	drg_
DropDownListBox	ddlb_
DropDownPictureListBox	ddplb_
dwObject	dwo_
EditMask	em_
Function	f_
Graph	gr_
GroupBox	gb_
HScrollBar	hsb_
Line	li_
ListBox	lb_
ListView	lv_
ListViewItem	lvi_
MailFileDescription	mfd
MailMessage	mm_
MailRecipient	mr_
MailSession	ms_
MDIFrame	mdi_
Menu	m_
MultiLineEdit	mle_
NonVisualObject	nvo_
OLEObject	oo_
Oval	ov
Picture	p_
PictureButton	pb_
PictureListBox	plb_
Pipeline	pl_
RadioButton	rb_
Rectangle	rec_
RichTextEdit	rte_
RoundRectange	rr_
SingleLineEdit	sle_
StaticText	st_
Structure	str_
Tab	tab_
TabPage	tabpage_
Transaction	tr_
Treeview	tv_
TreeviewItem	tvi_
UserObject	uo_
VerticalScrollBar	vsb_
Window	w_
WindowObject	wo_

Powerbuilder Variable Naming Standards - Datatypes

Variable Declaration prefix Standard :-

argument a
Global g
Instance i
Local l
Shared s

DataType prefix :-

VARIABLE TYPE	PREFIX	GLOBAL	INSTANCE	LOCAL
Any	a	ga_varname	ia_varname	la_varname
Blob	blb	gblb_varname	iblb_varname	lblb_varname
Boolean	b	gb_varname	ib_varname	lb_varname
Character	c	gc_varname	ic_varname	lc_varname
Date	d	gd_varname	id_varname	ld_varname
DateTime	dt	gdt_varname	idt_varname	ldt_varname
Decimal	dec	gdec_varname	idec_varname	ldec_varname
Double	db	gdb_varname	idb_varname	ldb_varname
Integer	i	gi_varname	ii_varname	li_varname
Long	l	gl_varname	il_varname	ll_varname
Real	r	gr_varname	ir_varname	lr_varname
String	s	gs_varname	is_varname	ls_varname
Time	tm	gtm_varname	itm_varname	ltm_varname
Unsigned Integer	ui	gui_varname	iui_varname	lui_varname
Unsigned Long	ul	gul_varname	iul_varname	lul_varname

Oracle SQL Multiple Rows Return One Row

//Data table DRIVERHP :-

STAFNO | CONTACTNO
---------------------------------
STAF1 11122
STAF1 44455
STAF2 33344
STAF3 66677
STAF3 88888
STAF3 99988

//works on 10g
//the Select Statement 1 :-

SELECT F.STAFNO, RTRIM(XMLAGG(XMLELEMENT(J, F.CONTACTNO,', ')).EXTRACT('//text()'),', ') AS CONTACTNOS
FROM DRIVERHP F
GROUP BY F.STAFNO

//select statement 2 :-
SELECT F.STAFNO, WM_CONCAT(F.CONTACTNO) AS CONTACTNOS
FROM  DRIVERHP F
GROUP BY F.STAFNO

//SQL output :-

STAFNO | CONTACTNOS
---------------------------------------------------------------------
STAF1 11122, 44455
STAF2 33344
STAF3 66677, 88888, 99988