| Author |
Message |
    
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17775
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 3:53 pm: |    |
 maa thammay picchi maalokam maama...thanaki jariginavanni pakkanolla meedha seppesi mana meedha jaali paddatattu cutting ichi thana meedha thaney jaali padathaa untaadu...so aa candidateni vadiley
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta  |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 55
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 3:51 pm: | |
gochi pakka section lo #2 gadu ninnu edo antunnadu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17773
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 3:48 pm: | |
 Hemugaa...iyanni seppalante nee billing rate entha seppi,andulo naaku,mahi maayyaki kooda vaata iyyali...
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 52
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 3:43 pm: | |
sql plus session use cheste
set serveroutput on
vadali. then only it'll display the o/p of dbms_output statements |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14495
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 3:37 pm: | |
ok mama, thelsindi le.  dbms_output.putline vaadali. kiki. |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 51
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 3:34 pm: | |
ee variables. could you explain more |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14494
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 3:28 pm: | |
gochi ga, how to print the variables?? |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17770
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 2:50 pm: | |
work saana undi Mahi maayya...poddunninchi oopiri aadakundaa work sesaa...lunch kooda 2.30 ki thinna...ippudey koosantha time dorikindhi...
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14493
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:49 pm: | |
gochi gaa, naaku koda sql vachesindiroyy. kiki.
gochi ga, manam oka 2 hours sessions ettukundama ilantivi. kiki. |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 50
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:49 pm: | |
gochi work ela vundi. inka kummestunnara office lo |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14492
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:49 pm: | |
yeh undav mama, anduke table loki ravatam laa, load chesetappudu aa error vasthundi, andukani madhyalo unna load table lo chosthunna, so maaku vachina data thappu dobbinchukundi. amdhyalo unna table lo aa indexing ledu. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17768
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 2:48 pm: | |
correste Hemugaa...nene conpuse ayya
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17767
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 2:47 pm: | |
 mahifan maayya
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 49
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:47 pm: | |
select count (*) from
(select distinct employee_id, start_employement_date, end _employment_date from
emp_table);
ee query will perfect ga work avutundi. aina unique index already vunte inka duplicates vundavu... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14491
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:46 pm: | |
nenu select x1, x2, x3 antunna, count(*) ani ante aa pai moode ani kaada meaning?? |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 48
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:46 pm: | |
gochi |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17766
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 2:45 pm: | |
 count(*) ante anni columns match avvaligaa hemugaa...kaani neku only 3 columnsegaa kaavalsindhi
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 47
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:44 pm: | |
you can also do like this
select count (*) from
(select distinct employee_id, start_employement_date, end _employment_date from
emp_table);
compare this to select count(rowid) from emp_table.
if there is any count difference then there are duplicates |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 17765
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, March 23, 2006 - 2:44 pm: | |
'L' pathivratha avvaalani mokaalidaaka pasupu raasindanta |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14490
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:44 pm: | |
yeh, unique index undi mama. yeh count(*) is working. found the problem. |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 46
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:41 pm: | |
if the index is already there on the table it means the columns are unique |
Mahifan
Pilla Bewarse
Username: Mahifan
Post Number: 45
Registered: 06-2004
Posted From: 63.118.29.3
| | Posted on Thursday, March 23, 2006 - 2:40 pm: | |
try to create a unique index on those columns. if the index creation fails, it means there are duplicates in the table
create unique index idx_temp_1 on emp_table(employee_id, start_employement_date, end _employment_date) |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14489
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:38 pm: | |
kiki count(*) ichaa, kani adi sarigga pani sethunnattu anipinchatam laa, saana rows vachayi. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14488
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:35 pm: | |
gochi ga, plzz seppu. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14487
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Thursday, March 23, 2006 - 2:28 pm: | |
mamalu, oka table lo 3 columns values duplicate vasthunte ela kanukkovali??
ippudu naa table lo 3 columns ni unique ani index ga define chesi undi. at a time 2 rows lo aa 3 values same undakodadu. avi employee_id, start_employement_date, end _employment_date
ippudu avi unnayemo chosthaniki query ela raayali??
indaka okka column ki elago chepparu, similar ga ala rasthunte ravatam laa. |
