| Author |
Message |
    
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 107
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 4:06 pm: |    |
yea ippude swoosaa..
gwoogle sette idi vachindi..
http://www.orafaq.com/usenet/comp.databases.oracle .misc/2002/01/01/0016.htm
thanks yee.. |
Rrc
Bewarse
Username: Rrc
Post Number: 1026
Registered: 04-2006
Posted From: 129.138.6.16
| | Posted on Friday, July 07, 2006 - 4:02 pm: | |
 ammo gochi dada database lo thopaaaaaaaaaaaaaaa
A person should not be too honest. Straight trees are cut first and honest people are screwed first |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24117
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 4:01 pm: | |
select distinct table_name,column_name from all_tab_columns where column_name like '%XYZ%'
 idhi try sesaava..nenu emanna column vethakaalante idhe sesthaa maama..
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 106
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 4:01 pm: | |
ikkade full swebutunte inka gwoogle endukehee.. |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 105
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 4:00 pm: | |
vuntadi mayaa..but 300 tables nenu ekkada ediki saavanu seppu.. monnatidaka edukkone vaadni..ippudu sakkaga query raasukoni |
Rrc
Bewarse
Username: Rrc
Post Number: 1025
Registered: 04-2006
Posted From: 129.138.6.16
| | Posted on Friday, July 07, 2006 - 4:00 pm: | |
google seyyi debbaki database vonguntundhiiii
A person should not be too honest. Straight trees are cut first and honest people are screwed first |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 104
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:58 pm: | |
monnati dakaa prati table ni edukkonevaadni..ippudu sakkagaa..
ittane anni column names meeda emanna swerch kottochaa |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17884
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:58 pm: | |
itta kadu kani oracle lo saana mandi unnam kani, monday nunchi oracle ki oka thadu esukundam, lekapothe oka section pedadama. kiki. vadhule ikkade edham. kiki. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24116
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:57 pm: | |
maama TOAD lo shema browser undi kadhaa...andulo anni tables untaayigaa 
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24115
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:56 pm: | |
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 103
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:56 pm: | |
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24114
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:54 pm: | |
thokkalo TOAD ni malla front end ani coverings isthunnavgaa 
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Pokiri1
Bewarse
Username: Pokiri1
Post Number: 1111
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, July 07, 2006 - 3:53 pm: | |
ante ippudu Dadaa ni kuda andaru tittalanna mata.
|
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 102
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:52 pm: | |
 nee yanks nenu oracle db vaadedi..toad front end.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24113
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:52 pm: | |
aithe vaake
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 101
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:51 pm: | |
table ni describe sette vundani soopittandi..andulo data illio..vunna manaki kanapadatam ledu anukunta..maa dba gaadu att set sesi vuntadu privileges.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24112
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:50 pm: | |
Dadaaaa....inthaki needi oracle aa leka MS Access aa  ippude google lo search kodithe vaadevadiko ittaane select * from tab work avvatledu ani Ora faq discussions forum lo esaadu threaddu....sivariki andaru thala baddalu kottukunnaka vaadu seppaadu vaadidhi MS Access ani..janaalu booths D'ru baaga 
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Pokiri1
Bewarse
Username: Pokiri1
Post Number: 1109
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, July 07, 2006 - 3:45 pm: | |
nuvvu konnni rojulu pokiri records ni truncate cheyali hemu.
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24111
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:44 pm: | |
PDAgaa...mee database Walgreens ki elli maathra esukunnattu undi... system theesi trash lo D'gu
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17883
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:43 pm: | |
ayithe ikkada pettukundam kasini classes. thokkalo pokiri and bangaram. kiki. |
Pokiri1
Bewarse
Username: Pokiri1
Post Number: 1108
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, July 07, 2006 - 3:42 pm: | |
hemu neeku oracle data base vunte neeku SQL PLUS vuntundi chudu. yellow color lo plus symbol vuntundi nee monitor meeda chudu. gochi tammi hemu ki nuvvu databse classes teesukovali. |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 100
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:42 pm: | |
gosi mayaa naaku select * from tab pani seyyadam laa..endukani |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17882
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:41 pm: | |
avunu mama sql plus lone.  |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17881
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:40 pm: | |
nenu vadedi oracle ee ayithe, TNS ani undi, naku appudu TNS name not resolved ani vasthadi, adi Oracle lone undi. thanks pda mama. kiki. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24110
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:40 pm: | |
nee yenks...nuvvu vaadedhi edhi ante em septhaam...nee start--> programs lo Oracle ani undhaa SQL Server ani undaa...nuvvu SQL ekkada rasthaavu other than TOAD...SQL+ lonenaaa
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17880
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:38 pm: | |
Ohoo, ammani antha theda unda.
adi sare nenu vade datebase oracle ani ela thelsukovatam?? ekkada last menu button lo help lo about lo untada?? |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 99
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:38 pm: | |
http://www.dba-oracle.com/oracle_news/2005_12_16_s ql_syntax_differences.htm
eetillo nuuvu ye syntax vadataavo adi nee Database..sooskoo.. |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 98
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:37 pm: | |
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24108
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:36 pm: | |
maama..Oracle anedhi Oracle company vodu thayaru chesina databse...
SQL server anedi Microsoft vaadi product..Oracle ki competitor...nuvvu Oracle apps lo working kaabatti mostly meedhi Oracle databse ayyuntaadhi...
Oracle SQL ki SQL server SQL ki konchem dippereneces unnayi syntaxlo..kaani okati vasthe rendodhi manage avuddi..
ivi kaaka inkaa marketlo unna pamous databases Teradata,DB2 etc
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17879
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:33 pm: | |
nijam gane theliyadu mama, seppu, ela thelsukovali. |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 97
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:33 pm: | |
inthaki oracle ki sql server ki theda enti?? nenu emi vaduthunnanu ippudu??///nuvvu ye database meeda setunnavo telda neeku |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24107
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:33 pm: | |
hemanthgaa..nijangaa aduguthunnava..leka mammalni kindaling kosam aa kochen vesaava..
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 96
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:32 pm: | |
gosi mayaa all_tables di mottam system tables info kooda istandi..anduke ekkuva vastunnayi..
nenu owner name meeda filter sesukunnaa |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17878
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:32 pm: | |
inthaki oracle ki sql server ki theda enti?? nenu emi vaduthunnanu ippudu?? |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 95
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:31 pm: | |
select * from tab
idi naaku pani sweyyatledu enti |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24106
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:31 pm: | |
PDA maama...nenu seppindhi kooda oracle loney...
select * from tab
oracle aithe neeku enduku raatalledhu ilaaga..
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24105
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:30 pm: | |
sinnapillallaaga deeniki kullendehe..
emi ledhu
select table_name from all_tables ante naaku oka number vasthaandhi...oka veyyi paina vacchaayi
kaani select * from tab ante verey number vasthaandhi..oka moodondhalu vacchaayi..enduku avuthaandhaa ani soottunna..
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 94
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:28 pm: | |
select * from tab
gosi & kushi mayaalu idi sql server di anukuntaa..nenu seppadam marchipoyaa oracle lo ani..swaary..I appreciate ur help |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17877
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:26 pm: | |
ippudu gochi gadiki kullosthundi. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17876
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:26 pm: | |
 |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 93
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:23 pm: | |
emu mayaa nuvvu seppindi pani settandi
andariki thanks yee |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24103
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:22 pm: | |
oka particular table/column kosam vethiketatlaithe :
select table_name,column_name from all_tab_columns where column_name like '%XYZ%'
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17875
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:22 pm: | |
tab ane table koda undi mamoi. kiki. tabtype table, view, synonym etc unnayi. |
Bangaram_khushi
Pilla Bewarse
Username: Bangaram_khushi
Post Number: 27
Registered: 04-2006
Posted From: 208.189.200.2
| | Posted on Friday, July 07, 2006 - 3:20 pm: | |
SELECT * FROM TAB where tabtype = 'TABLE';
WORK kada idi?? |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17874
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:19 pm: | |
select table_name from all_tables
kiki. pani sethademo soodu. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 24102
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, July 07, 2006 - 3:19 pm: | |
select * from tab
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17873
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, July 07, 2006 - 3:18 pm: | |
ekkado chosanu mama adi, aagu chosi chepthanu. |
Proofdadaa
Pilla Bewarse
Username: Proofdadaa
Post Number: 90
Registered: 06-2006
Posted From: 129.138.18.85
| | Posted on Friday, July 07, 2006 - 3:17 pm: | |
I want to query all table names and I don't have DBA previleges. Is there any way I can retrieve all table names like 'XXXX%' in a given schema. |
