<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet href="http://pimg.daum-img.net/whsnake/css/atom.css?ver=1.0" type="text/css"?>
<feed xmlns="http://www.w3.org/2005/Atom" version="1.0" >
  <title>웹사</title>
  <link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn"/>
  <link rel="self" type="application/atom+xml" href="http://blog.daum.net/xml/atom/kbahn"/>
  <rights>안샘</rights>
  <author>
    <name>안샘</name>
    <uri>http://blog.daum.net/kbahn</uri>
  </author>
  <generator uri="http://blog.daum.net" version="1.0">Daum blog (blogmaster@daum.net)</generator>
  <id>tag:blog.daum.net,2009:kbahn</id>
  <updated>2009-02-23T10:54:28Z</updated>

  		<entry>
	    <title>금연25일차(금연의 장점)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/40"/>
		<id>tag:blog.daum.net,2009:kbahn.40</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-23T10:54:28Z</updated>
	    <published>2009-02-23T10:54:28Z</published>
	    <content type="html">
	    	&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot; align=justify&gt;&lt;img src=&quot;http://cfile212.uf.daum.net/image/1113F01649A1FE126643AA&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;259&quot; hspace=&quot;1&quot; width=&quot;259&quot; vspace=&quot;1&quot; border=&quot;0&quot; /&gt;&amp;nbsp; &lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;금연일기를 써 오면서 과연 얼마까지 쓸 수 있을까 하는 의구심이 들었다.&lt;/P&gt;
&lt;P&gt;한편으로는 25일차까지 쓰고 있는 내 자신이 뿌듯하다.&lt;/P&gt;
&lt;P&gt;앞으로 25일차를 넘어서 250일차를 쓰고 싶다. 희망사항일 수도 있지만. ^^&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;그래서 오늘은 금연을 25일동안 하면서 몸소 체험하게 된 금연의 장점에 대해서 말하고자 한다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;금연의 장점&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;1. 아침에 일어났을때 목이 전혀 아프지 않다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&amp;nbsp; &lt;/STRONG&gt;-아침에 일어날때 항상 목이 아팠는데 난 이것이 방이 건조하거나 원래 목을 많이 사용하는 직업이라서 그런 줄 알았다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 하지만 그 원인이 담배였다는 사실.. 담배를 안피우기 시작한 바로 그다음날 부터 목이 아프지 않았다. &lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;2. 현저하게 줄어든 가래.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp; -가래 또한 담배가 원인이었는줄 몰랐다. 그냥 비염이 약간 있는 편이라서 목에 한번씩 가래가 생긴다고 생각했는데..&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp; 이것또한 담배가 원인이었다니.. 금연 이후 거의 가래가 생기지 않았음.&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;3. 몸에 냄새가 나지 않는다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;- 몸과 입에 냄새가 나지 않는다.(이건 내 스스로 느끼는게 아니라 주위에서 말해줌).&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 홀애비 냄새와 재떨이 냄새로 부터의 탈출이다.ㅋ&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;4. 돈이 나갈일이 없다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;- 슈퍼에 가서 담배를 사면서 담배만 사는게 아니라 다른것도 살일 이 많기때문에 흡연자는 담배값만 나가는것이 아니라&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp; 부수적으로 돈이 더 나간다. 담배를 피우지 않게 되면 한달에 최소 10만원을 절약할 수 있다.&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;5. 몸이 가벼워지고 건강해진다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;6. 월요병이 많이 줄어든다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;- 난 월요병에 정말 많이 시달렷는데 담배를 피우지 않으니 월요일날 컨디션이 훨씬 좋다.&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;7. 뭐든지 할수 있다는 자신감이 생긴다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;- 평생 못할것 같던 금연을 성공하면 뭐든지 할 수 있다는 자신감이 생기며 중독에서 벗어날 수 있다는 쾌감을 맛보리라.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;8. 장시간 집중력은 금연을 햇을때 더욱 더 높아진다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;-금연을 하게 되면 집중력이 떨어진다는 잘못된 편견이 있는데...단시간 집중력은 흡연을 할때 높아지지만 장시간에 걸친 회의라던가 공부를 할때의 집중력은 금연을 했을 때 더 높아진다.&amp;nbsp;어차피 담배를 못피우니깐 지금 하고 있는일에 장시간 집중을 할 수가있다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;9. 오히려 스트레스가 줄어든다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;-&lt;/STRONG&gt;스트레스 해소용으로 담배를 즐겨피우던 사람들은 금연을 하게 되면 스트레스를 어떻게 해소 할까 싶어서 차마 담배를 못 끈는 경우가 있는데 내 경험으로는 담배를 안피우면 스트레스를 담아두지 않고 바로 바로 내뱉기 때문에 오히려 스트레스가 쌓이지 않는다. 이때 주위 사람들에겐 금단현상으로 신경질적이 되었다는 편견을 받기 싶지만 사실은 스트레스를 쌓아두는 것 보다는 그때 그때 대화를 통해서 내 뱉는게 상대편이나 나로써도 좋은것이다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;10. 아주 추운 날씨 아주 더운날씨에 밖에 나갈 필요가 없다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;- &lt;/STRONG&gt;요즘은 건물내에서는 거의 담배를 못 피우기 때문에 추운날씨에 떨면서 밖에서&amp;nbsp;담배를 안피워도 되며 또한&amp;nbsp;아파트 계단에서 담배를 피우다가 애기들의 손을 잡고&amp;nbsp; 엘레베이트에서 내리는 옆집 아주머니와의 무안한 대면을 안해도 된며 저 엘리베이트가 땡 소리를 내며 현재 층에 서지 않기를 간절히 바라지 않아도 된다. ^^&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;br&gt;&lt;br&gt;tag : &lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연일기&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연일기&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연비결&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연비결&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연의장점&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연의장점&lt;/a&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>iframe 가로스크롤바 안나오게 하기</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/39"/>
		<id>tag:blog.daum.net,2009:kbahn.39</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-17T14:05:27Z</updated>
	    <published>2009-02-17T14:05:27Z</published>
	    <content type="html">
	    	&lt;P&gt;iframe의 size보다 테이블의 size가 작은데도 가로 스크롤바가 나오는 경우는&lt;/P&gt;
