How does Oracle guarantee data integrity of data changes?

2345

What do you mean by cdb and pdb in oracle 12c?

1014

How do I limit the number of oracle database connections generated by weblogic server?

1018

How many file formats are supported to export data?

1152

What is raw datatype in oracle?

1067

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2911

How to create a new view in oracle?

1024

How to create a table in a specific tablespace?

925

What exactly do quotation marks around the table name do?

922

How to create a stored function in oracle?

1056

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3006

What is a partition in oracle?

1051

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2315

> 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?

1990

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1051