Oracle's fault!!

Oracle
This article is pure for discontent, complaint. As for the author of such doubts and dissatisfaction with Oracle software,
In fact, we can summarize some of the irregularities in Oracle, for Oracle learners to provide some reference.

1. Whether the settings of the Sqlplus environment variable are inherited to the new user environment when the current user is changed
Chaos, Serverout is not inherited, while pagesize is inherited.
2. command line editing in Sqlplus environment poor, look at ReadLine, look at MySQL
3. The command line for the Sqlplus environment does not have historical record capabilities to see MySQL. GDB, Bash
4. Naming conventions confused by a muddle. User_tab_columns, User_con_constraints
User_tables, Usre_cons_columns
5. Sqlplus the initialization document of the environment location requirements, see. BASHRC, VIMRC,. netrc
. Emacs,. Newsrc ... Touch a stronger than it, I'm going to use your login.sql still have to be in every
A current directory to get a copy, carry it? Fortunately this can be done through the SQLPATH environment
Variables are set to handle.
6. Annotation format:--, What the heck, HTML, perl with #, PHP with # or/**/or
, c with/**/, C + + with/**/and//, lisp with;;, assembly;, QBasic with REM and ',
Shell,sed,awk Use #, why do you have to create one yourself. I think it's a bird, compatible with others.
What's your identity, little girl?
7. Look at its pl/sql, known as the nth generation of high-level language, function because must return a value and
exist, I do not see any difference between it and other procedure. It's trigger again.
It's package again, procedure, and function, what the hell. Others are putting
Complexity of things to simplify, I think Oracle is going to complicate the simple things, the same is Pl/sql
Program, Dbms_output.put_line is designed to not output when called individually in a function.
It is not output until a procedure is invoked alone.
8. Single quotation mark problem, JavaScript can be compatible with single double quotes, Perl can, PHP can also, it
They can be because they want to be compatible, want to be friendly to the user, C language does not allow, that is because it rigorous.
It's very useful for others to keep them. You Oracle is not allowed to use double quotes and what is the original, let's hear it.
9. Other people's user interface design is "No news is the best news", or "no matter what happens,
To let the user know ", look at the variables under Sqlplus:
var i number;
i:=5;
Print I;
What do you see, nothing at all! What do you know from here, good news?
PS: I still do not know what this means? The value of I is null?, I can not be assigned below this value?
Can't assign value you say, you don't say how I know can't assign a value, although you have a good opinion to show
A blank line, but you still have to say ah, you really can not assign value? You're not really not worth it, are you?
...
PostScript: Fortunately, I know today to use
sql> exec:i: = 5;
Sql> print:i
But you can't let me dig three feet to find out these superficial things.
10. Under Sqlplus help set Look, find an option called set Severout[put] On|off
Note that it is severout, and you sqlplus under set severout on try,
Sp2-0158:unknown SET option "Severout"?
Set Serverout on
Yes, just one letter.
"There are bugs in any software," says the master programmer.
But is a bug so small that one of the world's second largest software companies will take it through several versions?
Oracle8.15 Oracle8.16 Oracle8.17 ... is the error reserved for compatibility?
PostScript: I finally see the oracle9i version of this has improved, a little relieved.