&lt;P&gt;드림위버작업시 기본으로 제공되는 아래의 코드들 때문이다.&lt;/P&gt;
&lt;P&gt;따라서 아래의 코드를 없애주면 가로 스크롤바가 생기지 않는다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01//EN&quot; &quot;&lt;A href=&quot;http://www.w3.org/TR/html4/strict.dtd&quot; target=&quot;_blank&quot;&gt;http://www.w3.org/TR/html4/strict.dtd&lt;/A&gt;&quot;&gt;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>오라클 SQL Quiz 2</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/38"/>
		<id>tag:blog.daum.net,2009:kbahn.38</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-17T14:03:34Z</updated>
	    <published>2009-02-17T14:03:34Z</published>
	    <content type="html">
	    	&lt;P&gt; &lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;※ table은 오라클에서 기본으로 제공하는 &lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;EMP&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;테이블을 이용하며 아래쿼리 문제의 출력결과를 쓰시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS1&gt; &lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;A name=#7cac59bd&gt;&lt;/A&gt;&lt;/SPAN&gt;&amp;nbsp;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;A name=#7cac59bd&gt;&lt;/A&gt;&lt;IMG style=&quot;WIDTH: 610px; HEIGHT: 278px&quot; height=189 src=&quot;file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/Hnc/BinData/EMB00000d88275a.jpg&quot; width=401 border=0&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;1.select upper('webprogram') from dual;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;2. select round(sal,-2) from emp; &lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;HWP-TAB: 1&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style=&quot;HWP-TAB: 1&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 25px; COLOR: #000000; TEXT-INDENT: -25px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;3. select mod(100+10,5) from dual;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;4.select substr('webprogram class',instr('welcome to Oracle 10g','o'),3) from dual;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;5. select length(ltrim('aaaoracle 10gaaa','a')) f개m dual;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 25px; COLOR: #000000; TEXT-INDENT: -18px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;6.select ename from emp where substr(hiredate,1,2)=87;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/SPAN&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;7. select last_day(sysdate) from dual;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;8. &lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;select ename,deptno,decode(deptno, 10 , '서울',20,'대전',30,'대구',40,'부산') dname from emp;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;9. 1) select avg(nvl(comm,0)) from emp;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 2) select avg(comm) from emp;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;10. select ename,to_char(sal,'L999,999') from emp;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/SPAN&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>오라클 SQL Quiz 1</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/37"/>
		<id>tag:blog.daum.net,2009:kbahn.37</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-17T14:00:52Z</updated>
	    <published>2009-02-17T14:00:52Z</published>
	    <content type="html">
	    	&lt;P&gt; &lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;※ table은 오라클에서 기본으로 제공하는 &lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;EMP&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;테이블과&lt;/SPAN&gt;&amp;nbsp;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;DEPT&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;테이블을 이용할것.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;1. 사원번호가 7839 또는 7844 또는 7900인 사원의 이름,사원번호, 입사일을 검색하시오.(in연산자를 이용한 풀이와 or을 이용한 풀이 둘다를 쓰시오)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;1)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS1&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;2) &lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;2. &lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;연봉이 1500이상, 3000이하인 사원의 이름과 JOB을 검색하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;(between연산자와 and 연산자를 이용한 두가지 방법 모두 쓰시오)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;1)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;2)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS3&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;/SPAN&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;HWP-TAB: 1&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style=&quot;HWP-TAB: 1&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 25px; COLOR: #000000; TEXT-INDENT: -25px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;3. NEW YORK지점에 근무하고 있는 사원의 이름(ENAME)을 검색하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS4&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;4. 이름이 K로 시작하고 네자리인 사원의 이름,입사일,연봉을 검색하시오. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;5. 이름에 ‘A’가 포함된 사원의 이름,JOB을 검색하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 21px; COLOR: #000000; TEXT-INDENT: -14px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 25px; COLOR: #000000; TEXT-INDENT: -18px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;6. 이름에 ‘A'가 포함되지 않은 사원의 사원번호,이름을 검색하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 11px 0px 1px 25px; COLOR: #000000; TEXT-INDENT: -18px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 10pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 160%; FONT-FAMILY: '한컴바탕'; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10pt; COLOR: #000000; LINE-HEIGHT: 21px; FONT-FAMILY: '한컴바탕'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&amp;nbsp;&lt;A name=&quot;[문서의 처음]&quot;&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;7. EMP테이블에서 사원번호,사원이름,연봉을 검색하되 연봉이 높은 순서대로 검색하시오. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;8.&amp;nbsp; 위의 문제에서 연봉이 같은 사람이 존재할 경우에는 사원번호가 낮은 사람부터 정렬되게 하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 1px 19px; COLOR: #000000; TEXT-INDENT: -19px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 11pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;9. 사원중 커미션(COMM)을 받지 않는 사람의 이름,연봉을 검색하시오.(NULL 이용)&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;10. 연봉이 1500이상인 사원의 사원번호,이름,연봉,입사일을 구하되 먼저 입사한 순서대로 정렬하여 검색하시오.&lt;/SPAN&gt; &lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt; &lt;/P&gt;
