剑气凌人 » blog archive » 精妙的sql语句.mht

Sql对oracle数据库的基本语句

	LIST-STYLE-TYPE: none
}
H1 {
	FONT-SIZE: 1.4em
}
CODE {
	BORDER-RIGHT: #f0f0f0 1px solid; PADDING-RIGHT: 10px; BORDER-TOP: =
#f0f0f0 1px solid; DISPLAY: block; PADDING-LEFT: 10px; BACKGROUND: =
url(img/bgcode.gif); MARGIN-BOTTOM: 12px; PADDING-BOTTOM: 8px; FONT: =
1.1em "Lucida Sans Unicode",serif; BORDER-LEFT: #f06 6px solid; COLOR: =
#444; PADDING-TOP: 8px; BORDER-BOTTOM: #f0f0f0 1px solid; WHITE-SPACE: =
pre
}
BLOCKQUOTE {
	PADDING-RIGHT: 12px; BORDER-TOP: #eed 1px solid; DISPLAY: block; =
PADDING-LEFT: 12px; BACKGROUND: #fbfcf5; MARGIN-BOTTOM: 12px; =
PADDING-BOTTOM: 12px; FONT: 12px Verdana,sans-serif; COLOR: #444; =
PADDING-TOP: 12px; BORDER-BOTTOM: #eed 1px solid
}
H1 {
	FONT: 1.2em "Trebuchet MS",sans-serif; COLOR: #f06
}
H2 {
	FONT: 1.2em "Trebuchet MS",sans-serif; COLOR: #f06
}
H3 {
	FONT: 1.2em "Trebuchet MS",sans-serif; COLOR: #f06
}
H4 {
	FONT: 1.2em "Trebuchet MS",sans-serif; COLOR: #f06
}
.clearer {
	CLEAR: both
}
.header {
	BACKGROUND: url(img/stripes.gif) no-repeat; MARGIN-BOTTOM: 24px; =
BORDER-BOTTOM: #eee 1px solid; HEIGHT: 160px
}
.header H1 {
	MARGIN-TOP: 40px; FONT: 4em sans-serif; COLOR: #222; TEXT-ALIGN: center
}
.header H1 A {
	COLOR: #222; TEXT-DECORATION: none
}
.header H1 A:visited {
	COLOR: #222; TEXT-DECORATION: none
}
.header H2 {
	BORDER-TOP: #eee 1px solid; COLOR: #666; TEXT-ALIGN: right
}
.header H2 SPAN {
	PADDING-RIGHT: 6px; PADDING-LEFT: 6px; BACKGROUND: #222; =
PADDING-BOTTOM: 0px; COLOR: #eee; PADDING-TOP: 0px
}
.left {
	MARGIN: 0px 42% 20px 3%
}
.content .descr {
	FONT-SIZE: 1.2em; MARGIN-BOTTOM: 6px; COLOR: #06f
}
.descr A {
	COLOR: #06f
}
.descr A:visited {
	COLOR: #06f
}
.content LI {
	LIST-STYLE-IMAGE: url(img/li.gif); MARGIN-LEFT: 18px
}
.content H1 {
	FONT-WEIGHT: bold; FONT-SIZE: 1.8em; MARGIN-BOTTOM: 4px
}
.content .entry {
	LINE-HEIGHT: 1.8em
}
.content P {
	FONT-SIZE: 12px
}
.content A {
	COLOR: #f06; TEXT-DECORATION: none
}
.footer A {
	COLOR: #f06; TEXT-DECORATION: none
}
.content A:hover {
	COLOR: #444; BORDER-BOTTOM: #f06 1px solid
}
.footer A:hover {
	COLOR: #444; BORDER-BOTTOM: #f06 1px solid
}
.nav {
	MARGIN-BOTTOM: 20px; POSITION: absolute; TOP: 40px
}
.right {
	MARGIN-BOTTOM: 20px; POSITION: absolute; TOP: 40px
}
.nav {
	RIGHT: 23%; WIDTH: 17%; TEXT-ALIGN: center
}
.nav .logo {
	BORDER-TOP: #eee 1px solid; BACKGROUND: url(img/logo.gif) no-repeat =
center top; BORDER-BOTTOM: #eee 1px solid; HEIGHT: 159px
}
.nav H1 {
	MARGIN: 12px 0px; COLOR: #f60
}
.nav LI {
	BORDER-BOTTOM: #eee 1px solid
}
.nav LI A {
	PADDING-RIGHT: 0px; DISPLAY: block; PADDING-LEFT: 0px; PADDING-BOTTOM: =
8px; FONT: 1.4em serif; COLOR: #888; PADDING-TOP: 8px
}
.nav LI A:hover {
	BACKGROUND: #fafafa; COLOR: #f06
}
.right {
	RIGHT: 3%; BACKGROUND: #222; WIDTH: 18%
}
.subnav {
	PADDING-RIGHT: 12px; PADDING-LEFT: 12px; PADDING-BOTTOM: 0px; =
PADDING-TOP: 12px
}
.subnav H1 {
	FONT-SIZE: 1.4em; MARGIN-LEFT: 8px; COLOR: #f06; HEIGHT: 20px
}
.subnav UL {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px =
0px 16px; PADDING-TOP: 0px
}
.subnav LI {
	MARGIN: 0px; BORDER-BOTTOM: #333 1px solid; LIST-STYLE-TYPE: none
}
.subnav H1 A {
	COLOR: #f06
}
.subnav LI A {
	PADDING-RIGHT: 6px; DISPLAY: block; PADDING-LEFT: 8px; FONT-SIZE: 12px; =
PADDING-BOTTOM: 3px; COLOR: #777; PADDING-TOP: 3px; TEXT-DECORATION: =
none
}
.subnav LI A:hover {
	COLOR: #ddd
}
.roundtl {
	BACKGROUND: url(img/round.gif); WIDTH: 14px; HEIGHT: 16px
}
.roundtr {
	BACKGROUND: url(img/round.gif); WIDTH: 14px; HEIGHT: 16px
}
.roundbl {
	BACKGROUND: url(img/round.gif); WIDTH: 14px; HEIGHT: 16px
}
.roundbr {
	BACKGROUND: url(img/round.gif); WIDTH: 14px; HEIGHT: 16px
}
.roundtl {
	FLOAT: left
}
.roundbl {
	FLOAT: left
}
.roundtr {
	FLOAT: right
}
.roundbr {
	FLOAT: right
}
.roundtr {
	BACKGROUND-POSITION: right top
}
.roundbr {
	BACKGROUND-POSITION: right bottom
}
.roundbl {
	BACKGROUND-POSITION: left bottom
}
.footer {
	PADDING-RIGHT: 6px; BORDER-TOP: #eee 1px solid; PADDING-LEFT: 6px; =
PADDING-BOTTOM: 8px; MARGIN: 0px 3%; FONT: 1em Verdana,sans-serif; =
COLOR: #666; PADDING-TOP: 8px
}
.post {
	MARGIN: 0px 0px 25px
}
.post .info {
	BORDER-RIGHT: #e3e4e4 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: =
#e3e4e4 1px solid; PADDING-LEFT: 8px; FONT-SIZE: 0.9em; PADDING-BOTTOM: =
3px; BORDER-LEFT: #e3e4e4 1px solid; COLOR: #505050; PADDING-TOP: 2px; =
BORDER-BOTTOM: #e3e4e4 1px solid; BACKGROUND-COLOR: #f5f5f5
}
#commentlist LI {
	MARGIN-BOTTOM: 1.5em; PADDING-BOTTOM: 1em; BORDER-BOTTOM: #700000 1px =
