Amazon books

Friday, May 6, 2011

Display number values in words

--Create emp table
create table emp
(emp_name varchar2(30),
sal number);

--Insert some data
insert into emp values ('Nome1',1300);
insert into emp values ('Nome2',1400);
insert into emp values ('Nome3',2300);
insert into emp values ('Nome4',5300);
insert into emp values ('Nome5',11300);
commit;

--Query and get number into words
col sal for 99999
col "Extenso" for a70
select sal, (to_char(to_date(sal,'j'), 'jsp')) "Extenso" from emp;

set linesize 140
col parameter for a30
select * from v$nls_valid_values where value like '%BRA%';
alter session set NLS_LANGUAGE='BRAZILIAN PORTUGUESE';
alter session set NLS_TERRITORY='BRAZIL';
export LANG=pt_BR

Regards,
Paulo Portugal

Exadata CellCLI command sintaxe:

--Create command:
–CREATE CELLDISK ALL
–CREATE GRIDDISK ALL PREFIX=‘’, SIZE=
--Drop command:
-DROP [CELLDISK | GRIDDISK] ALL

--Alter command:
-ALTER CELL [STARTUP | SHUTDOWN | RESTART ] SERVICES [ALL | MS | RS | CELLSRV]

--List command:
–LIST [ LUN | CELLDISK | GRIDDISK ] [] [DETAIL]


Regards,
Paulo Portugal

Tuesday, May 3, 2011

Exadata DCLI utility Examples

Below some dcli command examples:

--Check date of all your cells
$dcli -g mycells date

--List cell status
$dcli -c xxxxcell01,xxxxcell02,xxxxcell03,xxxxcell04 cellcli -e list cell

--Running a CellCLI script on many cells
$dcli -g mycells -x listphisicaldiskcommand.scl

--Running a script on all db servers logged in as oracle

$dcli -g mydbservers -l oracle -x dbwork.sh

Best Regards,
Paulo Portugal