What is difference between sid and service name in oracle?

505

what is the difference between functional dependecy and multilevel dependency?

1977

In what script is snap$ created? In what script is the scott/tiger schema created?

2226

What is a relational database management system?

654

Explain drop constraint oracle?

578

Compare and contrast between sql and sql server and explain its various functions?

510

How does the on-delete-cascade statement work?

594

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

1552

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1795

What is the difference between substr and instr?

508

How to load a large xml file?

568

How to export your connection information to a file?

584

1) Does oracle have any table which contain all the exceptions and it's code internally?

1270

How to view the data files in the current database?

580

What privilege is needed for a user to delete rows from tables in another schema?

555