Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve first and last records from a table?
- 7 Answers
- 11917 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
Answer Posted / avnish srivastava-test engg fc
select* from employees where rowid=(select min(rowid) from
employees)
union
select* from employees where rowid=(select max(rowid) from
employees)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between translate and replace?
> 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?
Can we create trigger on materialized view in oracle?
How to convert raw data type into text in oracle? Explain
How to add a new column to an existing table in oracle?
How can we view last record added to a table?
Which environment variables are absolutely critical in order to run the OUI?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain about your project and its relation to the current job position you are applying to?
What is background process in Oracle?
What is blob data type in oracle?
What is bind variable in oracle 11g?
How to add a new column to an existing table with a default value?
Explain an exception?
What is BBED in Oracle?
