oracle: create new database

用database configuration Assistant 引导创建数据库。记得给system,sys 设置自己的口令，便于添加新操作用户。

创建操作用户：

-- 别加双引号，否则，无法用
create user geovindu identified by 888888;
create user geovin identified by 888888;grant connect,resource,dba to geovindu;grant connect,resource,dba to geovin;grant create session,create table,unlimited tablespace to geovindu;
grant create session,create table,unlimited tablespace to geovin;

测试连接：

创建表：

drop table IF EXISTS GEOVINDU.School; create table GEOVINDU.School  --創建表
(SchoolId char(5) NOT NULL,  --  SchoolName varchar(500) NOT NULL,SchoolTelNo  varchar(8)  NULL,        PRIMARY KEY (SchoolId)   --#主鍵
);--对表的说明
comment on table GEOVINDU.School is '学校表';
--对表中列的说明
comment on column GEOVINDU.School.SchoolId is 'ID';
comment on column GEOVINDU.School.SchoolName is '名称';
comment on column GEOVINDU.School.SchoolTelNo is '电话号码';select * from GEOVINDU.School order by SchoolId;

# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：python -m pip install oracledb
# python -m pip install cx_Oracle --upgrade
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm Community Edition 2024.3 python 3.11
# OS        : windows 10
# Datetime  : 2024/12/23 20:33
# User      : geovindu
# Product   : PyCharm  Community
# Project   : ictsimple
# File      : oracledemo.py
# explain   : 学习import cx_Oracleclass SchoolInfo(object):""""""def __init__(self):""""""self.__idno=Noneself.__schoolname=Noneself.__schooltel=None@propertydef idno(self):""":return:"""return [e-mail] idno(self,no:str):""":param no::return:"""self.__idno=no@propertydef schoolname(self):""":return:"""return [e-mail] schoolname(self,name:str):""":param name::return:"""self.__schoolname=name@propertydef schooltel(self):""":return:"""return [e-mail] schooltel(self,tel:str):""":param city::return:"""self.__schooltel=tel# 连接到Oracle数据库 orcl.docker.internal
connection = cx_Oracle.connect(user="GEOVINDU", password="777777", dsn="localhost/TechnologyGame")
# 创建游标
cursor = connection.cursor()
# 执行查询 GEOVINDU.
cursor.execute("SELECT * FROM School order by SchoolId")
# 获取查询结果
result = cursor.fetchall()
dt=[]
# 打印查询结果
for idno,name,tel in result:#print(idno,name,tel)info=SchoolInfo()info.idno=idnoinfo.schoolname=nameinfo.schooltel=teldt.append(info)
print("****************")
for dd in dt:print(dd.idno,dd.schoolname,dd.schooltel)

输出：