1. List all the employees who have atleast one person reporting to them List the employee details if and... 2. What is the data type of the column of Dual table? 3. what is a reverse key index and it's real time usage 4. What are the privileges that view does not have as compared to normal table? 5. How to see the existing constraints in a table? 6. how do you generate prime numbers in sql not in plsql 7. What is Local Index and Global Index in Partition Table?What is Prefix Index and Nonprefix
1. what is a reverse key index and it's real time usage 2. Difference Between Hash Join & Merge Join 3. Difference between Optimizer=ALL_ROWS and Optimizer=CHOOSE 4. What is the meaning of cost, card, Bytes? 5. What is syntax for dropping a procedure and a function .Are these operations possible? 6. How you were passing cursor variables in PL/SQL 2.2? 7. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 8. What is use of a cursor variable? How
Latest Answer: Candidate key is a Unique Key and it can be used to find out any purticular Tuple(row) in a table..a Primary key is also a Candidate Key... But these are the diff..1)on a table we can have only 1 primary key but 'N' number of unique keys.2)Unique ...
I have a table with column name 'CallType' calltype contains 5 repeatable records like'Internal','Hang Up','Wrong Queue' how to get column vales in place of column namelike once i execute the query i should be able to see in this wayInternal, Hang up, Wrong queue, and so on 10 12 13 4 5 7--------------------------------- 14 17 20thanks in advance
Latest Answer: No, a table can have only one column of LONG datatype. If you try to create a table with more than one LONG column it will throgh an error saying that a table can have only one LONG type of coumn.Regards,Brajesh. ...
How to insert any data in table which contain single quote ('). Like "Father's Name" By Using SQL.
Latest Answer: To join a table itself is called self join. ...
Write a query that display the records based on condition. excluding the record that meets the condition Eg... Select all employees who has same salary as empno 20. My query should return all the rows excluding empno20.
How to insert records in the middle of the table? How to change the position of a column in the existing table or while creating a new column?
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
