Click here to Skip to main content
15,883,692 members
Home / Discussions / Database
   

Database

 
AnswerRe: DateTime value problem Pin
kubben29-Jun-07 1:57
kubben29-Jun-07 1:57 
Questioni Problem in Installing SQL7 localy Pin
Vimalsoft(Pty) Ltd28-Jun-07 22:18
professionalVimalsoft(Pty) Ltd28-Jun-07 22:18 
AnswerRe: i Problem in Installing SQL7 localy Pin
Dave Kreskowiak29-Jun-07 7:56
mveDave Kreskowiak29-Jun-07 7:56 
AnswerRe: i Problem in Installing SQL7 localy Pin
Mike Dimmick29-Jun-07 14:43
Mike Dimmick29-Jun-07 14:43 
Questionspace in-between search parameters Pin
acodman28-Jun-07 22:18
acodman28-Jun-07 22:18 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:36
Sgg24529-Jun-07 0:36 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:39
Sgg24529-Jun-07 0:39 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:10
NAKRAINC28-Jun-07 22:10 
QNO : 1
CREATE TABLE MEMBER_C_VIJAY(MEMBER_ID NUMBER(5) PRIMARY KEY,
ACC_OPEN_DATE DATE DEFAULT SYSDATE,
MAX_ALLOWED_BOOKS NUMBER(2) CHECK(MAX_ALLOWED_BOOKS<100),
PENALTY_AMOUNT NUMBER(7,2) CHECK(PENALTY_AMOUNT<=1000)
MEMBER_NAME CHAR(25));

QNO : 2
CREATE TABLE BOOK_C_VIJAY(BOOK_NO NUMBER(6) PRIMARY KEY,
BOOK_NAME VARCHAR2(30) NOT NULL, CATEGORY CHAR(10)
CHECK(CATEGORY='SCIENCE' OR CATEGORY='FICTION' OR CATEGORY='FICTION' OR CATEGORY='DATABASE' OR CATEGORY='RDBMS' OR CATEGORY='OTHERS'))

QNO : 3
CREATE TABLE ISSUE_C_VIJAY(LIB_ISSUE_ID NUMBER(10) PRIMARY KEY,
MEMBER_ID NUMBER(5) REFERENCES MEMBER_C_VIJAY(MEMBER_ID),
BOOK_NO NUMBER(6) REFERENCES BOOK_C_VIJAY(BOOK_NO),
ISSUE_DATE DATE,
RETURN_DATE DATE );

ALTER TABLE ISSUE_C_VIJAY ADD CONSTRAINT I CHECK(RETURN_DATE>ISSUE_DATE);


QNO : 4
ALTER TABLE BOOK_C_VIJAY ADD CONSTRAINT V CHECK(COST<2500);

QNO : 5


QNO : 6
ALTER TABLE ISSUE_C_VIJAY DISABLE CONSTRAINT I;

QNO : 7
CREATE VIEW Vijay AS( SELECT LIB_ISSUE_ID,BOOK_NAME,MEMBER_NAME,AUTHOR,ISSUE_DATE
FROM
BOOK_C_VIJAY B,MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE ((B.COST>500 AND B.COST<750) AND (B.CATEGORY='RDBMS' OR B.CATEGORY='DATABASE') AND
I.BOOK_NO=B.BOOK_NO AND I.MEMBER_ID=M.MEMBER_ID));

QNO : 8
CREATE VIEW VIJAY1 AS(SELECT BOOK_NAME FROM BOOK_C_VIJAY WHERE COST>500);

QNO : 9

QNO : 10
GeneralRe: NAKRA Pin
Pete O'Hanlon28-Jun-07 22:20
mvePete O'Hanlon28-Jun-07 22:20 
GeneralRe: NAKRA Pin
kubben29-Jun-07 1:53
kubben29-Jun-07 1:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:09
NAKRAINC28-Jun-07 22:09 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:08
NAKRAINC28-Jun-07 22:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:06
NAKRAINC28-Jun-07 22:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 21:51
hdv21228-Jun-07 21:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 0:06
originSH29-Jun-07 0:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 20:15
Sgg24528-Jun-07 20:15 
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 18:02
Member 387988128-Jun-07 18:02 
AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 20:24
Devkranth Kishore Vanja28-Jun-07 20:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 20:57
Member 387988128-Jun-07 20:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 3:34
Navneet Hegde29-Jun-07 3:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 8:17
martin_hughes28-Jun-07 8:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 9:09
kubben28-Jun-07 9:09 
AnswerRe: Paramaterized Queries vs. Stored Procedures [modified] Pin
Mike Dimmick28-Jun-07 9:22
Mike Dimmick28-Jun-07 9:22 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 1:34
martin_hughes29-Jun-07 1:34 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
originSH29-Jun-07 0:11
originSH29-Jun-07 0:11 

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.