How to create database Inventory database and inside it table Items in sqlplus oracle 12c . Details

Im beginner on Oracle 12c release i setup oracle and i create database Inventory

Now how to add table items to database Inventory

i can create table but how to create it inside database Inventorty this actually what i need

Create table Items
itemno number(4) not null,
itemname varchar2(40) not null

1 Answer 1


You either login as user Inventory before running the DDL, or you create the table by specifying the Schema like

create table Inventory.Items
( ... );

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.