How do we display rows from the table without duplicates?
No Answer is Posted For this Question
Be the First to Post Answer
How to define an explicit cursor in oracle?
How to count groups returned with the group by clause in oracle?
How to return top 5 rows in oracle?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Explain about your project and its relation to the current job position you are applying to?
Respected sir, Please send me technical questions related to oracle apps..
How to use regular expression in pattern match conditions in oracle?
Can a primary key contain more than one columns?
How to save query output to a local file?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is trigger associated with the timer ?