What is oracle database 10g express edition?
No Answer is Posted For this Question
Be the First to Post Answer
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What is the use of aggregate functions in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a user role in oracle?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are operators in oracle?
How to execute a stored program unit?
> 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?
How to use regular expression in pattern match conditions in oracle?
what are steps for interface? where is exchange rate defined in which table?
What are a collation and state the different types of collation sensitivity?