如何在oracle 11g快递版中创建新数据库？ [英] How to create new database in oracle 11g express edition?

问题描述

我是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.

我引用了这个链接如何在初始安装oracle数据库11g Express Edition后创建新数据库？ ，但这是一些差异，

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快递版中创建新数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！