How to retrieve values from data fields in record variables?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain what are synonyms used for?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is an external table?
What are the arithmetic operations?
Difference between the “verify” and “feedback” command?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to use select statement to count the number of rows in oracle?
Explain about the analyze command in oracle?