&lt;P class=HS2&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px; COLOR: #000000; TEXT-INDENT: 0px; LINE-HEIGHT: 130%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.45pt; COLOR: #000000; LINE-HEIGHT: 19px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 0px 21px; COLOR: #000000; TEXT-INDENT: -21px; LINE-HEIGHT: 153%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;BR&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P style=&quot;FONT-SIZE: 11pt; MARGIN: 0px 0px 0px 21px; COLOR: #000000; TEXT-INDENT: -21px; LINE-HEIGHT: 153%; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&lt;SPAN style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 10.12pt; COLOR: #000000; LINE-HEIGHT: 22px; FONT-FAMILY: '돋움체'; LETTER-SPACING: 0px; TEXT-ALIGN: justify&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt; &lt;/P&gt;&lt;/SPAN&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연15일차(금연비결공개)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/36"/>
		<id>tag:blog.daum.net,2009:kbahn.36</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-14T08:31:38Z</updated>
	    <published>2009-02-14T08:31:38Z</published>
	    <content type="html">
	    	&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile210.uf.daum.net/image/142B7614499B49A214B870&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: both; FLOAT: left; MARGIN-RIGHT: 8px&quot; actualwidth=&quot;259&quot; width=&quot;259&quot; /&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 현재 금연15일차에 접어들었다&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;아직 금연 햇병아리에 불구하지만 20년간 담배를 피우면서 &lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp; 단하루도 담배를 안피운적이 없는 나로서는&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;그저 뿌듯할 따름이다. ^^&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp; &amp;nbsp;그래서 금연을 희망하는 다른 모든 이들에게 &lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 내가 해왔던 몇가지 방법을 소개하고자 한다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;내가 해왔던 금연 비결 10가지&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: center&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1. 안피운다고&amp;nbsp;생각하지 말고&amp;nbsp; 못피운다고 생각하라.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;2. 오히려 담배와 함께 했던 음식을 가까이 하라.(커피등) - 이열치열의 효과가 있다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;3. 니코틴 패치 및 금연초등은 절대&amp;nbsp;사용하지 마라. - 오히려 담배가 더 피우고 싶다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;4. 정말 급하고 흡연욕구가 일어날 때에는&amp;nbsp;파이프(보건소금연교실가면 무료로 제공함)를 사용하라.(술자리에는 필수로 파이프 지참)&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;5. 금연을 시작하면서 계속 담배의 해로운점을 인터넷에서 검색하여 읽고 또 읽어 거의 외우다 시피 하라.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;6. 스트레스는 일상에서 하루에 한번이상은 찾아오는 당연한것이라 생각하라.(스트레스로 인해 담배를&amp;nbsp; 피운다는것은 핑계라고 생각하라)&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;7. 전자오락에서 기록을 깨어가는 짜릿함과 같은 마음으로&amp;nbsp;금연일수를 늘여가면서 기록을 달성하는 쾌감을 맛보라.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;8. 1차 목표기일을 반드시 정하라.(내 같은 경우는 4주이다.) - 아무리 힘들어도 목표 기간만큼은 지킨다는 각오로.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;9. 처음에는 주변에 알리지 말고 조용히 시작하고 금연 5일차가 넘어가면 주변에 활발히 알려라.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;10. 오히려 흡연자들과 가까이 하라. (흡연의 분위기를 피하지 말고 정면 대응하여야&amp;nbsp;하며 흡연에서 자연스럽게 멀어져가야 한다.)&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;br&gt;&lt;br&gt;tag : &lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연일기&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연일기&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연비결&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연비결&lt;/a&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연11일차(술자리참석)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/35"/>
		<id>tag:blog.daum.net,2009:kbahn.35</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-14T08:14:00Z</updated>
	    <published>2009-02-14T08:14:00Z</published>
	    <content type="html">
	    	&lt;P&gt;오늘은 2월 9일 월요일 금연 11일차에 접어든다.&lt;/P&gt;
