SQL View Help   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse Talk � Archives � Cine Talk - Reviews, Gossips, Insider Info etc. � Archive through May 29, 2006 � SQL View Help � Previous Next �

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:   Edit PostDelete PostView Post/Check IP

emi confuse ooo.....pedda JHALAK ichavu aa statement....dimma tirigindhi :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

swarry Bhups maama...koosintha conpuse ayya
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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...
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

gosi
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

adi mama same statement
select * from view anthe
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

thanxu babu maama..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

jonny maama...hammayya...inkaa nayam inkonchem late ayyunte maa DBA ki pone sesi booths D'dhaamanukunna
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

babu mama viewni run chese stmt enti?

select view vname?
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

yes gocio. viewlo data stored undadu. query store ayi untundi. so manam frequentga use chese query ni view laga rasukuntam.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

avunaaa..maa databaselo raatalledenti...M kudipaaremo maa vollu..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

ledu gocio. select * from view kodithe data vastundi.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

emo maa naadhi thappu kooda ayyundacchu...nenu kooda conpuse ayipoyaa...oka saari conpirming sesi seppavaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP



neeku xml vacha mama?
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

table update ayinappudu view update avuthundi mama view script ni batti, appudu data untundi ga mama.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

yeh aadi mama, pola. Thanks mama.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

ohh ippude chosa test lo. data podu, chinna test chesa. kiki.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

data podu mama. u can drop it. i was wrong earlier.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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??
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

mama...aa view yokka code ni back up theesukuni

drop view view_name ivvu
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

statement delete view ani vadava?
drop view ani vadava?

a view cant be deleted. it is droped.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

data ledu mama view lo prasthutham.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

integrity constraint voilation undemo mama. like u cant delete a view when the info on which it is built is still existing.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Edit PostDelete PostView Post/Check IP

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