Click here to Skip to main content
15,568,300 members
Home / Discussions / Database
   

Database

 
AnswerRe: Error in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
mike1402125-Jun-17 22:53
mike1402125-Jun-17 22:53 
QuestionI need advice on storing application level encrypted data. Pin
Gilbert Consellado5-Jun-17 19:26
professionalGilbert Consellado5-Jun-17 19:26 
SuggestionRe: I need advice on storing application level encrypted data. Pin
Kornfeld Eliyahu Peter5-Jun-17 21:50
professionalKornfeld Eliyahu Peter5-Jun-17 21:50 
QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 23:30
karengsh3-Jun-17 23:30 
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 14:49
professionalMycroft Holmes4-Jun-17 14:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 21:41
karengsh4-Jun-17 21:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 21:58
professionalMycroft Holmes4-Jun-17 21:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 23:12
karengsh4-Jun-17 23:12 
OK. Tks.

Can I know if the ammended database schema is correct ?

SQL
Create table tutor(
id integer, auto_increment;
tutorName varchar(50), not null,
tutorNRIC varchar(50), not null, (Primary Key)
tutorEmail varchar(50), not null,
);


SQL
Create table subject(
id integer, auto_increment;
subject varchar950), not null;
subject_id, integer, not null, (Primary Key)
_;


SQL
Create table tutor_subject(
tutorNRIC integer,
subject_id integer,
Primary Key(tutorNRIC, subject_id),
Foreign Key(tutorNRIC) references tutor(tutorNRIC),
Foreign Key(subject_id) references subject(subject_id));

GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 13:05
professionalMycroft Holmes5-Jun-17 13:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 20:12
karengsh10-Jun-17 20:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 21:45
professionalMycroft Holmes10-Jun-17 21:45 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 18:38
karengsh11-Jun-17 18:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes12-Jun-17 0:39
professionalMycroft Holmes12-Jun-17 0:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 19:55
karengsh14-Jun-17 19:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 21:10
Mazahir Habib1-Jun-17 21:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 23:16
professionalJohn C Rayan1-Jun-17 23:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 23:25
professionalMycroft Holmes1-Jun-17 23:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 14:59
indian1431-Jun-17 14:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 2:18
mveRichard Deeming2-Jun-17 2:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 12:02
professionalRichard Andrew x6431-May-17 12:02 
AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 12:44
mveRichard Deeming31-May-17 12:44 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 14:05
professionalRichard Andrew x6431-May-17 14:05 
AnswerRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 14:01
professionalMycroft Holmes31-May-17 14:01 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 14:07
professionalRichard Andrew x6431-May-17 14:07 
GeneralRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 14:21
professionalMycroft Holmes31-May-17 14:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.