[B! oracle] wanijiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

waniji id:waniji

oracleã«é–¢ã™ã‚‹wanijiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

DB è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š[æœ€æ–°ç‰ˆ] - Qiita
ã“ã‚“ã«ã¡ã¯ã€ã™ã£ã‹ã‚Šç§‹ã§ã™ãï¼@yone098 ã§ã™ã€‚ ã¿ãªã•ã‚“DBã®è¨è¨ˆã—ã¦ã¾ã™ã‹ï¼Ÿ DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š ä»¥å‰ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ã§æ›¸ã„ãŸè¨˜äº‹ã¯5å¹´å‰ã®ã‚‚ã®ã§ã‚ã‚Šã€ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ã‚‹ã‚‚ã®ãŒã‚ã‚‹ã®ã§æœ€æ–°ç‰ˆã¨ã—ã¦ MySQL, PostgreSQL, Oracle, SQLServer ã«ãŠã‘ã‚‹DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Šã‚’ã¾ã¨ã‚ç›´ã—ã¾ã—ãŸã€‚ MySQL URLå†…ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³è¡¨è¨˜ã‚’å¤‰ãˆã‚‹ã¨ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æƒ…å ±ã«ãªã‚Šã¾ã™ã€‚ MySQLã¯ã€ã‚ã¾ã‚Šæƒ…å ±ã«å¤‰åŒ–ã¯ç„¡ã‹ã£ãŸã®ã§ Excel ã§ãƒžã‚¯ãƒãªã©ã‚’ä½œæˆã—ã¦è‡ªç¤¾ã§è‡ªå‹•ç®—å‡ºå‡ºæ¥ã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¦æ±‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒæ±ºã¾ã£ã¦ã„ã‚‹ã®ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚µã‚¤ã‚ºãŒæ±ºã¾ã‚Šã€ã‚ã¨ã¯è¦ä»¶æ¬¡ç¬¬ã§ä½•ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãªã‚‹ã‹ã‚’äºˆæ¸¬ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¨˜æ†¶å®¹é‡ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æœ€å¤§ã‚µã‚¤ã‚ºé–¢é€£ http://dev.mysql.com/doc/re
waniji 2014/11/12
è¨è¨ˆ

database

mysql

oracle

PostgreSQL
ãƒªãƒ³ã‚¯
SET DEFINE - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL*Plus ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
DEFINE ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° DEFINE ã¯ç½®æ›å¤‰æ•°ã®ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ï¼ˆæŽ¥é èªžï¼‰ã‚’è¨å®šã™ã‚‹ã€‚ çŸç¸®å½¢ã¯ DEF ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ ON ã§ã‚¢ãƒ³ãƒ‘ã‚µãƒ³ãƒ‰(&) SET ã®ä»˜ã‹ãªã„ DEFINE ã‚³ãƒžãƒ³ãƒ‰ ã¯å¤‰æ•°ã‚’å®šç¾©ã™ã‚‹ãŸã‚ã® SQL*Plus ã‚³ãƒžãƒ³ãƒ‰ SET DEFINE ã‚³ãƒžãƒ³ãƒ‰ SET DEFINE ã‚³ãƒžãƒ³ãƒ‰ã®æ§‹æ–‡ SET DEFINE æŽ¥é æ–‡å— SET DEFINE ON SET DEFINE OFF ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ SET DEFINE '&' æŽ¥é èªžã¯å˜ä¸€ã®æ–‡å—ã§è‹±æ•°å—ã€ç©ºç™½ã¯ä½¿ç”¨ã§ããªã„ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ & ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã€‚ ON ã¨ OFF : OFF ã«ã—ãŸå ´åˆã«ã¯ç½®æ›å¤‰æ•°ã¨ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ç½®æ›å¤‰æ•°ã®å‡¦ç†ãŒè¡Œãªã‚ã‚Œãªã„ã€‚ ON ã«ã—ãŸå ´åˆã«ã¯ã‚¢ãƒ³ãƒ‘ã‚µãƒ³ãƒ‰(&ï¼šã‚¢ãƒ³ãƒ‰ãƒžãƒ¼ã‚¯) ãŒæŽ¥é è¾žã¨ã—ã¦è¨å®šã•ã‚Œã‚‹ã€‚ SET DEFINE ON ã¯ SET DEFINE & ã¨åŒã˜æ„å‘³ã«ãªã‚‹ã€‚ ç½®æ›å¤‰æ•°
waniji 2013/06/17
oracle

