Home » SQL & PL/SQL » SQL & PL/SQL » Reserved words Location (oracleXE)
Reserved words Location [message #402213] Fri, 08 May 2009 02:00 Go to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
table names, column names are stored in all_tables, dba_tables and in related/ associated tables. Now, my requirement is,
Is there any table is loaded with command sets like "select",
"update", "delete", "where", "from" etc.
If there is, and if i can change the select as "edu", will it work.

for example
select * from emp_mst
instead
edu * from emp_mst
Re: Reserved words Location [message #402216 is a reply to message #402213] Fri, 08 May 2009 02:10 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Reserved words are in v$reserved_words

Replacing reserved words with other terms is not possible and not necessary (in my view). Why would anyone want to do that?
Re: Reserved words Location [message #402217 is a reply to message #402216] Fri, 08 May 2009 02:15 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi frank
if someone wants to try sql statement in tamil, and replacing the reserved words through tamil translitering character sets will enhance the individual's knowledge since it is his/her mother tongue. It is only a try.
yours
dr.s.raghunathan
Re: Reserved words Location [message #402226 is a reply to message #402217] Fri, 08 May 2009 02:27 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
No, I disagree.
SQL, as most computer-languages, is NOT a spoken language. It is a structured language.
If you think it is hard for someone to remember the keywords or the structure, they are obviously not fit to use it. What makes you think that they can remember the one single word you use as a replacement for select?
Why would it be "SELECT" and not "PICK" or "RETURN" or "GIVE"?

Provide these people with more graphical tools like Discoverer.
Re: Reserved words Location [message #402259 is a reply to message #402226] Fri, 08 May 2009 04:19 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
Frank,

I agree with your views. Still i have one experience. I trained the school drop out who is not good in english, taught him SQL using the local language to understand the concepts. As far as hisself regexp_ etc is nothing but a symbal or graphical representation. that's all. But now he is real expert on writing PL/SQL procedures / cursors and developing various application itself. He was familar with tamil typewriting and exactly he used the tamil data for storing and comparison. His learning curve was very excellent. Though i have mentioned 'edu' it is not a english word equated with tamil word. If you need some of the table created in tamil, i shall attach it as jpg file. When i happen to see the some other topic talked about character set,
a flash occured for asking translation to command reserve word. That's all. Ofcourse, most parts of india is using only english data and not varnacular one.
yours
dr.s.raghunathan

Previous Topic: Deleting records from a table which is having 60 million records
Next Topic: Oracle_XML
Goto Forum:
  


Current Time: Fri Dec 09 19:17:03 CST 2016

Total time taken to generate the page: 0.11277 seconds