Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

oracle internal number Êý¾ÝÀàÐÍ´æ´¢

ת×Ô£ºhttp://ilonng.blog.sohu.com/130335741.html
   oracleµÄnumberÀàÐÍÊÇÒ»ÖÖÈí¼þÊý¾ÝÀàÐÍ£¬ÔÚoracleÈí¼þ±¾ÉíÖÐʵÏÖ£¬ÎÒÃDz»ÄÜʹÓùÌÓÐÓ²¼þ²Ù×÷½«Á½¸önumberÀàÐÍÏà¼Ó£¬ÕâÒªÔÚÈí¼þÖÐÄ£Ä⣬number ÀàÐ͵ÄÄÚ²¿±àÂëÊÇ2¡£oracle´æ´¢Ò»¸öÊýµÄʱ£¬»á´æ´¢¾¡¿ÉÄÜÉÙµÄÄÚÈÝÀ´±íʾÕâ¸öÊý£¬Îª´ËËü»á´æ´¢ÓÐЧÊý×Ö¡¢ÓÃÓÚÖ¸¶¨Ð¡ÊýµãλÖõÄÒ»¸öÖ¸Êý£¬ÒÔ¼°ÓйØÊýÖµ·ûºÅµÄÐÅÏ¢£¨Õý»òÕ߸º£©¡£Òò´Ë£¬ÊýÖаüº¬µÄÓÐЧÊý×ÖÔ½¶à£¬Õ¼ÓõĴ洢¿Õ¼ä¾ÍÔ½´ó¡£
    oracleµ×²ã´æ´¢numberÀàÐͲÉÓÃÏÂÃæµÄÕâÖÖÐÎʽ£º
sign bit/exponent,digit1,digit2,…,digit20
sign bit/exponentΪ±ê־룬digit1...digit20ΪÊýֵ룬¿É¼ûnumber×î¶àÕ¼¾Ý21¸ö×Ö½Ú¡£
    Ò»¸öÊýÊÇ¿ÉÒÔʹÓÿÆѧ¼ÆËã·¨À´ÕýÈ·±íʾµÄ£¬Èç10=1*power(10,1)£¬-101=-1.01*power(10,2)£¬0.2=2*power(10,-1)¡£oracle¾ÍÊÇͨ¹ýÕâ¸öÔ­ÀíÀ´´æ´¢Êý¾Ý£¬Ëü½«ÈκÎÒ»¸öËü¿ÉÒÔ±íʾµÄÊý¾Ýת»»³ÉÒ»¸ö·ûºÅλ¡¢Ò»¸öÖ¸Êý¡¢Ò»¸öÓÐЧÊýÀ´´æ´¢£¬¾Ù¸öÀý×Ó£¬123ÔÚoracleÖÐÊÇÕâÑùÀ´´æ´¢µÄ£¬+(1.23*power(100,1))£¬¼´ËüÊÇÒÔ100Ϊ¿Æѧ¼ÆËã·¨µÄÖ¸Êý»ùÊý£¬ÎªÊ²Ã´ÕâÑùÒÔ¼°ÔõôÀ´´æ´¢£¬Çë¿´ÏÂÃæ¡£
    ´æ´¢Ê ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns the row.
B. The nested query executes first and then the outer query executes.
C. The outer query executes only once for the result returned by the inner query.
D. Each row returned by the outer query is evaluated for the results returned by the inner query.
Answer: AD
2. View the Exhibit and examine the description of the EMPLOYEES table.
Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the
company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual
salary:
SELECT last_name, department_id, salary+50*12 "Annual Compensation"
from employees
WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/1 ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns the row.
B. The nested query executes first and then the outer query executes.
C. The outer query executes only once for the result returned by the inner query.
D. Each row returned by the outer query is evaluated for the results returned by the inner query.
Answer: AD
2. View the Exhibit and examine the description of the EMPLOYEES table.
Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the
company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual
salary:
SELECT last_name, department_id, salary+50*12 "Annual Compensation"
from employees
WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/1 ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns the row.
B. The nested query executes first and then the outer query executes.
C. The outer query executes only once for the result returned by the inner query.
D. Each row returned by the outer query is evaluated for the results returned by the inner query.
Answer: AD
2. View the Exhibit and examine the description of the EMPLOYEES table.
Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the
company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual
salary:
SELECT last_name, department_id, salary+50*12 "Annual Compensation"
from employees
WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/1 ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns the row.
B. The nested query executes first and then the outer query executes.
C. The outer query executes only once for the result returned by the inner query.
D. Each row returned by the outer query is evaluated for the results returned by the inner query.
Answer: AD
2. View the Exhibit and examine the description of the EMPLOYEES table.
Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the
company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual
salary:
SELECT last_name, department_id, salary+50*12 "Annual Compensation"
from employees
WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/1 ......

ORACLE 9I·þÎñÆ÷Æô¶¯ºÍ¹Ø±Õ

·þÎñÆ÷Æô¶¯µÄ¹ý³Ì
       OracleÊý¾Ý·þÎñÆ÷µÄ³£¹æÆô¶¯¹ý³Ì:
        1¡¢Æô¶¯TNS¼àÌý             C:\Documents and Settings\Administrator>lsnrctl start
        2¡¢Æô¶¯Oracle Services    C:\Documents and Settings\Administrator>net start OracleServiceOrcl
        ·þÎñÆ÷Æô¶¯µÄ8ÖÖ
        1¡¢startup nomount ·Ç°²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУºÖؽ¨¿ØÖÆÎļþ¡¢Öؽ¨Êý¾Ý¿â ¶ÁÈ¡init.oraÎļþ£¬Æô¶¯instance£¬¼´Æô¶¯SGAºÍºǫ́½ø³Ì£¬ÕâÖÖÆô¶¯Ö»ÐèÒªinit.oraÎļþ¡£
          2¡¢startup mount dbname °²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУº Êý¾Ý¿âÈÕÖ¾¹éµµ¡¢Êý¾Ý¿â½éÖʻָ´¡¢Ê¹Êý¾ÝÎļþÁª»ú»òÍÑ»ú£¬ ÖØж¨Î»Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡£Ö´ÐГnomount”£¬È»ºó´ò¿ª¿ØÖÆÎļþ£¬È·ÈÏÊý¾ÝÎļþºÍÁª»úÈÕÖ¾ÎļþµÄλÖ㬵«´Ëʱ²»¶ÔÊý¾ÝÎÄ ......
×ܼǼÊý:3994; ×ÜÒ³Êý:666; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2] [3] [4] [5] 6 [7] [8] [9] [10] [11]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