solid
}
#commentform {
	BACKGROUND: #ffffff; MARGIN: 1em 0px; WIDTH: 280px
}
#commentform TEXTAREA {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
BACKGROUND: #f8f7f6; BORDER-LEFT: #d6d3d3 1px solid; WIDTH: 280px; =
BORDER-BOTTOM: #d6d3d3 1px solid
}
#commentform TEXTAREA:hover {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
BACKGROUND: #ffffff; BORDER-LEFT: #d6d3d3 1px solid; BORDER-BOTTOM: =
#d6d3d3 1px solid
}
#commentform TEXTAREA:focus {
	BORDER-RIGHT: #939793 1px solid; BORDER-TOP: #939793 1px solid; =
BACKGROUND: #ffffff; BORDER-LEFT: #939793 1px solid; BORDER-BOTTOM: =
#939793 1px solid
}
#commentform #email {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
FONT-SIZE: 1.1em; BACKGROUND: #f8f7f6; BORDER-LEFT: #d6d3d3 1px solid; =
WIDTH: 280px; BORDER-BOTTOM: #d6d3d3 1px solid
}
#commentform #author {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
FONT-SIZE: 1.1em; BACKGROUND: #f8f7f6; BORDER-LEFT: #d6d3d3 1px solid; =
WIDTH: 280px; BORDER-BOTTOM: #d6d3d3 1px solid
}
#commentform #url {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
FONT-SIZE: 1.1em; BACKGROUND: #f8f7f6; BORDER-LEFT: #d6d3d3 1px solid; =
WIDTH: 280px; BORDER-BOTTOM: #d6d3d3 1px solid
}
#commentform #email:hover {
	BORDER-RIGHT: #d6d3d3 1px solid; BORDER-TOP: #d6d3d3 1px solid; =
FONT-SIZE: 1.1em; BACKGROUND: #ffffff; BORDER-LEFT: #d6d3d3 1px solid; =
WIDTH: 280px; BORDER-BOTTOM: #d6d3d3 1px solid
}
#commentform #author:hover {