0

Problems

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
);
asked Sep 30, 2017 at 22:38
0

1 Answer 1

0

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

create table Inventory.Items
( ... );
answered Oct 1, 2017 at 0:52

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.