oracle: create new database

用database configuration Assistant 引导创建数据库。

 

创建操作用户：

?

1 2 3 4 5 6 7 8 9 10 11

-- 别加双引号，否则，无法用 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;

　　

 

 

 

测试连接

 

创建表：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

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;

　　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95

# 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_Oracle       class SchoolInfo(object):     """     """     def __init__(self):         """         """         self.__idno=None         self.__schoolname=None         self.__schooltel=None        @property     def idno(self):         """         :return:         """         return self.__idno        @idno.setter     def idno(self,no:str):         """         :param no:         :return:         """         self.__idno=no        @property     def schoolname(self):         """         :return:         """         return self.__schoolname        @schoolname.setter     def schoolname(self,name:str):         """         :param name:         :return:         """         self.__schoolname=name        @property     def schooltel(self):         """         :return:         """         return self.__schooltel        @schooltel.setter     def 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=idno     info.schoolname=name     info.schooltel=tel     dt.append(info) print("****************") for dd in dt:     print(dd.idno,dd.schoolname,dd.schooltel)