how to find count rows in table without count function?
Answers were Sorted based on User's Feedback
Answer / rajender varma
Select num-rows from user-tables where table-name='emp'
Is This Answer Correct ? | 0 Yes | 0 No |
how to retrive xml data for using sql query?
what is data independence exactly? give an example
What privilege is needed for a user to create indexes in oracle?
Is there any function in oracle similar like group_concat of mysql?
why can't we assign not null constraint as table level constraint
What is columnar storage what is the advantage?
How many types of synonyms in Oracle?
What are the limitations oracle database 10g xe?
How do I spool to a csv formatted file using sqlplus?
What are the differences between primary key and unique key?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
what is the syntax of CREATE command?