What are inner join and outer join?3 8522
what are indexes..how many types of index's are there and what are they?7 12001
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?2 3195
For web applications from which version of Oracle is suitable?1 3208
What are the main diff. between oracle 7.3 and oracle 8i?1 3057
What is Statement Auditing ?2 2565
What are the use of Roles ?3 2881
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
what is reindexing?
Could you please let me know the interfaces in OM / FA??
> 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?
please explain.. DB architecture ...
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
What are joins, explain all types of joins?
query optmization techniques and quwry analyser+projects+ppts
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
IS it possible to built the oracle database without setting the kernal parameters?
Query to retrieve record for a many to many relationship ?
how the indexes are stored in the Oracle Database?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail firstname.lastname@example.org.
What are the package used in DBMS ?