Hello,
I am not writting a question here; just my view to add a new feature in oracle next releases named (ORAFOX) i.e. "Foxpro Features". What i feel that if there some/all feature like foxpro, is incorporates in oracle, it will definately catch the big user base of foxpro to oracle. Since i had used foxpro for last 5-7 years and oracle using 3+ years; if i get the foxpro feature like
1. easy interface to deal with data (Browse) command,
2. easy feature to change table structure (modify structure) command,
3. easy and fast command to merge/insert the data of two table (append [from]) command,
4. set deleted on/off command; by which we can process on those rows which have marked for deleted,
5. so many different and easy commands like copy structure to new.dbf with cdx, copy indexes, locate, seek and many more programming commands by which we can perform a "job".
I know that foxpro is a simple file based database software, but it is having so many user friendly and easy GUI based features, programming environment; which if oracle thinks for adopt; i hope it will be more helpful to oracle community. How do i dream like :
SQL>show user; -- Scott
SQL>exec dbms.orafox;
So, for this schema, all the tables will be worked same as oracle as well as foxpro. After executing dbms.orafox; there will be a status bar appeared (like set status on in foxpro).
Something like below :
SQL>use mytable; --below is how status bar will looks like
=========================================================================================
TEST |PID |SCHEMA NAME|MYTABLE |EXCLUSIVE |REC: 1/5 |INS|NUMCAPS
=========================================================================================
SQL>browse field col1,col2; -- a window will come with col1 and col2 to manipulate the data
SQL>select * from scott.emp;
SQL>use newtable@prod; -- here prod may be database or a db link.
=========================================================================================
PROD |PID |SCHEMA NAME|NEWTABLE|EXCLUSIVE |REC: 1/5 |INS|NUMCAPS
=========================================================================================
SQL>modi comm myprg; -- a window will come same like foxpro
SQL>do myprg; -- it will process the commands which have written in myprg.prg. I mean interaction of foxpro compiler with with oracle binaries.
There are so many small data processing companies, which are doing telephone bill processing, water supply billing, student result processing etc. are using only and only foxpro or maximum access/excel. What i feel that if there are similar kind of features exists in oracle; then definately oracle will catch more user base.
Some people will think that i am saying "put old wine in a new bottle", no its not like that, it is "put old wine's merit in a new bottle".
Kindly post your views and replies to make oracle more user friendly.
Regards
Girish Sharma