| Author |
Message |
    
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3616
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:38 pm: |    |
ala vunte danni star join antaru.. star schema anna mata...
ila rayali appudu query
SELECT
MOD.quarter,
SUM(fa.units_mes)
FROM
FACT_ACCOUNT1 fa,
MONTH_DIM MOD,
REGION_DIM rd,
MODEL_DIM md
WHERE
fa.MONTH_DIM=MOD.month_id AND
fa.REGION_ID=RD.REGION_ID AND
fa.MODEL_ID=md.MODEL_ID AND
LOWER(rd.area) LIKE 'benelux' AND
LOWER(md.TYPE) like 's series sedan'
GROUP BY
MOD.quarter |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12477
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 1:36 pm: | |
indaka nenu ichinattu Model_dim,region_dim.month_dim anni okkate type mama vatiki fact_account lo reference untadi ok na
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19924
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 1:35 pm: | |
from clause lo vunna anni tables ni join cheyyali.. lekapohey Katrina join ayyii ekkuvavaue vasthayii
 |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3615
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:33 pm: | |
asalu relation enti among tables.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3614
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:32 pm: | |
SELECT
MOD.quarter,
SUM(fa.units_mes)
FROM
FACT_ACCOUNT1 fa,
MONTH_DIM MOD,
REGION_DIM rd,
MODEL_DIM md
WHERE
fa.MONTH_DIM=MOD.month_id AND
LOWER(rd.area) LIKE 'benelux' AND
LOWER(md.TYPE) like 's series sedan'
GROUP BY
MOD.quarter
from clause lo vunna anni tables ni join cheyyali.. lekapohey cartesian join ayyii ekkuvavaue vasthayii  |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12474
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 1:28 pm: | |
Ante
AND LOWER(rd.area) LIKE 'benelux' AND LOWER(md.TYPE) like 's series sedan'
idi teesesthe inka thakkuva values vasthunnayiy kani idi unte chala ekkuva vasthunnayyi em thappu undi query lo
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12473
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 1:27 pm: | |
Gosi mama  neeku kooda thanks aina mee cinema poindi ga komchem time padathadi le 
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12472
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 1:26 pm: | |
SELECT MOD.quarter,SUM(fa.units_mes) FROM FACT_ACCOUNT1 fa, MONTH_DIM MOD, REGION_DIM rd, MODEL_DIM md WHERE fa.MONTH_DIM=MOD.month_id AND LOWER(rd.area) LIKE 'benelux' AND LOWER(md.TYPE) like 's series sedan' GROUP BY MOD.quarter
Idi choodu nayakudu mama indulo first and taruvatha unnavi teesesthe thakkuva value vasthundi output ila unte ekkuva avsthunbdi emanna repeat avuthunnayyi antava SUM ayyethappudu
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3612
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Thursday, May 04, 2006 - 1:21 pm: | |
emdundile mama ivanni chinnave kada... mana goppadanam yemi ledu... rasthu vuntam gada SQL queires DWH lo.. inka anthey |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19918
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 1:14 pm: | |
 naaku requirement arthamayyesarike ekkuva time paduthundhi..arthamayyaka thantaalu padi raasthaa..kaani nuvvasalu req elaa unna thaata theesthunnavgaa |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3610
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:13 pm: | |
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19917
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 1:11 pm: | |
 nayak maama saana fastgaa unnavgaa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19916
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 1:10 pm: | |
ELECT SUM(fa.units_mes)
FROM FACT_ACCOUNT1 fa,
Region_dim Rd
WHERE fa.reg_dim = RA.dim
and upper(rd.continenet) like ('AMERICAS')
GROUP BY fa.UNITS_MES
idhi try chesi choodu maama...kaani rd lo continet ekkada undi column |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3609
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:09 pm: | |
eppudu try to join tables mama .. kudaraka pothey ala sub querys.. DWH lo workingaaa ippudu good mama |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12471
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 1:07 pm: | |
Nayakudu mama Kummesavu
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3608
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:03 pm: | |
idi only area Asia ki.. anni areas kavalante aa condition theseyyi from where clause.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3607
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 1:02 pm: | |
SELECT dim.area, SUM(fa.units_mes) FROM FACT_ACCOUNT1 fa, REGION_DIM dim
WHERE
fa.REGION_DIM=dim.REG_ID AND
dim.AREA like 'Asia'
group by
dim.area |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12470
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 12:58 pm: | |
Ante ela ante ippudu Asia lo unna anni Countries ki sambandinchina UNITS ni add chesi adi output laga ravali mama ela cheyyali urgent baga
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12469
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 12:57 pm: | |
Region_dim
reg_id country area world
1 Ind Asia World
2 USA America World
3 SL Asia World
4 Ban Asia World
5 SA Ameirca World
6 Africa Africa World
fact_table
id region_dim units_mes
1 1 10
2 1 20
3 2 30
4 3 40
5 4 50
6 4 60
7 5 70
8 6 80
...
SELECT SUM(fa.units_mes) FROM FACT_ACCOUNT1 fa WHERE fa.REGION_DIM=(SELECT rd.region_id FROM REGION_DIM rd WHERE LOWER(rd.continent)='americas') GROUP BY fa.UNITS_MES
Idi thappu ani telusu kani naku ela rayalo ardham katalla
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19914
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 12:25 pm: | |
paigaa Nayak maama mention chesinattu select lo aggeragate unte Ex: sum( ),
adhi groupby lo pettakoodadhu..migathaavanni(nonaggregate) vanni pettukovaali |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12466
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 12:25 pm: | |
Thanks
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19913
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 12:23 pm: | |
Nayakudu and Gochi mamas..
Naku oka Doubt GroupBy anedi Select taruvatha vade anni columns ki vadala enti complusory ga komchem detail ga chepthara 1 hr nunchi kottukuntunna ikakd
maama...querylo nuvvemanna aggregate functions use chesthey chacchinattu anni groupby lo pettukovaali...
like
select a.apple,
b.banana,
sum(c.chocolate)
ani pedthey anni group by ettukovaali...sum() or other aggregate lekapothe akkarledhu..
inko scenelo querylo kooda aggergate function undanuko..like having(sum(chocolate) = 0 or having count() etc..
appudu kooda groupby lo anni pettali..lekapothe group by ni lite theesukovacchu |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3600
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 12:23 pm: | |
ounu mama... aa mudu combined ga repeat aithey data isthundi lekapothey ivvadu... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15404
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 12:19 pm: | |
mamalu groupby lo avanni peduthunte data emi ivvatam ledu mama, akkada duplicate unnadi okka user_name mathrame ga, andukani ravatam leda data?? |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3599
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 12:16 pm: | |
gorup by lo select lo vunna all non-aggregate columns ni pettali... |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12465
Registered: 04-2005
Posted From: 68.229.151.18
| | Posted on Thursday, May 04, 2006 - 12:11 pm: | |
Nayakudu and Gochi mamas..
Naku oka Doubt GroupBy anedi Select taruvatha vade anni columns ki vadala enti complusory ga komchem detail ga chepthara 1 hr nunchi kottukuntunna ikakda
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19912
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 12:07 pm: | |
b.first_name, b.last_name ee rendu kooda groupbylo add sesi try seyyi maama....
select a.user_name, b.first_name, b.last_name from a, b
where ....
having count(user_name) > 1
group by a.user_name,
b.first_name,
b.last_name |
Pokiri1
Kurra Bewarse
Username: Pokiri1
Post Number: 655
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Thursday, May 04, 2006 - 12:04 pm: | |
nee select statement lo count function ledu andukani neeku a error vachindi |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3598
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 11:58 am: | |
enti mama mee cinema ki ippudu yem certificate ichharu
U/A na leka A na edo godava anta gada mee DB lo chusa evaru aa pedda hero ila cheyisthundi |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 21611
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Thursday, May 04, 2006 - 11:54 am: | |
evalu seppoddu.. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15403
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 11:52 am: | |
inkoka question mamalu.
select a.user_name, b.first_name, b.last_name from a, b
where ....
having count(user_name) > 1
group by a.user_name
ante not a group by expression antadenti maam?? |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15399
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 11:08 am: | |
1 ki meeting gochi mama.  |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 21601
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Thursday, May 04, 2006 - 11:06 am: | |
nee enka..aa hemantu kuda mandu taagadu..
party ante mandu okatenaa mee US bhaashalo..
vindu...inkaa kudirite pondu kuudaa adugu.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19905
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 11:05 am: | |
nenu mandu thaaganugaa... |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 21600
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Thursday, May 04, 2006 - 11:04 am: | |
mundu party adugehe... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19903
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 11:02 am: | |
andarini meetingki pilichi pokiri songs inipinchesaava.. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15397
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:53 am: | |
avunu mama. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19901
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 10:33 am: | |
 hammayya..ivaaltiki gandam gattekkindanamaata hemanthaa |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15396
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:29 am: | |
vaake oka 28 mandi vacharu. kiki. chala chala thanks mama, inka meeting ki pilavochu aallani. kiki. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15395
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:28 am: | |
chi intha silly vi aduguthunna enti.  eligindi aagu. kiki. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15394
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:27 am: | |
andulo duplicates levu mama, kaani ippudu rasina query lo duplicate usernames unnayi ga, only aa duplicate rows ni ela thesukuravali, daniki emani raayali. ippudu rasina query a anuko. ippudu andulo unna duplicate ela thiyyyali bayataki?? |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3589
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Thursday, May 04, 2006 - 10:26 am: | |
alage
select substr(first_name,1,1), last_name, count(*) from cted
group by substr(first_name,1,1), last_name
having count(*) > 1 kuda chudu |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3588
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:24 am: | |
select user_name, count(*) from fu
group by user_name
having count(*) > 1
execute chesi chudu emaina duplicates vunnayemo |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15392
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:23 am: | |
aa extra rows sangathi ardam ayyindi mama. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15391
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:23 am: | |
mama nuvvu cheppindi pani cheyyatam laa. kani idi pani chesthundi.
UPPER(SUBSTR(fu.user_name, 2) = UPPER(cted.last_name(+))
AND
UPPER(SUBSTR(fu.user_name, 1,1)) = UPPER(SUBSTR(cted.first_name(+),1,1)
raayocha ilaa?? |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3586
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:22 am: | |
iddari employyes ki same perlu vudochu gada anduke extra rows vasthunnayi |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15390
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:21 am: | |
1st letter 1st name loni 1st letter mama, 2nd nunchi last name mama.
aagu nuvvu ichindi try chesthanu. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3585
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:20 am: | |
UPPER(SUBSTR(fu.user_name, 2)) enduku 2nd letter nunchi thesthunnavu neduku |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 21598
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Thursday, May 04, 2006 - 10:17 am: | |
utthi thanks cheppadam kaadhu..
aaliddariki PARTY ivvu.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3584
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:16 am: | |
WHERE
(FU.END_DATE IS NULL OR
fu.end_date >= TRUNC(SYSDATE)
)
AND
UPPER(SUBSTR(fu.user_name, 2) = UPPER(cted.last_name)(+)
AND
UPPER(SUBSTR(fu.user_name, 1,1)) = UPPER(SUBSTR(cted.first_name,1,1)(+)
idi try cheyyi mama vachhiddi |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15389
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:15 am: | |
yeh chesa mama, deniki ela cheyyalo cheppu mama. plz.
got it mama. ardam ayyindi., chass denemma ala vasthayi ani thelsi koda deniki ekkuva vachayi anukunta enti thingaramelani. chi chi. Thanks mamalu.  |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3583
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:13 am: | |
gosi mama cheppadu gada... alage cheyyi
extra rows enduku vasthunnayi ante kuda gosi mama cheppinatle... first letter valla
cheyyi dati poyindi manam yem cheyyalemu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15388
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:13 am: | |
a and b ante aa rendu query lu ani. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15387
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:13 am: | |
sare deniki anna cheppandi.
2 query lu rasanu. rendu user_name ni return chesthunayi. ippudu a lo undi b lo leni user_name ni return chese query ela rayali. naa daggara 2 qurey lu unnayi kani tables kadu!!!!!!!! |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15386
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:10 am: | |
aa employee id, ee table lo unna employee id okati kadu mama. veru veru. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15383
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:09 am: | |
user_id veru employee_id veru ga unnayi. sare aa query ki emi cheyyalo cheppu nayak mama. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19900
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 10:08 am: | |
mari aaa user)id,employee_id rendu unna table emanna unte daanni theesakocchi join cheyyi.. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15382
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:08 am: | |
undi mama, kani adi primary kadu, konnitiki null sachindi. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19899
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 10:08 am: | |
Nayak maama.. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15381
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:07 am: | |
user_id undi mama, kaani aa id nenu join cheyyalsina table lo ledu. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19898
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 10:07 am: | |
ainaa emplyee ID ledhaa FU table lo.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3582
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Thursday, May 04, 2006 - 10:06 am: | |
babu hemanth oka primary key create chesi thagaladu mama... users ni alaga maintain chesedi darunam ga... user id ani field create sheci user id anna ivvu prathi employee ki
lekpothey sequence generate dnumber create cheyii rendu tables lo... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15380
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 10:03 am: | |
thelsu mama, ala vasthundi, ippudu avi manual ga elimate cheyyali, anthakanna option ledu. suppose username CCameron ani undi anuko employees ila undochu Connie Cameron Capel Cameron, rendu rows vasthayi oka username, avi fix cheyyali aa next. mundu assala partial data ravali mama. |
Bob
Vooriki Bewarse
Username: Bob
Post Number: 3311
Registered: 03-2005
Posted From: 64.126.29.9
| | Posted on Thursday, May 04, 2006 - 10:02 am: | |
 nayukudu mama
VEERABHADRA |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19896
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 10:01 am: | |
maama...alaa SUBSTR pedithe data thappu vasthundemo...
ilaa unnayanuko last and first names..appudu 1st letters in both last name and first name match avuthaayi..so result thappu vasthundemo..daaniki artham kaaadhu join elaa cheyyalo
Jakka Hemanth (J,H)
Janugula Hanuman (J,H) |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15377
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:49 am: | |
join chesthaniki inkem levu mama, unnavi ive. substr ante substring function maam
ippudu fu table loni username ante entane username loni 1st letter cted table loni 1st name loni 1st letter annamata. fu.username loni remaining name cted table loni last name annamata.
ippudu aa condition deniki pettanu ante avi ala equal ayina valla names paina email id kosam thesthunna, equal lekapothe ante fu.username anevadu cted lo lekapothe just fu table loni row ne thecheyyali annamata. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19893
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 9:45 am: | |
ee rendu tables join cheyyataaniki inkemi levaa maama fields.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19892
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 9:44 am: | |
 asalu FU and CTED tables ilaa join chesaavaa... naakartham kaaledhu
asalu primary key enti..
fu.user_name = cted.last_name
fu.user_name = cted.first_name
indulo SUBSTR ante enti...
paigaa ee rendu joins satisfy avvalaa....lekapothe okkadaaniki outer pettinaa chaala... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15373
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:27 am: | |
cted.last_name(+)
and cted.first_name(+) ila petta mama outer join ento vachayi kani rows extra vasthunnayi. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15372
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:27 am: | |
idi mama.
AND (UPPER(SUBSTR(fu.user_name, 2)) = UPPER(cted.last_name)
AND UPPER(SUBSTR(fu.user_name, 1,1)) = UPPER(SUBSTR(cted.first_name,1,1)) |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19890
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Thursday, May 04, 2006 - 9:16 am: | |
WHERE ( FU.END_DATE IS NULL OR fu.end_date >= TRUNC(SYSDATE) )
AND (UPPER(SUBSTR(fu.user_name, 2)) = UPPER(cted.last_name)
AND UPPER(SUBSTR(fu.user_name, 1,1)) = UPPER(SUBSTR(cted.first_name,1,1))
)
indulo second condition annave...edi adhi maama... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15371
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:11 am: | |
naa req entante fu table ni employees 1st where condition loni vaallantha raavali, at the same 2nd where condition denikante adi satisfy ayina vaalla 1st name, last_name employee id thesthaniki. 2nd condition satisfy avvakapoyina aa rows raavali. ela mamalu. ardam ayyinda nenu adigindi?? |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15370
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:09 am: | |
naaku kavalsindi entante aa 2nd where condition satisfy avvakapoyina paina unna 1st condition lonu fu table loni details raavali mamalu?? 2nd where condition ni ela marchali?? |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15369
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Thursday, May 04, 2006 - 9:07 am: | |
naa query idi.
SELECT DISTINCT CTED.EMPLOYEE_ID, fu.user_name, NVL (cted.email_address,
CTED.first_name || '_' || CTED.last_name || '@' || 'xxxx.com'
) email_address, cted.payroll_company_id, FU.START_DATE, FU.END_DATE FROM fnd_user fu, xxx_tande_employees_data cted
WHERE ( FU.END_DATE IS NULL OR fu.end_date >= TRUNC(SYSDATE) )
AND (UPPER(SUBSTR(fu.user_name, 2)) = UPPER(cted.last_name)
AND UPPER(SUBSTR(fu.user_name, 1,1)) = UPPER(SUBSTR(cted.first_name,1,1))
)
ORDER BY fu.user_name |
