Oracle Developer

[ramu]

[quote name='tommy' timestamp='1374720058' post='1304007206']
yaa source tables NTLRESULTS ANE SCHEMA LO UNAYI
TABLE LEDU NENU KOTHA TABLE CREATE CHESA AND DANIKI PROCEDURE RAYALI...
[/quote]


To load new table with source tables u need a proc.. thats wht i understood from this...

To do that we need table structure n relations... we can create a select query and load new table

create or replace procedure proc_name (parameter1 <datatype>,...parametern<datatype>)
as
begin

insert in your_table as select query;

exception

end;

ila cheyyali

[tommy]

[quote name='RockStarZ' timestamp='1374720506' post='1304007218']


To load new table with source tables u need a proc.. thats wht i understood from this...

To do that we need table structure n relations... we can create a select query and load new table

create or replace procedure proc_name (parameter1 <datatype>,...parametern<datatype>)
as
begin

insert in your_table as select query;

exception

end;

ila cheyyali
[/quote]
masth simple ga chepav bhayya..but naaku basic ga procedure rayaniki raadu....

[tommy]

naa degara file undhi ela pampali...

[tommy]

[font=arial, sans-serif][size=3][background=rgb(241, 241, 241)][img]https://mail.google.com/mail/u/0/images/cleardot.gif[/img][/background][/size][/font]

[tommy]

[Ka NTR i]

still need help... ?

PM me the details like all source table anme and join conditions and target table and schema name.


basicga ithe idhe,...

create or replace procedure PROCEDURE_NAME(Parmeter 1,parameter 2) -- parameters depends on your criteria how/when you want to call this proc
as
-- Varibale Declaration section
Begin
Insert into NTLSCHEMA.TARGET_TABLE (col1, col2,col3...col40)
select t.col1,
t2.col2,
t3.col3,
t4.col4
.....

t4.col40
from sorce_tab1 t1,
JOIN src_tab2 t2
ON t1.join_cond=t2.join_cond
.
.
.
where clause;
Exception section
-- optional if you want to handle any kind of exceptions like DUP_VAL_ON_INDEX,NO_DATA_FOUND etc..
END;

[Ka NTR i]

pina bhayya basic cheppadu gaa chooda ledhu