Can we store pictures in the database and if so, how it can be done?
No Answer is Posted For this Question
Be the First to Post Answer
> 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 convert csv to table in oracle?
How to define an oracle cursor variable?
What is a snapshot in oracle database?
What is oracle update statement with inner join ?
What are the differences between interval year to month and interval day to second?
What are the differences between char and varchar2 in oracle?
Is it possible to disable the parameter from while running the report ?
What are the Limitations of a CHECK Constraint ?
What is a data dictionary and how can it be created?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
Differnce between view and index