| 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?? |
