Pl/sql Topulu Konchem Randi Babu... Oo Sahayam Kavali

[Kakateyudu]

[quote name='cherlapalli_jailer' timestamp='1356035346' post='1302989688']
[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select count(*) into kaka from afdb where[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] status = 'n' group by key1,status having count(*) > 0 [/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]try this[/background][/size][/font][/color]
[/quote]

tannestundhi baa trigger.... trigger lo error ravatledu but ye table meda ithe listen avtundho aa table lo data insert chestunte ee trigger ki point chesi error chestundhi

[dreamgirl]

, NIL knowledge in IT. Hope someone helps u

[cherlapalli_jailer]

[quote name='Kakateeyudu©' timestamp='1356036365' post='1302989846']

tannestundhi baa trigger.... trigger lo error ravatledu but ye table meda ithe listen avtundho aa table lo data insert chestunte ee trigger ki point chesi error chestundhi
[/quote]
this will return multiple rows

First Editor lo try cheyyi if it work the trigger lo cheyyi

Trigger lo debug kastam kada

[deals2buy]

[quote name='Jeedeelu' timestamp='1356030512' post='1302988669']
Agreed [b][color=#ff0000]calling champak das..[/color][/b]
[/quote]
idem twist kothaga? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[Kakateyudu]

[quote name='dreamgirl' timestamp='1356036417' post='1302989853']
, NIL knowledge in IT. Hope someone helps u
[/quote]

[Kakateyudu]

[quote name='cherlapalli_jailer' timestamp='1356036478' post='1302989864']
this will return multiple rows

First Editor lo try cheyyi if it work the trigger lo cheyyi

Trigger lo debug kastam kada
[/quote]
yeahh will try and let u know baa

[Mrlavangam]

Koncham clarity miss ayyindi baa..
select count(*) into kakateyudu from afdb_table where :OLD.field1= :NEW.field1 and status = 'K';

jailer cheppinattu data ila vundi anukunnam

KEY1 Status
1 N
1 N
2 N
2 N
1 X
2 X

ipudu neeku kaakateeyudu ane variable ki value em kavali???

[Kakateyudu]

[quote name='Mrlavangam' timestamp='1356038295' post='1302990165']
Koncham clarity miss ayyindi baa..
select count(*) into kakateyudu from afdb_table where :OLD.field1= :NEW.field1 and status = 'K';

jailer cheppinattu data ila vundi anukunnam

KEY1 Status
1 N
1 N
2 N
2 N
1 X
2 X

ipudu neeku kaakateeyudu ane variable ki value em kavali???
[/quote]

Key1 lo same value and status 'n' yenni rows vunnai oo kavali.... if that count = 0 then status 'n' tho insert cheyyali or status = 'x' tho

[Mrlavangam]

[quote name='Kakateeyudu©' timestamp='1356038719' post='1302990252']

Key1 lo same value and status 'n' yenni rows vunnai oo kavali.... if that count = 0 then status 'n' tho insert cheyyali or status = 'x' tho
[/quote]



neeku count tho paniledu anukuntunna mama

kateeyudu variable ki intial ga zero value assign chey

select 1 into kakateyudu from afdb_table where :OLD.field1= :NEW.field1 and status = 'N';

if kakateeyudu =1
v_status:='X'
else
v_status:='N'

INSERT INTO New_tbl
(X,X,X,X )
VALUES
( :new.X,
:new.X,
:new.X,
:new.X,
v_status );

idi try chey mama okasaari...naku arthamaina thaani batti chepthunna

[Kakateyudu]

[quote name='Mrlavangam' timestamp='1356040132' post='1302990461']



neeku count tho paniledu anukuntunna mama

kateeyudu variable ki intial ga zero value assign chey

select 1 into kakateyudu from afdb_table where :OLD.field1= :NEW.field1 and status = 'N';

if kakateeyudu =1
v_status:='X'
else
v_status:='N'

INSERT INTO New_tbl
(X,X,X,X )
VALUES
( :new.X,
:new.X,
:new.X,
:new.X,
v_status );

idi try chey mama okasaari...naku arthamaina thaani batti chepthunna
[/quote]

select 1 into kakateyudu ante enti baa ?

[Kakateyudu]

[quote name='Kakateeyudu©' timestamp='1356040435' post='1302990481']

select 1 into kakateyudu ante enti baa ?
[/quote]

table meda update chestunte tannestundhi baa update

[Mrlavangam]

[quote name='Kakateeyudu©' timestamp='1356040435' post='1302990481']

select 1 into kakateyudu ante enti baa ?
[/quote]
1 ni load chesthudi....aa where condition true aithe otherwise intial ga zero declare chestav kada ade vunchutudi....

leda ila pettu


select CASE when :OLD.field1= :NEW.field1 and status = 'N'
THEN 1 else 0 END into kakateyudu from afdb_table

[Kakateyudu]

[quote name='Mrlavangam' timestamp='1356042026' post='1302990702']

1 ni load chesthudi....aa where condition true aithe otherwise intial ga zero declare chestav kada ade vunchutudi....

leda ila pettu


select CASE when :OLD.field1= :NEW.field1 and status = 'N'
THEN 1 else 0 END into kakateyudu from afdb_table
[/quote]

On the way back home baa intlo try chesta.. Will update u

[Mrlavangam]

[quote name='Kakateeyudu©' timestamp='1356042431' post='1302990748']
On the way back home baa intlo try chesta.. Will update u
[/quote]
ok

[mrudhula99]

naku konni question unnai.. plsql script run chesthunte.. errors vasthunnai...

evarikaina thelisthee..cheppandi

error entantee


Encountered the symbol "SET" when expecting one of the following:
:= . ( @ % ;
The symbol ":= was inserted before "SET" to continue.