新用户的创建、表的创建及增删改查(Oracle)

---------------------------------

--创建一个新用户

---------------------------------

createuserhahaya

identifiedbyhahaya

defaulttablespaceusers

temporarytablespacetemp;

---------------------------------

--给hahaya用户授权

---------------------------------

grantdba,sysdbatohahaya

withadminoption;

---------------------------------

--创建一个表

---------------------------------

createtablehahaya.book_book(

book_idintnotnull,

book_namevarchar2(200),

book_priceint,

primarykey(book_id)

);

-----------------------------------------------------

--向表中插入数据

--使用第二中方式的时候提供的值一定要和表的字段个数相等

------------------------------------------------------

insertintohahaya.book_book(book_id,book_name,book_price)values(1,'thinkinginc++',80);

insertintohahaya.book_bookvalues(2,'TheC++ProgrammingLanguage',100);

-------------------------------------------------------

--查询表中数据

-------------------------------------------------------

select*fromhahaya.book_book;

-------------------------------------------------------

--更改表中某行数据

-------------------------------------------------------

updatehahaya.book_booksetbook_price=90

wherebook_id=2;

select*fromhahaya.book_book;

-----------------------------------------------

--删除表中某行数据

-----------------------------------------------

deletefromhahaya.book_bookwherebook_id=2;

select*fromhahaya.book_book;