how many triggers we can create on a table
Answers were Sorted based on User's Feedback
Can a Tablespace hold objects from different Schemes ?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to recover a dropped table in oracle?
What is enter substitution variable in oracle?
What is the string concatenation operator in oracle?
How to display the hierarchy of employee and managers without using connect by prior.
How to create a stored program unit?
Can we create trigger on materialized view in oracle?
Please explain joins in oracle?
what is pragma?
Differentiate between TRUNCATE and DELETE?
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