Callinh wrathchild....urgent.... Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through August 15, 2009 » Callinh wrathchild....urgent.... « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Basky_indya
Hero
Username: Basky_indya

Post Number: 16713
Registered: 10-2007
Posted From: 75.185.64.101

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:15 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
mama convert sql display area into TEXT (from grid) and it forms the query .

u can read it , fix the syntax accordingly
Gigantic Techno fuctional Mega Blockbuster Magnum Opus BOMMA
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6931
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:11 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:

.aa sql string ni dbms_outline petti sarigga construct ayyindo ledo choodu



upate comment chesi..just idi choodu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9046
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:10 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:

i mean schemaname.table name

Chasing_perfection:

ante V_table place lo nee table name ichava?



icha annai..schema name icha ....sysnonym try chesaaaa....asalu own schema lo run chesthunna sql...
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6930
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:04 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:



schema name kooda pass chesi choodu


i mean schemaname.table name
Top of pagePrevious messageNext messageBottom of page Link to this message

Chasing_perfection
Junior Artist
Username: Chasing_perfection

Post Number: 22
Registered: 04-2009
Posted From: 96.241.144.176

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:03 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:



invalid tablename antondi annai



ante V_table place lo nee table name ichava?
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6929
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:03 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:

invalid tablename antondi annai



schema name kooda pass chesi choodu or create a public synonym...aa sql string ni dbms_outline petti sarigga construct ayyindo ledo choodu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9043
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:03 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:

oka string lo Update sql construct chey..some thing like

stmt_string := 'UPDATE '|| IN_VAR_TAB_NAME || 'SET ' || IN_VAR_COL_NAME ....




adi elago ardham kaake ee thread annnai...konni try chesa work out kaavatle
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9042
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:02 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Chasing_perfection:



invalid tablename antondi annai
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9041
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 02:01 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Chasing_perfection:

Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Chasing_perfection
Junior Artist
Username: Chasing_perfection

Post Number: 21
Registered: 04-2009
Posted From: 96.241.144.176

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:49 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:



v_2 CONSTANT VARCHAR2 (1) := '&';
v_1 CONSTANT VARCHAR2 (8) := '%&%';


v_sql := 'UPDATE :1
SET :2 =REPLACE (:2, v_1, v_2)
WHERE :2 LIKE v_1'

execute immediate using v_sql(v_table,v_column);

Hope this works, I am not sure though...
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6924
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:28 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
sachin tammud..naaku correct ga ardham ayyindantava nee question
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6923
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:26 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Sachin:


UPDATE <table_name>
SET <column_name> =REPLACE (<column_name>, v_1, v_2)
WHERE <column_name> LIKE v_1



oka string lo Update sql construct chey..some thing like

stmt_string := 'UPDATE '|| IN_VAR_TAB_NAME || 'SET ' || IN_VAR_COL_NAME ....
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Hero
Username: Idle_yzag

Post Number: 15559
Registered: 02-2008
Posted From: 198.80.153.5

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:26 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:


urgent aa? evening or weekend choodacha?

sure urgent yemi ledu
JP/YSR/Rahul/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9040
Registered: 04-2008
Posted From: 192.77.161.22

Rating: 
Votes: 1 (Vote!)

Posted on Friday, August 14, 2009 - 01:20 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Account:



pumpuhar...dynamix sql ante thelusaaaaa....
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6922
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:20 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

annai chinna VISA question vundi, mail chesi phone number istha call cheyandi detailed ga explain chestha?



urgent aa? evening or weekend choodacha?
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9039
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:19 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:


annnai mail open kaadu....

v_2 CONSTANT VARCHAR2 (1) := '&';
v_1 CONSTANT VARCHAR2 (8) := '%&amp;%';


UPDATE <table_name>
SET <column_name> =REPLACE (<column_name>, v_1, v_2)
WHERE <column_name> LIKE v_1


aa pai sattemenmt dyanamic sql lo petttali...table_name and column name nenu procedure input variables kinda isthaa....
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder
Top of pagePrevious messageNext messageBottom of page Link to this message

Chiru_fan
Side Hero
Username: Chiru_fan

Post Number: 7855
Registered: 04-2008
Posted From: 170.22.76.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:19 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
/select Annayya_Majority from Palakollu_voters where Magadheera_viewers equals Annayya_Fans/

CHIRU - SACHIN - FEDERER
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Hero
Username: Idle_yzag

Post Number: 15558
Registered: 02-2008
Posted From: 198.80.153.5

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:18 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Wrathchild:

bitnbyte gmail

annai chinna VISA question vundi, mail chesi phone number istha call cheyandi detailed ga explain chestha?
JP/YSR/Rahul/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Account
Junior Artist
Username: Account

Post Number: 65
Registered: 06-2009
Posted From: 98.228.58.252

Rating: 
Votes: 1 (Vote!)

Posted on Friday, August 14, 2009 - 01:18 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
select Annayya_Majority from Palakollu_voters where Magadheera_viewers equals Annayya_Fans
Top of pagePrevious messageNext messageBottom of page Link to this message

Wrathchild
Side Hero
Username: Wrathchild

Post Number: 6921
Registered: 03-2009
Posted From: 192.146.101.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:14 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
eto cheppu..try sesta..bitnbyte gmail
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachin
Side Hero
Username: Sachin

Post Number: 9037
Registered: 04-2008
Posted From: 192.77.161.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 14, 2009 - 01:14 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
annnai naaku oka dyanamic sql statement kaavaaali...
Oka Skywalker..oka NBkfan..Oka Redplanet.OkaNTR_rocks..oka rangupadudddi...oka lionswalkalone....oka gotcha...oka 2cool...oka pathfinder

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x9bb3648){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: