select sum(1) from emp

how do u know the total no of rows in a table?

Question Posted / mohd akhtar

6 Answers
8855 Views
I also Faced
E-Mail Answers

Answer Posted / mohd akhtar

select sum(1) from emp

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

query optmization techniques and quwry analyser+projects+ppts

2369

What are the limitations of check constraint?

960

How to drop a stored procedure in oracle?

993

How to connect asp pages to oracle servers?

1001

What is sequence?

1004

> 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?

1979

What is oracle instant client?

969

What is bulk load in oracle?

1004

what is the difference between substr and instr function in oracle?

1033

How to install oracle database 10g xe?

962

What is the difference between formal parameters and actual parameters?

999

What are triggers in oracle?

974

How to use null as conditions in oracle?

998

What is program global area (pga) in oracle?

951

IS it possible to built the oracle database without setting the kernal parameters?

2268