Author |
Message |
Bhupathi
Pilla Bewarse Username: Bhupathi
Post Number: 216 Registered: 05-2005 Posted From: 209.234.142.52
| Posted on Friday, May 26, 2006 - 12:06 pm: | |
emi confuse ooo.....pedda JHALAK ichavu aa statement....dimma tirigindhi |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21639 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 12:05 pm: | |
swarry Bhups maama...koosintha conpuse ayya |
Bhupathi
Pilla Bewarse Username: Bhupathi
Post Number: 215 Registered: 05-2005 Posted From: 209.234.142.52
| Posted on Friday, May 26, 2006 - 12:03 pm: | |
Gochi mama, enti boothuls madaladuthunnavu?? ****kaavalante select * from view ani kottu..data raadhu..lekapothe select count(*) from view kottu..output raadhu..so data andulo undadhu..just code anthe.. ******* select * and select count(*) enduku pani cheyyavau mama? it will for sure... View, oka table laga physical gha data store avvadhu....it runs the code every time it needs it... |
Babu
Desanike Pedda Bewarse Username: Babu
Post Number: 8693 Registered: 06-2004 Posted From: 65.208.22.26
| Posted on Friday, May 26, 2006 - 10:46 am: | |
gosi |
Babu
Desanike Pedda Bewarse Username: Babu
Post Number: 8692 Registered: 06-2004 Posted From: 65.208.22.26
| Posted on Friday, May 26, 2006 - 10:43 am: | |
adi mama same statement select * from view anthe |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21634 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:43 am: | |
thanxu babu maama.. |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21633 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:42 am: | |
jonny maama...hammayya...inkaa nayam inkonchem late ayyunte maa DBA ki pone sesi booths D'dhaamanukunna |
Jonny
Bewarse Username: Jonny
Post Number: 1233 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:40 am: | |
babu mama viewni run chese stmt enti? select view vname? |
Jonny
Bewarse Username: Jonny
Post Number: 1232 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:38 am: | |
yes gocio. viewlo data stored undadu. query store ayi untundi. so manam frequentga use chese query ni view laga rasukuntam. |
Babu
Desanike Pedda Bewarse Username: Babu
Post Number: 8691 Registered: 06-2004 Posted From: 65.208.22.26
| Posted on Friday, May 26, 2006 - 10:38 am: | |
gochi mama view lo data emi undadhu just it is a compiled structure in the databse, as we define it earlier. so data retrieval fast ga untundi when compared to same sql select query anthe. everytime nuvvu view access chesthe it will retrieve it from the tables dynamically |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21632 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:35 am: | |
babu maama ikkada kochen adhi kaadhu...view lo data store avuthundhaa leka just adhi code maatramenaaa ani..nenaukovatam view lo data undadhu,just code adhi..access chesinappudalla code run ayyi output isthundhi ani.. |
Jonny
Bewarse Username: Jonny
Post Number: 1231 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:35 am: | |
oh. sorry mama. u r right. i am wrong. asalu view antene oka stored query kada? select view view name kodithe aa view lo query result vastundi anukunta. i am confused to. hemuga, oka sari test chesi cheppu. lekapothe naku nidra pattadu |
Babu
Desanike Pedda Bewarse Username: Babu
Post Number: 8689 Registered: 06-2004 Posted From: 65.208.22.26
| Posted on Friday, May 26, 2006 - 10:33 am: | |
view is just a window mama to view the data. underlying table lo ni data ni display chesthundi so drop view ante u r just dropping the view anthe create chesetappudu alwyas use create or replace view anthe, it will take care if any view exists earlier. |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21631 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:30 am: | |
avunaaa..maa databaselo raatalledenti...M kudipaaremo maa vollu.. |
Jonny
Bewarse Username: Jonny
Post Number: 1230 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:28 am: | |
ledu gocio. select * from view kodithe data vastundi. |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21630 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:23 am: | |
emo maa naadhi thappu kooda ayyundacchu...nenu kooda conpuse ayipoyaa...oka saari conpirming sesi seppavaa.. |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21629 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:22 am: | |
table update ayinappudu ante table lo data update ayinappudaa.. adhe maama nenu cheppedhi...view just code maatrame..aa view ni access chesinappudalla view lo unna code mottham run ayyi output isthundhi.. kaavalante select * from view ani kottu..data raadhu..lekapothe select count(*) from view kottu..output raadhu..so data andulo undadhu..just code anthe.. |
Jonny
Bewarse Username: Jonny
Post Number: 1229 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:18 am: | |
neeku xml vacha mama? |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16279 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 10:16 am: | |
table update ayinappudu view update avuthundi mama view script ni batti, appudu data untundi ga mama. |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21628 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:13 am: | |
asalu view lo data store avvadhanukuntaa maama...just nuvvu aa view access chesinappudalla aa code anthaa run ayyi neeku data isthundhi... anduke view lo vaadithe performance denks antaaru.. |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16278 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 10:13 am: | |
yeh aadi mama, pola. Thanks mama. |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16277 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 10:11 am: | |
ohh ippude chosa test lo. data podu, chinna test chesa. kiki. |
Jonny
Bewarse Username: Jonny
Post Number: 1228 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:11 am: | |
data podu mama. u can drop it. i was wrong earlier. |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16276 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 10:08 am: | |
Thanks mama, work ayyindi test lo. kani production lo ippudu production table lo data undi, drop ante data pothunda?? data pokunda ela view script ni marchali?? |
Gochi
Bewarse ke Bewarse! Username: Gochi
Post Number: 21627 Registered: 07-2004 Posted From: 162.136.192.1
| Posted on Friday, May 26, 2006 - 10:07 am: | |
mama...aa view yokka code ni back up theesukuni drop view view_name ivvu |
Jonny
Bewarse Username: Jonny
Post Number: 1227 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 10:05 am: | |
statement delete view ani vadava? drop view ani vadava? a view cant be deleted. it is droped. |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16274 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 9:58 am: | |
data ledu mama view lo prasthutham. |
Jonny
Bewarse Username: Jonny
Post Number: 1226 Registered: 04-2005 Posted From: 220.238.203.186
| Posted on Friday, May 26, 2006 - 9:56 am: | |
integrity constraint voilation undemo mama. like u cant delete a view when the info on which it is built is still existing. |
Hemanth
Bewarse ke Bewarse! Username: Hemanth
Post Number: 16273 Registered: 03-2004 Posted From: 65.196.167.82
| Posted on Friday, May 26, 2006 - 9:52 am: | |
Gochi, nayakudu mamalu ilanti question anthaku mundu adiginattu gurthu nenu. view ni alter cheyyalante ela. mundu view ni delete chesi aa same script ni malla run cheyyala?? kani delete view pani cheyyatam laa, error vasthundi. ORA-01752 ani. emi cheyyala?? |