Code: Detail

Plsql - (Portuguese)

Alter session set NLS_DATA_FORMAT

Uso do Alter session set NLS_DATA_FORMAT

Last update: 17/12/2013
Plsql  Oracle     
 
N/A
N/A
N/A
N/A
 

select * from nls_session_parameters

Alter session set NLS_DATA_FORMAT = Formato

onde Formato pode assumir os seguintes valores:

YY - ano com 02 digitos
YYYY - ano com 04 digitos
MM - o numero do mes
MONTH - nome completo do mes
MON - nome abreviado do mes
DDD - o dia do ano
DD - o dia do mes
D - o dia da semana
DAY - o nome do dia
HH - a hora do dia, no formato de 12 horas
HH24 - a hora do dia, no formato de 24 horas
MI - minutos
SS - segundos

exemplo: ALTER SESSION SET NLS_DATE_FORMAT = 'DD_MON_YYYY'

a partir desse ponto todos os comando (SELECT, INSERT, UPDATE e DELETE) precisarão obedecer o formato da data do comando anterior.





Source:
 
Users who have marked this routine as a favorite
 
 
 
The site ti4fun is not responsible for the content on sites for which you have external links

Articles, routines, tips, forums, blogs or any other content posted on ti4fun site is not tested and not validated, so you should test and validate any information collected on the ti4fun site before applying it to final use environment, such as example, production. the TI4FUN site is not responsible for quality or for any damages, direct, indirect or consequential, from use of any content posted by the authors in the site.

All content published on the ti4fun site is the responsibility of the author and do not necessarily express the views of the site ti4fun and its employees.