oracle»ù´¡ÈëÃŽ̲Ä
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)]
....
[constraint primary_name
primary key(column_name1,column_name2...)
]
[unique(<column_name1,column_name2...>)]
);
create table <table_name>
as
select * from <other_table_name> where <condition>
---------------------------------------------------------------------------------------
¸Ä±í½á¹¹
1 alter table <table_name> add(column_name column_type);
2 alter table <table_name> modify(column_naem column_type);
---------------------------------------------------------------------------------------
ɾ±í
drop table <table_name>;
truncate table <table_name>;
---------------------------------------------------------------------------------------
±íµÄÖØÃüÃû
rename <table_name1> to <table_name2>;
---------------------------------------------------------------------------------------
²åÈëÊý¾Ý
1 insert into <table_name> (column_name1, column_name2, ....)
values (column_value1, column_value2,.... );
2 insert into <table_name>
values (column_value1, column_value2,.... );
3 insert into <table_name> (column_name1, column_name2, ....)
select expression1,expression2, ....
from <table_name>
[where <condition_expression>];
---------------------------------------------------------------------------------------
±íµ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......