{"id":167,"date":"2013-03-11T12:36:11","date_gmt":"2013-03-11T11:36:11","guid":{"rendered":"http:\/\/sam-soul.fr\/Info\/?p=167"},"modified":"2013-03-11T12:36:11","modified_gmt":"2013-03-11T11:36:11","slug":"aide-spooler-sqplus-2","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2013\/03\/11\/aide-spooler-sqplus-2\/","title":{"rendered":"Aide spooler SQPlus"},"content":{"rendered":"

Param\u00e8tres pour le spool SQLplus.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
set tab off<\/td>\nPas de tabulation :<\/td>\n<\/tr>\n
set trims off <\/td>\npas d’espace \u00e0 la fin de la ligne<\/td>\n<\/tr>\n
set line 100<\/td>\nlongueur de ligne de 100<\/td>\n<\/tr>\n
set heading on<\/td>\naffiche les ent\u00eates de colonne<\/td>\n<\/tr>\n
set newpage 10<\/td>\ncr\u00e9\u00e9 une nouvelle page toutes les 10 lignes<\/td>\n<\/tr>\n
set pagesize 0<\/td>\n<\/td>\n<\/tr>\n
set feedback off<\/td>\ncompte le nombre d’enregistrement<\/td>\n<\/tr>\n
set colsep « ; »<\/td>\ns\u00e9parateur de colonne ;<\/td>\n<\/tr>\n
set termout off<\/td>\n<\/td>\n<\/tr>\n
set pause « tapez RETURN pour continuer « <\/td>\nattente d’une intervention clavier<\/td>\n<\/tr>\n
set sqlnumber off<\/td>\nsupprime les num\u00e9ros de ligne SQL<\/td>\n<\/tr>\n
set sqlprefix off<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SET TERM OFF \n-- TERM = ON will display on terminal screen (OFF = show in LOG only)<\/pre>\n
SET ECHO ON
\n— ECHO = ON will Display the command on screen (+ spool)
\n— ECHO = OFF will Display the command on screen but not in spool files.
\n— Interactive commands are always echoed to screen\/spool.<\/p>\n
SET TRIM<\/a>OUT ON
\n— TRIM<\/a>OUT = ON will remove trailing spaces from output<\/p>\n
SET TRIM<\/a>SPOOL ON
\n— TRIM<\/a>SPOOL = ON will remove trailing spaces from spooled output<\/p>\n
SET HEADING OFF
\n— HEADING = OFF will hide column headings<\/p>\n
SET FEEDBACK OFF
\n— FEEDBACK = ON will count rows returned<\/p>\n
SET PAUSE OFF
\n— PAUSE = ON .. press return at end of each page<\/p>\n
SET PAGESIZE 0
\n— PAGESIZE = height 54 is 11 inches (0 will supress all headings and page brks)<\/p>\n
SET LINESIZE 80
\n— LINESIZE = width of page (80 is typical)<\/p>\n
SET VERIFY OFF
\n— VERIFY = ON will show before and after substitution variables<\/p>\n
— Start spooling to a log file
\nSPOOL C:\\TEMP\\MY_LOG_FILE.LOG<\/p>\n
—
\n— The rest of the SQL commands go here
\n—
\nSELECT<\/a> * FROM GLOBAL_NAME;<\/p>\n
SPOOL OFF<\/p>\n","protected":false},"excerpt":{"rendered":"
Param\u00e8tres pour le spool SQLplus. set tab off Pas de tabulation : set trims off pas d’espace \u00e0 la fin de la ligne set line 100 longueur de ligne de 100 set heading on affiche les ent\u00eates de colonne set newpage 10 cr\u00e9\u00e9 une nouvelle page toutes les 10 lignes set pagesize 0 set feedback … Continuer la lecture de « Aide spooler SQPlus »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/167"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=167"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/167\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}