问题描述
我是java新手,我已经安装了Oracle Database 11g Express Edition,还安装了sql developer。
I am new to java, i have installed Oracle Database 11g Express Edition, and also sql developer.
我引用了这个链接,但这是一些差异,
I have referenced this link How to create a new database after initally installing oracle database 11g Express Edition?, but this is some what differences,
我想知道,如何使用java创建新数据库并检索数据和显示数据。
I want to know, how to create new database and retrieve data and display data using java.
我想知道,就像php和phpmyadmin一样。而且我也对oracle文档感到困惑。
I want to know, like as php and phpmyadmin. And also i confused with oracle documentation.
请帮助我..提前致谢。
Please help me.. Thanks in advance.
推荐答案
在创建数据库之前,您必须创建一个可以连接到该数据库的用户来执行此操作:
Before you create a database, you must create a user who can be connected to that database, to do that :
connect system/password;
您在安装过程中输入的密码。
the password that you entered during the installation.
创建用户:
create user user1 identified by 'password';
并且还为该用户提供了创建表,视图等的一些权限。 。
and also to give this user some privileges for creating tables,views and so on . .
grant dba,resource, connect to user;
之后您必须通过输入以下内容连接到该用户:
after that you must connect to that user by typing this :
connect user1/password;
现在你可以创建表格,如下所示:
Now you can create tables, like this :
create table exemple(
id int primary key,
name varchar2(255)
);
这篇关于如何在oracle 11g快递版中创建新数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!