&lt;P&gt;내가 내자신을 &amp;nbsp;생각해도 뿌듯하다.&lt;/P&gt;
&lt;P&gt;이제 주말엔 가뿐하게 담배의 유혹을 뿌리칠수 있다.&lt;/P&gt;
&lt;P&gt;오늘은 금연을 시작한지 처음으로 술자리에 참석햇었다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;결론은 한대도 안피웠다.&lt;/P&gt;
&lt;P&gt;술자리에서는 필히 도구를 사용해야 될것 같다. &lt;/P&gt;
&lt;P&gt;난 금연보조제나 껌 및 사탕등은 전혀 사용하지 않고 금연을 하고 있다.&lt;/P&gt;
&lt;P&gt;오로지 사용하고 있는것은 예전에 금연교실 인원채우러 갔다가 받아온 박하향 나는 담배파이프이다.&lt;/P&gt;
&lt;P&gt;술자리에서 참을수 없는 흡연의 욕구가 세번정도 일어났지만&amp;nbsp;다른사람들의 담배연기를 벗삼아 나는&lt;/P&gt;
&lt;P&gt;파이프를 물었다. ㅋ&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;암튼 역사적인 날이다. 술자리에서도 담배를 참았으니. 앞으로 며칠간은 금연에 대한 탄탄 대로가 펼쳐질것으로 기대해본다.&amp;nbsp; &lt;/P&gt;&lt;br&gt;&lt;br&gt;tag : &lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=담배&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;담배&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=술&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;술&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=술자리&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;술자리&lt;/a&gt;,&amp;nbsp;&lt;a href=&quot;/_blog/tagArticleList.do?BLOGID=0NCyf&amp;amp;tagName=금연일기&quot; rel=&quot;tag&quot; target=&quot;_blank&quot;&gt;금연일기&lt;/a&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연6일차</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/34"/>
		<id>tag:blog.daum.net,2009:kbahn.34</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-12T13:35:42Z</updated>
	    <published>2009-02-12T13:35:42Z</published>
	    <content type="html">
	    	&lt;P&gt;금연하기전에는 식후,커피마신후 이 두경우가 담배를 참기 가장 어려울것이라 생각했는데&lt;/P&gt;
