how can db_files > maxdatafiles since db_files is for
instance and the later is for database
No Answer is Posted For this Question
Be the First to Post Answer
am completed mca2011 how get certification in oracle
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
what are different types of deletes?
How many memory layers are in the shared pool?
How would you begin to troubleshoot an ORA-3113 error?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to check the oracle tns settings?
How to create an oracle database manually?
What are the Limitations of a CHECK Constraint ?
What is an oracle?
How can you Enforce Referential Integrity in snapshots ?
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