try it...

create or replace view employees as
select * from star.employees ;


select * from employees ;

Try it....
[code=oracle]
select DISTINCT a.out_tar||'~'| | a.out_csi_id||' ~'||a.out_cust_ name||'~'||a.ou t_id| |'~'||b.out_id| |'~'||a.out_cat egory||'~'||
b.out_category| |'~'||
to_char(a.out_s tart_date, 'fm dd-mon-yyyy hh24:mi') ||'~'||
to_char(a.out_e nd_date, 'fm dd-mon-yyyy hh24:mi') ||'~'||
to_char(b.out_s tart_date, 'fmdd-mon-yyyy hh24:mi') ||'~'||
to_char(b.out_e nd_date, 'fmdd-mon-yyyy hh24:mi')||'~'| |c.ots_inst_lab el...

dear friends,

If i insert a row into table SALES ...If created_dt , Jan or Feb or Mar ...it will store separate partition...I tried the below script ..it's was not working.,

Script :

CREATE TABLE sales
( prod_id NUMBER(6),
create_dt DATE
)
PARTITION BY LIST (to_char(create _dt,'MON'))
(PARTITION SALES_JAN VALUES ('JAN'),
PARTITION SALES_FEB...

PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional has an excellent PL/SQL example of the PL/SQL continue clause in-action:
begin
for i in 1..3
loop
dbms_output.put _line('i='||to_ char(i));
if (...