This article is pure complaints and complaints. One for the author's doubts and dissatisfaction with Oracle software,
I can actually summarize some irregularities in Oracle and provide some reference for Oracle learners..
1. Change whether the setting of the SQLPLUS environment variable is inherited to the new user environment, and Serverout is inherited.
2. SQLPLUS environment The command line editing function is weak, see Readline, see mysql
3. The command line of the SQLPLUS environment has no history to see mysql. GDB, BASH
4. Naming specification is confused. User_tab_columns, user_con_constraints user_tables, usre_cons_columns
5. Initialization of the SQLPlus environment, look at .bashrc, .vimrc, .Netrc .emacs, .newsrc ... Touch one is stronger than it, I want to use your login.sql is not available in every one Among the current directory, carry it with you? Fortunately, you can get it through the setting of the SQLPath environment variable.
6. Notes format: -, what is your own, HTML
, perl with # or / ** / or ///////////////, C / ** / and //, LISP ;;, compilation; QBASIC with REM and ', shell , SED, AWK with #, do you do it? Self-righteous birds, what you are compatible with others will be small.
7. Take a look at its PL / SQL, known as the senior language of the nth generation, because it is necessary to return a value, in addition to this, I can't see what is different from other procedure. It is Trigger, and it is Package, it is procedure, but function, what is Dongdong. Others are simplified, I see Oracle to complicate simple things, the same PL / SQL program, dbms_output.put_Line is designed It cannot be output when calling in Function. It will not be output separately when you want a procedure to use it separately.
8. Single quotes, JavaScript can be compatible with single-double quotes, Perl can, PHP can also, they can be because they want to be compatible, want to be friendly, C language is not allowed, that is because it is rigorous. People have big The field. Your Oracle is not allowed to use the double quotation.
9. Others' user interface design is "No news is the best news", or "no matter what happens, let the user know", look at the variables under SQLPLUS: VAR I Number; i: = 5; Print i; What do you see, nothing! You can know what this, good news? PS: I don't know what this explain? I can't assign a value below? Assassin you said, you don't say how I can't assign a value, although you can show an empty line, but you still have to say, can you really assign a value? You don't really assign a value? .. Postscript: Good, I know today, I have to use SQL> Exec: i: = 5; SQL> Print: i but never let me explore three feet to find these shallow things.
