OracleÖеÄ5¸öÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçÌâ:
1.16½øÖÆÊýÔÚת»¯³É10½øÖÆÊýʱ³ö´í
SQL code:

SQL> select to_char(125,'xxxx') from dual;

TO_CHAR(125,'XXXX')
--------------------------------------------------------------------------------
7d

SQL> select to_char(7d,'xxx') from dual;

TO_CHAR(7.0E+000D,'XXX')
--------------------------------------------------------------------------------
7

SQL> select to_char(to_char(125,'xxxx'),'xxx') from dual;

select to_char(to_char(125,'xxxx'),'xxx') from dual

ORA-01722: ÎÞЧÊý×Ö


2.Ë÷Òý¸ß¶ÈÊÇʲôһ¸ö¸ÅÄî: pga_aggregate_target?
3.analyze index indexname validate structureÓÐʲôÓã¿--ÅжÏÊÇ·ñÐèÒªÖؽ¨Ë÷Òý?
4.ÒÔÏ´úÂëÔõÑù²ÅÄÜÊä³ö¡°Test successed!¡±
SQL code:

SQL> set serveroutput on;
SQL> create or replace and compile java source named test_java as
2 public class FirstJava{
3 public static void test(){
4 System.out.println("Test successed!");
5 }
6 };
7 /

Java created

SQL>
SQL> create or replace procedure test_java is
2 language java name 'FirstJava.test()';
3 /

Procedure created

SQL> exec hello;

PL/SQL procedure successfully completed



5.ÍâÁª½ÓÌá¸ß±íÁ¬½ÓµÄ²éѯËٶȣ¿

&nb