&lt;P&gt;실제로 금연 6일차에서 생각해보니 &lt;/P&gt;
&lt;P&gt;식후와 커피마신후에는 담배를 잘 참을수 있었다.&lt;/P&gt;
&lt;P&gt;오히려 커피는 담배를 대신해서 담배를 안피울수 있도록 도와주는 역할까지도 한다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;현재 시점에서 흡연욕구를 가장참기 힘든 베스트3&lt;/P&gt;
&lt;P&gt;1. 강의를 마친 바로 후.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; (지금까지 항상 강의하고 난 다음 담배를 한대씩 물었기에 그 허한 마음을 달랠길 없다오!)&lt;/P&gt;
&lt;P&gt;2. 얼토당토한 일이나 억울한일을 당했을때&lt;/P&gt;
&lt;P&gt;3. 잔잔한 스트레스가 찾아올때..&lt;/P&gt;
&lt;P&gt;4. 아직 술자리는 안가봤기에 술자리에서는 아직 경험이 없음. (추후 술자리에 참석한후 다시 베스트 3 발표예정)&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연5일차(2월3일)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/33"/>
		<id>tag:blog.daum.net,2009:kbahn.33</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-12T13:31:13Z</updated>
	    <published>2009-02-12T13:31:13Z</published>
	    <content type="html">
	    	&lt;P&gt;최대의 고비인 월요일을 넘기고 나니 화요일은 되려 금연에 대한 자신감이 생김.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;금단증상&lt;/P&gt;
&lt;P&gt;1. 오히려 기분이 좋아짐. &lt;/P&gt;
&lt;P&gt;2. 담배를 피울때보다 스트레스가 오히려 줄어듬.&lt;/P&gt;
&lt;P&gt;3. 모든사람과 만나면 담배얘기밖에 안함.(얘기라도 함으로써 담배에 대한 추억을 떠올림)&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연4일차(최대고비)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/32"/>
		<id>tag:blog.daum.net,2009:kbahn.32</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-12T13:29:29Z</updated>
	    <published>2009-02-12T13:29:29Z</published>
	    <content type="html">
	    	&lt;P&gt;오늘은 월요일&lt;/P&gt;
&lt;P&gt;월요일은 회의3종세트가 기다리는 날이다.&lt;/P&gt;
&lt;P&gt;아침 간부회의 및 직원회의와 저녁 간부회의 참여.&lt;/P&gt;
&lt;P&gt;원래 회의를 하면 스트레스를 많이 받는봐 아침부터 최대의 고비일것이다라고 &lt;/P&gt;
&lt;P&gt;굳은 결심을 미리 하고 왔기에 견딜수 있었다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;금단증상&lt;/P&gt;
&lt;P&gt;1. 스트레스로 인하여 정말 1-2번 피울뻔했음.&lt;/P&gt;
&lt;P&gt;2. 전자오락으로 치면 가장 힘든 단계라 생각하고 이 고비를 넘겨야 금연할수 있다고 굳게굳게 생각함.&lt;/P&gt;
&lt;P&gt;3. 오늘 하루가 정말정말 길었다.&lt;/P&gt;
&lt;P&gt;4. 스트레스를 받았을때 담배가 아닌 다른 방법으로 푸는 방법을 연구해야겠다는 생각을 함.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연3일차</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/31"/>
		<id>tag:blog.daum.net,2009:kbahn.31</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-12T13:26:17Z</updated>
	    <published>2009-02-12T13:26:17Z</published>
	    <content type="html">
	    	&lt;P&gt;일요일&lt;/P&gt;
