Which is better Oracle or MS SQL? Why?
Answers were Sorted based on User's Feedback
Answer / gangadhar mahabubabad
100% oracle is better..y because
sql sever is supported for windows o.s only
but oracle is supported for all operating systems...
|Is This Answer Correct ?||20 Yes||0 No|
Answer / sudipta santra
Apart from the Gangadhar's point, one important point is
that Oracle is the only RDBMS which follows the 9 out of 11
So Oracle is the ever best RDBMS till now.
|Is This Answer Correct ?||6 Yes||0 No|
Can anyone give me information about oracle certification
what is the difference between table and veiw?
how to store only time in a data base table
What does a Control file Contain ?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is an Extent ?
> 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?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the difference between SQL and SQL Server?
What would you use to improve performance on an insert statement that places millions of rows into that table?