When do we use group by clause in a sql query?
No Answer is Posted For this Question
Be the First to Post Answer
Explain table?
How do we display rows from the table without duplicates?
What are synonyms used for ?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
How to use like conditions in oracle?
how to find out largest value in a table
How to use "if" statements on multiple conditions?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How many types of segments in Oracle?
what is the difference between simple view and complex view?