&lt;P&gt;하루종일 집에 있었기에 오늘 하루도 더 성공할 수 있었다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;[금단증상]&lt;/P&gt;
&lt;P&gt;1. 가래가 점점 없어진다는 느낌.&lt;/P&gt;
&lt;P&gt;2. 아침에 일어나서 목이 쐐한 느낌이 없다.&lt;/P&gt;
&lt;P&gt;3. 새벽에 벌떡벌떡 깬다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>금연 2일차</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/30"/>
		<id>tag:blog.daum.net,2009:kbahn.30</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-12T13:20:56Z</updated>
	    <published>2009-02-12T13:20:56Z</published>
	    <content type="html">
	    	&lt;P&gt;&amp;nbsp;토요일이라서 1시퇴근.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;오늘부터 하루종일 담배를 피우지 못한다. 오히려 토요일인게 다행이다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;집에서 보다는 직장에서 더 담배 생각이 나기에..&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;금단증상 &lt;/P&gt;
&lt;P&gt;1. 수시로 담배생각이 난다. 시도 때도 없이. &lt;/P&gt;
&lt;P&gt;2. 담배피우는 습관이 남아있다.(절대 반경1m내에 담배를 두어서는 안됨)&lt;/P&gt;
&lt;P&gt;3. 다른사람한테&amp;nbsp; 담배냄새가 나기 시작.&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>첫째날(1월30일)</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/29"/>
		<id>tag:blog.daum.net,2009:kbahn.29</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-06T10:58:45Z</updated>
	    <published>2009-02-06T10:58:45Z</published>
	    <content type="html">
	    	&lt;P&gt;오늘은 오전에 5개피의 담배를 피우고 2시에 마지막 담배를 피우다.&lt;/P&gt;
&lt;P&gt;그리고 수술후엔 밀려오는 출혈과 입안의 소독약의 냄새때문에 담배생각은 전혀 없음.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;1일차 금단증상&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;- 특별히 나타나는 금단증상은 없으며 몸이 가벼워진 느낌. &lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>D-3 예행연습</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/28"/>
		<id>tag:blog.daum.net,2009:kbahn.28</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-02-06T10:55:22Z</updated>
	    <published>2009-02-06T10:55:22Z</published>
	    <content type="html">
	    	&lt;P&gt;본의 아니게 너를 떠나 보내야 하는구나.&lt;/P&gt;
&lt;P&gt;미안하다. 20년간 함께한 친구여.&lt;/P&gt;
&lt;P&gt;슬플때나 기쁠때나 화날때나 언제나 나와 함께해준 친구같은 존재여~~&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1월 30일 임플란트 수술을 앞두고 3달간 담배를 못피우기에 1월27일 휴일을 틈타서 예행연습 실시&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;금연방법&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;전날 10시에 취침, 당일 10시에 기상 하여 벌써 12시간 금연. ^^&lt;/P&gt;
&lt;P&gt;눈떠서 5시간을 더 참은 결과 17시간 금연. &lt;/P&gt;
&lt;P&gt;하지만 습관이 무섭다고 주머니에 담배가 있었던게 실패 요인.&lt;/P&gt;
&lt;P&gt;차 시동걸고 대기중에 차밖에서 항상 피우던 습관을 못버리고 바로 주머니에서 담배를 꺼내 피우다. 헉~ &lt;/P&gt;
&lt;P&gt;금연 실패~&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>Querystring 방식으로 &quot;&amp;&quot; 엠프센드 문자 넘기기</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/27"/>
		<id>tag:blog.daum.net,2009:kbahn.27</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-01-20T15:54:11Z</updated>
	    <published>2009-01-20T15:54:11Z</published>
	    <content type="html">
	    	&lt;P&gt;&amp; 는 쿼리스트링으로 두가지 이상의 값을 넘길때 값과 값을 연결시켜주는 일종의 문법적인 기호로 사용된다.&lt;/P&gt;
