TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
LOGANATHAN V
NA
27
20.9k
oracle-can i create like this but showing error while run
Mar 12 2011 8:51 AM
create table form1
(empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(50),empdob date,empadd varchar2(200),empcom varchar2(15),empshare varchar2(10), empsdoj date, empedoj date,
constraint pkform1 primary key (empcid,empname,empid,empdgn));
create table deposit
(loanid varchar(25),openbal decimal(20,3),subcrp date, subamt decimal(20,3),totdep decimal(20,3),subamtint decimal(25,3),cumuint decimal(20,3),empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(25),
constraint pkedeposit primary key (loanid),
constraint fkform1 foreign key (empcid,empname,empid,empdgn) references form1);
create table sharecapital
(loanid varchar2(25),empedoj date,empshare varchar2(10),shareint decimal(20,3),loandt date,loandeduc varchar2(25),dividend decimal(25,3),sharetot decimal(25,3),empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(25),
constraint fkdep foreign key(loanid) references deposit(loanid)),
constraint fkscform1 foreign key (empcid,empname,empid,empdgn) references form1(empcid,empname,empid,empdgn));
showing error when i execute
sharecapital
table "missing or invalid option"
i dunno how to correct it.
Reply
Answers (
10
)
oracle & c# - How can I implement this kindly help me to do..
How to separate two functions in a query? Except this || ' -- '||.