Reserved words Location [message #402213] |
Fri, 08 May 2009 02:00  |
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   |
Frank
Messages: 7901 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   |
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   |
Frank
Messages: 7901 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  |
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
|
|
|