The Code-Bin
Links
Home
Add your code!
All Listings
About
Latest Entry
Featured Scripts
Author's Website
Latest Entries
FFMPEG Thumbnail Scr...
PHP, 0.8KB
Jul. 29, 10:24pm
John
Z80 Assembler, 190 bytes
Feb. 17, 3:36am
John
Z80 Assembler, 176 bytes
Sep. 13, 2:19am
John
Z80 Assembler, 77 bytes
Sep. 13, 2:18am
John
Z80 Assembler, 209 bytes
Sep. 13, 2:17am
ora2file
Posted by: sh | February 8, 2011 @ 3:10am
SQL Code
[
Download
]
set feedback off; set echo off; set verify off; set heading off; set trim on; set tab on; set colsep ' '; set trimspool on; set term off; spool bil_user.txt select ( cast(cd.id_str as varchar(20)) || ' ' || coalesce(cp.id_place, 0) || ' ' || coalesce(cp.id_connect, 0) || ' ' || coalesce(cd.ip_adr, ' ') || ' ' || coalesce(cd.owner, ' ') || ' ' || coalesce(cd.login_name, ' ') || ' ' || coalesce(cp.address, ' ') ) as record from BIL.CONNECT_DETAIL cd left join BIL.CONNECT_PLACES cp on (cp.id_place = cd.id_place) ; spool off; set term on; exit
Syntax Highlighting
[
Open in new window
]
Author Comments
none
Rating
4.43 / 8
69 Votes
http://codebin.yi.org/1097
page generated in 0.01 seconds