1
Download iSQL User`s Manual - ALTIBASE Customer Support
Transcript
2.7 Formatting SELECT Query Results --------------------------------1 Moon Chan-seung CEO 01195662365 3002 R 2 Davenport Susan designer 0113654540 721219 18-NOV-2009 H 2 rows selected. M 1500 F 2.7.5 SET PAGESIZE Specifies the number of resultant rows to display at one time. iSQL> SET PAGESIZE 2; -> Show results in groups comprising two rows each. iSQL> select eno, e_firstname, e_lastname from employees; ENO E_FIRSTNAME E_LASTNAME -----------------------------------------------------------1 Chan-seung Moon 2 Susan Davenport ENO E_FIRSTNAME E_LASTNAME -----------------------------------------------------------3 Ken Kobain 4 Aaron Foster ENO E_FIRSTNAME E_LASTNAME -----------------------------------------------------------5 Farhad Ghorbani 6 Ryu Momoi . . . 20 rows selected. iSQL> SET PAGESIZE 0; -> Show all of the results on one page. iSQL> select eno, e_firstname, e_lastname from employees; ENO E_FIRSTNAME E_LASTNAME -----------------------------------------------------------1 Chan-seung Moon 2 Susan Davenport 3 Ken Kobain 4 Aaron Foster 5 Farhad Ghorbani 6 Ryu Momoi . . . 20 rows selected. 2.7.6 SET HEADING Sets whether to output the header with a SELECT result. iSQL> SET HEADING OFF; -> Header is not displayed with the result. iSQL> select eno, e_firstname, e_lastname from employees; 1 2 3 4 5 6 iSQL User’s Manual Chan-seung Susan Ken Aaron Farhad Ryu Moon Davenport Kobain Foster Ghorbani Momoi 38
