Created
April 10, 2013 19:42
-
-
Save xtender/5357801 to your computer and use it in GitHub Desktop.
print_table on oracle 10.2.0.5
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ====================================================================== | |
| ======= Connected to XTENDER@ORCL(orcl)(sol10) | |
| ======= SID 145 | |
| ======= SERIAL# 22 | |
| ======= SPID 3215 | |
| ====================================================================== | |
| SQL> @print_table "select * from dual" | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 1 DUMMY X | |
| Elapsed: 00:00:14.49 | |
| SQL> @print_table "select * from v$version" | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 1 BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi | |
| Press Enter to view next row... | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 2 BANNER PL/SQL Release 10.2.0.5.0 - Production | |
| Press Enter to view next row... | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 3 BANNER CORE 10.2.0.5.0 Production | |
| Press Enter to view next row... | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 4 BANNER TNS for Solaris: Version 10.2.0.5.0 - Production | |
| Press Enter to view next row... | |
| ROW_NUM COL_NAME COL_VALUE | |
| ---------- ------------------------------ --------------------------------------------------------------------- | |
| 5 BANNER NLSRTL Version 10.2.0.5.0 - Production |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment