| Author |
Message |
    
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3333
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, May 01, 2006 - 2:28 pm: |    |
execute immediate use cheyyochhemo kada |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8408
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, May 01, 2006 - 2:27 pm: | |
yaa mama vere option ledu
nenu ila raasukunna
even the main query kuda same table lo untundi
qstring,inparam, inexp, inval, intype ani
qstring emo total qeury with ??? for input parametes like select ename from emp where emp.sal = ?
inparam emo emp.sal annamata
inexp emo = (it cud be > < between like )
inval emo = emp.sal (so deni batti table emp ani column sal ani thelushtindi kadha..so select sal from emp naa input values)
intype = naaku dani datatype theledu kadha so stroing it as string, date , number a ani |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3332
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, May 01, 2006 - 2:26 pm: | |
nenu first ila try chesa..
(bill_qty > ship_qty) or
(bill_qty > inv_qty and type 'D')... rakudanivi vachhayi..
malla ila anna.. correct gane work avuthundi
bill_qty > ship_qty and
(
(bill_qty > ship_qty and type <> 'D') or
(bill_qty > inv_qty and type = 'D')
) |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19742
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 2:22 pm: | |
 not exists ante just aa data anthaa filter avuddi maama...emiti work avvaledhaa  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19741
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 2:21 pm: | |
babu maama...antey nuvvu ippudu aa table nunchi queries pick chesi nee prenet querytho run cheyyaala.like
select * from A where manager_id = (select X from Query Q)
anagaane Query table lo unna query vacchi ee queryki subquerylaaga form avvaala.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3329
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Monday, May 01, 2006 - 2:19 pm: | |
gochi mama
ee madhya kalam lo neevu rase queries naku konchem ardham kavatla mama.. hehehehe.. nenu asalu exists not exists use cheyyandu chala thakkuyva.. konchem confuse avutha |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8406
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, May 01, 2006 - 2:13 pm: | |
gosi ga mari eti chestham unnayi oo 300 queries mari anni stored procedures kinda rasukovali
lekapothe ekkada xml or db lo store chesukovali  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19739
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 2:12 pm: | |
ee queries anni nenu oka table lo pettukunna, query table ani cheppukundam
runtime lo aa query text thechukoni, dynamic ga avi emi parameters aduguthundo cheppochha
itta kooda seyyochaa ....antey queries ni table lo ettukuni calling seyyochaa..manaki antha scene illio..
 |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8405
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, May 01, 2006 - 2:09 pm: | |
mamalu nenu kuda oka kocchin adugutha 
parameterized queries unnayi oo 300
for ex :
select e.name, e.deptno, e.salary from emp e where e.joindate = ? and e.mgrid = ?
idi query
deniki parameters first daniki oka date ivvali
seond daniki suppose manager.id (table manager lo id column)
ee queries anni nenu oka table lo pettukunna, query table ani cheppukundam
runtime lo aa query text thechukoni, dynamic ga avi emi parameters aduguthundo cheppochha |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19735
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 2:06 pm: | |
 yaadikellavu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19731
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 2:00 pm: | |
ilaa raayakoodadhaa 
select * from A
where bill_qty > ship_qty
and not exists (select * from A where type = 'D' and bill_qty = ship_qty and bill_qty = inv_qty) |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3328
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Monday, May 01, 2006 - 1:58 pm: | |
ship_qty and inv_qty will never be more than bill_qty |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3327
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Monday, May 01, 2006 - 1:57 pm: | |
sorry adi
bill_qty, ship_qty, inv_qty, type comma missing |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19730
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 1:56 pm: | |
D ante enti....character input chesaara numbers madhyalo |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3326
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Monday, May 01, 2006 - 1:55 pm: | |
hehehe gosi mama kinda daniki condition cheppu ela rayalo.. hehehe neevu kuda nalati vadivena chudali hehehe |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3325
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Monday, May 01, 2006 - 1:54 pm: | |
oka table vundi
columns bill_qty, ship_qty, inv_qty type (type can have 'D' or other values)
ippudu
write a select statement that fetches
1. rows with bill_qty is more than ship_qty for all orders (including type 'D')
2. for type 'D', rows should not be picked up if bill_qty is equal to either ship_qty or inv_qty |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19728
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, May 01, 2006 - 1:53 pm: | |
entha mandiki vunnayo testis
 |
Kalki
Vooriki Bewarse
Username: Kalki
Post Number: 3947
Registered: 04-2005
Posted From: 129.33.49.251
| | Posted on Monday, May 01, 2006 - 1:51 pm: | |
appudeppudooo ongole gittalani teesukelle vallante europe ki testing ki
adena??
God of masses striking again - 
|
Thingarodu
Desanike Pedda Bewarse
Username: Thingarodu
Post Number: 9829
Registered: 04-2005
Posted From: 62.252.64.13
| | Posted on Monday, May 01, 2006 - 1:48 pm: | |
present saaar
I would Ignore or Avoid an Entity rather than Hating  |
Kalki
Vooriki Bewarse
Username: Kalki
Post Number: 3946
Registered: 04-2005
Posted From: 129.33.49.251
| | Posted on Monday, May 01, 2006 - 1:47 pm: | |
emi testing ???
God of masses striking again -
|
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3324
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Monday, May 01, 2006 - 1:46 pm: | |
entha mandi vunnaro testing |
