nexus Posted April 11, 2013 Report Posted April 11, 2013 [quote name='STFU' timestamp='1365638466' post='1303580777'] ???? [/quote] how are u..aa parameter gurthu ravatam ledhu..andhuke post vesa...
KOTC Posted April 11, 2013 Author Report Posted April 11, 2013 [quote name='nexus' timestamp='1365638859' post='1303580822'] how are u..aa parameter gurthu ravatam ledhu..andhuke post vesa... [/quote] good yo! koncham specific ga chepu e parameter antunavo ardham avaledhu
nexus Posted April 11, 2013 Report Posted April 11, 2013 I got it. this is the hidden parameter I was talking about "_optimizer_system_stats_usage". Thanks
Joey_Tribbiani Posted April 15, 2013 Report Posted April 15, 2013 Oracle Enterprise Manager lo .. Critical Alerts ni High importnace lo pampadam kudurutunda .. I mean manaki outlook lo red ! sysmbol to mail vastundi kada ..Ala .. Any 1 ?
KOTC Posted April 15, 2013 Author Report Posted April 15, 2013 [quote name='TheMonk' timestamp='1366050076' post='1303606936'] Oracle Enterprise Manager lo .. Critical Alerts ni High importnace lo pampadam kudurutunda .. I mean manaki outlook lo red ! sysmbol to mail vastundi kada ..Ala .. Any 1 ? [/quote] ne question neku red color lo email ravala? ala kudradhu emo naku telisi LTT nuv automatic ga petav alerts ? e version 10g,11g,12c??
deals2buy Posted April 15, 2013 Report Posted April 15, 2013 [quote name='TheMonk' timestamp='1366050076' post='1303606936'] Oracle Enterprise Manager lo .. Critical Alerts ni High importnace lo pampadam kudurutunda .. I mean manaki outlook lo red ! sysmbol to mail vastundi kada ..Ala .. Any 1 ? [/quote]naak telisi alaa set cheyyalem... [quote name='STFU' timestamp='1366050356' post='1303606975'] ne question neku red color lo email ravala? ala kudradhu emo naku telisi LTT nuv automatic ga petav alerts ? e version 10g,11g,12c?? [/quote] Red color lo email kaadu bhayya...I guess what he meant was, when u send an email you can set the priority of the email kadaa....like high priority.... email subject mundu "!" red color lo oka icon vastundi kada...alaa vastunda ani asking thanu
deals2buy Posted April 15, 2013 Report Posted April 15, 2013 Oracle lo case sensitivity teeseyyadam ela?
KOTC Posted April 15, 2013 Author Report Posted April 15, 2013 [quote name='Kaarthikeya' timestamp='1366052275' post='1303607263'] naak telisi alaa set cheyyalem... Red color lo email kaadu bhayya...I guess what he meant was, when u send an email you can set the priority of the email kadaa....like high priority.... email subject mundu "!" red color lo oka icon vastundi kada...alaa vastunda ani asking thanu [/quote] ade vayya na meaning kuda
KOTC Posted April 15, 2013 Author Report Posted April 15, 2013 [quote name='Kaarthikeya' timestamp='1366055601' post='1303607627'] Oracle lo case sensitivity teeseyyadam ela? [/quote] asalu scene chepakunda actor ki start acting laga asalu em chedam anukunav adi chepu
CheGuevara Posted April 15, 2013 Report Posted April 15, 2013 [quote name='Kaarthikeya' timestamp='1366055601' post='1303607627'] Oracle lo case sensitivity teeseyyadam ela? [/quote] nuvvu adigedi case sensitive related to passwords aite , sec_case_sensitive_logon ane paramter untadi danni false chey..by default it will be true
deals2buy Posted April 15, 2013 Report Posted April 15, 2013 [quote name='STFU' timestamp='1366056823' post='1303607756'] ade vayya na meaning kuda [/quote] [quote name='STFU' timestamp='1366056871' post='1303607764'] asalu scene chepakunda actor ki start acting laga asalu em chedam anukunav adi chepu [/quote] [quote name='CheGuevara' timestamp='1366057407' post='1303607845'] nuvvu adigedi case sensitive related to passwords aite , sec_case_sensitive_logon ane paramter untadi danni false chey..by default it will be true [/quote]adi kaadu bhayya....naa daggara table lo name column undi....so I am querying all the names starting with letter 'K' when I query like select * from mytable where name like 'K%' konni records istondi...but kontha mandi users lower case enter chesaru details..like 'kaarthikeya' instead of 'Kaarthikeya' in that case how can retreive those records? SQL server lo aithe case sensitive kaadu..ela ichina anni vasthayi..but its not working in Oracle
nexus Posted April 15, 2013 Report Posted April 15, 2013 [color=#282828][font=helvetica, arial, sans-serif]select * from mytable where upper(name) like 'K%';[/font][/color]
deals2buy Posted April 15, 2013 Report Posted April 15, 2013 [quote name='nexus' timestamp='1366058246' post='1303607969'] [color=#282828][font=helvetica, arial, sans-serif]select * from mytable where upper(name) like 'K%';[/font][/color] [/quote] got it so Oracle lo 'lower' and 'upper' anevi functions anamata in cases like this
deals2buy Posted April 16, 2013 Report Posted April 16, 2013 Oracle lo oka column use cheyyakapothe daanni unused ki set chestam kadaa... again malli aa column use cheyyalante used ki set cheskovadam ela?
CheGuevara Posted April 16, 2013 Report Posted April 16, 2013 [quote name='Kaarthikeya' timestamp='1366121415' post='1303611494'] Oracle lo oka column use cheyyakapothe daanni unused ki set chestam kadaa... again malli aa column use cheyyalante used ki set cheskovadam ela? [/quote] you cannot set it back to use...its gone
Recommended Posts