📄 exp_052.htm

📁 oracle　DBA的资料

💻 HTM

字号:

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>Ocp test </title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p><b><span style="font-size:22pt">Explaination 052: &nbsp;</span></b></p>

<span style="font-size:18pt">
	<p>
	his answer is correct: "Day" shows the day spelled out, "DD" shows the two-digit date, "Month" provides the month spelled out, "YYYY" shows the four-digit year. "FMDay" is special format mask to suppresses the extra spaces between the name of the day and the number of the date. <br>
	</p>

	<p>
	  Incorrect Answers <br>
	</p>

	<p>
	  A: This statement will return an error because of inappropriate usage of the TO_DATE() function. <br>
	</p>

	<p>
	  B: Incorrect format mask "DY" is used to show the number of the day. <br>
	</p>

	<p>
	  D: Incorrect format mask "DY" is used to show the name of the day and format mask "DDD" is used to show the number of the day. <br>
	</p>

	<p>
	  E: Incorrect format mask "DY" is used to show the name of the day and format mask "DDD" is used to show the number of the day. Also this statement will return an error because of inappropriate usage of the TO_DATE() function. <br>
	</p>

	<p>
	  OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 87-88 <br>
	</p>

	<p>
	  Chapter 2: Limiting, Sorting, and Manipulating Return Data
	</p>

</span>

</body>
</html>
<br>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -