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

[Kakateyudu]

Ee kinda statement asalu em chestundhi..........


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


na requirement vachesi... aa kakateyudu ane variable lo ki afdb_table lo field1 lo same value and status = k vunna count vellai

kasta seppandi vayya... aa paina statement ithe work avi savatledu... adhi trigger lo condition

[cherlapalli_jailer]

looks Ok

First try this
Not as a trigger

[color=#282828][font=helvetica, arial, sans-serif]select count(*) into kakateyudu from afdb_table where :field1= :"Hard code a value which has more same records" and status = 'K'[/font][/color]

[cherlapalli_jailer]

looks Ok

First try this
Not as a trigger

[color=#282828][font=helvetica, arial, sans-serif]select count(*) into kakateyudu from afdb_table where field1= "Hard code a value which has more same records" and status = 'K'[/font][/color]

[Kakateyudu]

[quote name='cherlapalli_jailer' timestamp='1356027308' post='1302988191']
looks Ok

First try this
Not as a trigger

[color=#282828][font=helvetica, arial, sans-serif]select count(*) into kakateyudu from afdb_table where field1= "Hard code a value which has more same records" and status = 'K'[/font][/color]
[/quote]


hard code cheyyalem baa as value differs.... same value chalaa vunte manam oka sare trigger chesela satisfy cheyyali

[cherlapalli_jailer]

For testing purpose run it in editor. Coz. Nothing worng with ur trigger. Pl check security settings and extra spaces etc

[Kakateyudu]

[quote name='cherlapalli_jailer' timestamp='1356028646' post='1302988393']
For testing purpose run it in editor. Coz. Nothing worng with ur trigger. Pl check security settings and extra spaces etc
[/quote]
chesa baa work avvatledu

[cherlapalli_jailer]

work avvatam ledu ante

count zero na leka null?

[Kakateyudu]

[quote name='cherlapalli_jailer' timestamp='1356029011' post='1302988450']
work avvatam ledu ante

count zero na leka null?
[/quote]

status k ani cheppa kada..... count(*) lo 0 vunte status 'k' vellali aa table lo ki or lekapohe 'x' vellali baa

[Ranga_The_Donga]

count(*) endhi... count ni elli kakateeyudu column lo peduthundhaa?

[Kakateyudu]

[quote name='Jeedeelu' timestamp='1356029357' post='1302988497']
count(*) endhi... count ni elli kakateeyudu column lo peduthundhaa?
[/quote]

kakateyudu anedhi predefined variable baa.... aa variable lo store cheskuntunna aa value

[Ranga_The_Donga]

[quote name='Kakateeyudu©' timestamp='1356029645' post='1302988542']

kakateyudu anedhi predefined variable baa.... aa variable lo store cheskuntunna aa value
[/quote]
jeevitham... pl/sql lo annni possible anukunta...

[Kakateyudu]

[quote name='Jeedeelu' timestamp='1356029788' post='1302988560']
jeevitham... pl/sql lo annni possible anukunta...
[/quote]

possible ante ? ardam kaledu baa

[Ranga_The_Donga]

[quote name='Kakateeyudu©' timestamp='1356029872' post='1302988573']

possible ante ? ardam kaledu baa
[/quote]
ante pl/sql elagaina rasukovachu...

nuvu paina rasindhi... ms sql cheyalemu...

[Kakateyudu]

[quote name='Jeedeelu' timestamp='1356029966' post='1302988586']
ante pl/sql elagaina rasukovachu...

nuvu paina rasindhi... ms sql cheyalemu...
[/quote]
pl/sql ye nadhi

[Ranga_The_Donga]

[quote name='Kakateeyudu©' timestamp='1356030185' post='1302988615']
pl/sql ye nadhi
[/quote]
ya..thelusu ba... nadhi ms sql.. difference chepthuna...