Answer Posted / sabir_eram2009
I am planning to have a course in one of the Oracle
Application in which no logic & concept creation is there.
Please help me out with your valuable views.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Why oracle is used?
How to convert characters to numbers in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are the advantages of oracle 12c?
Can group functions be used in the order by clause in oracle?
Why we use bulk collect in oracle?
How to change system global area (sga) in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is meant by joins?
How to execute the package in oracle?
How to get a create statement for an existing table?
> 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 is truncate oracle?
How to delete all rows a table in oracle?
What is a server parameter file in oracle?