&lt;P&gt;그래서 막상 &amp;(엠프센드) 문자가 값에 포함되면 그것이 문법적인 기호로 인식이 되어버려서 그 이후의 값은 넘겨지지 않는다.&lt;/P&gt;
&lt;P&gt;이때 다음과 같이 하면 &amp; 문자를 넘길수가 있다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;현재 curriculum이라는 변수에 &quot;오피스&amp;전산실무&quot;라는 문자가 들어가 있다고 가정하고&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;넘길때는 &lt;STRONG&gt;test.asp?curriculum=&lt;%=replace(curriculum,&quot;&amp;&quot;,&quot;-&quot;)%&gt;&amp;teacher=&lt;%=teacher%&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;즉 replace함수를 이용하여 &amp; 문자를 특정문자 &quot;-&quot;등으로 변환시킨후 &lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;값을 받을때는 다시 replace 함수를 이용하여 &amp;문자로 변환시킨다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;curriculum=replace(request(&quot;curriculum&quot;),&quot;-&quot;,&quot;&amp;&quot;)&lt;/STRONG&gt;&lt;/P&gt;
	    </content>
	    	</entry>
    	<entry>
	    <title>Oracle 10g express 설치 및 접속</title>
		<link rel="alternate" type="text/html" href="http://blog.daum.net/kbahn/26"/>
		<id>tag:blog.daum.net,2009:kbahn.26</id>
	    <author>
		    <name>안샘</name>
	    </author>
	    <updated>2009-01-16T16:07:16Z</updated>
	    <published>2009-01-16T16:07:16Z</published>
	    <content type="html">
	    	&lt;P&gt;오라클 10g express는 오라클에서 제공하는&amp;nbsp;무료공개 소프트웨어의 일종이다.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1.&amp;nbsp;프로그램 다운받기&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;A href=&quot;http://www.oracle.co.kr/&quot; target=_blank&gt;&lt;STRONG&gt;http://www.oracle.co.kr&lt;/STRONG&gt;&lt;/A&gt;&lt;STRONG&gt; 접속 하여 먼저 회원가입을 한다&lt;/STRONG&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: center&quot;&gt;&lt;img src=&quot;http://cfile208.uf.daum.net/image/110D420D49702E2D5E54F9&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;681&quot; width=&quot;681&quot; /&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;2. 로그인 후 우측에 모든다운로드 보기 클릭&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile218.uf.daum.net/image/154E430E49702ED58F54B6&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;464&quot; width=&quot;464&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;3.&amp;nbsp; 아래그림의 표시부분 클릭 &lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile228.uf.daum.net/image/154AD21049703030922F4F&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;574&quot; width=&quot;574&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;4. 아래그림의 표시부분 클릭&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile220.uf.daum.net/image/114AD21049703030935CFC&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;633&quot; width=&quot;633&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;5. 윈도우 및 리눅스 버젼 선택&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile221.uf.daum.net/image/124AD21049703030941465&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;435&quot; width=&quot;435&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;6. 아래그림의 한국어 사용가능 한 버전(그림표시부분을 클릭)을 다운로드 한다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile214.uf.daum.net/image/134AD2104970303095991B&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;753&quot; width=&quot;753&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;7. 프로그램 다운로드 후 설치과정은 어렵지 않으므로 생략.(단 중간에 암호를 입력하는 부분이 나오는데 반드시 기억하고 있어야 함)&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;8. 설치후&amp;nbsp;접속&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;시작&gt;모든프로그램에서 설치된 프로그램을 찾아서 SQL명령줄 실행을 실행한다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile222.uf.daum.net/image/1146A50F497031BD5E2898&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;456&quot; width=&quot;456&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;STRONG&gt;SQL plus 명령화면이 나오면 아래의 표시 명령어로 접속한다.&lt;/STRONG&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&lt;img src=&quot;http://cfile230.uf.daum.net/image/1246A50F497031BD5F2E36&quot; border=&quot;0&quot; hspace=&quot;1&quot; vspace=&quot;1&quot; class=&quot;tx-daum-image&quot; style=&quot;CLEAR: none; FLOAT: none&quot; actualwidth=&quot;655&quot; width=&quot;655&quot; /&gt;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: left&quot;&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: center&quot; align=left&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: center&quot; align=left&gt;&amp;nbsp;&lt;/P&gt;
&lt;P style=&quot;TEXT-ALIGN: center&quot; align=left&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
	    </content>
	    	</entry>
      </feed>
