I know that i can create a table without a primary key.But
is there any significance for that table???? while creating
an application.
Answer Posted / yadu
I think table should have atleast one Primary key column as
it may be joined with any other tables to retrieve some
conditional inforamtion for the application in RDBMS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a cognitive schema?
How many types of table in Oracle?
can u plz provide me oca sql dumps please i need them
How to load data from external tables to regular tables?
How to add a new column to an existing table in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How to export data to a csv file?
List the parts of a database trigger.
What is a nvl function?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are set operators?
What are the different types of partitions in oracle?
How to use attributes of the implicit cursor in oracle?
What is an oracle tablespace?
Explain oracle insert into command?