sqlplus
ãƒªãƒ³ã‚¯
SQL*Plus ã§æ–‡å—åˆ—ã ã‘ã«ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã‚’ã¤ã‘ã¦ csv å½¢å¼ã§å‡ºåŠ›ã™ã‚‹ SQL - ablog
OTN Japan - Code Tips ã« make_csv.sql ã¦ã®ãŒã“ã‚ãŒã£ã¦ãŸã€‚ã“ã‚Šã‚ƒä¾¿åˆ©ã˜ã‚ƒã€‚ ä»¥ä¸‹ã€http://otn.oracle.co.jp/otn_pl/otn_tool/code_detail?n_code_id=764 ã‹ã‚‰ã®æŠœç²‹ã€‚ set pagesize 0 set linesize 32767 set linesize &MAX_LINE_SIZE set trimspool on set feedback off set verify off ACCEPT DT_FMT CHAR PROMPT 'DATETIME FORMAT:' ALTER SESSION SET NLS_DATE_FORMAT = '&DT_FMT'; ACCEPT TABLE CHAR PROMPT 'TABLE NAME:' ACCEPT FILE CHAR PROMPT 'O
waniji 2012/12/19
oracle
ãƒªãƒ³ã‚¯
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL*Plus ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¨ã¯ SQL*Plus ã®å®Ÿè¡Œæ™‚ã®å¼•æ•°ã ã‘ã§ã¯è¨å®šã—ãã‚Œãªã„ã‚‚ã®ã‚„å‹•çš„ã«è¨å®šã‚’å¤‰æ›´ã™ã‚‹ãŸã‚ã«ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’éšæ™‚å¤‰æ›´å¯èƒ½ãªå¤‰æ•°ã€ã«ã—ãŸã‚ˆã†ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®è¨å®šã¯ SQL*Plus ã‚³ãƒžãƒ³ãƒ‰ã® SET ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° å€¤ ã¨ã„ã†å½¢å¼ã§è¡Œãªã„ã€‚ ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã®ç¾åœ¨ã®å€¤ã‚’å‚ç…§ã—ãŸã„å ´åˆã«ã¯ SHOW ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•° ã‚’å®Ÿè¡Œã™ã‚‹ã¨ç¢ºèªã§ãã‚‹ã€‚ SQL*Plus ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ä¸€è¦§
waniji 2012/12/19
oracle

sqlplus
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆSQLPLUSï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ ä¾‹ï¼‘ï¼‰ã€€è¡¨ã€Œempã€ã®SELECTçµæžœã‚’ã€ã‚«ãƒ³ãƒž','åŒºåˆ‡ã‚Šã®CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã€Œc\tmp\emp.csvã€ã«å‡ºåŠ›ã—ã¾ã™ã€‚ SQL> set echo off SQL> set linesize 1000 SQL> set pagesize 0 SQL> set trimspool on SQL> set feedback off SQL> set colsep ',' SQL> spool c:\temp\emp.csv SQL> select * from emp; E01,D01,åå—ï¼‘ã€€ã€€,åå‰ï¼‘ã€€ã€€, 10 E02,D01,åå—ï¼’ã€€ã€€,åå‰ï¼’ã€€ã€€, 50 E03,D02,åå—ï¼“ã€€ã€€,åå‰ï¼“ã€€ã€€, 100 SQL> spool off
waniji 2012/12/19
oracle
ãƒªãƒ³ã‚¯
1