What happens if the imported table already exists?
- 0 Answers
- 539 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to find out what oracle odbc drivers are installed?
What is difference between SQL and SQL*PLUS?
What happens if the imported table already exists?
> 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?
What do you understand by a database object? Can you list a few of them?
how to get last monday of a month?
26. Display the earliest shipping date in the format: DD/MON/YYYY
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How do you store pictures in a database?
How will you differentiate between varchar & varchar2?
what is primary key and foreign key when and where have to use
How to set up autotrace for a user account?
Oracle General 
