Explain view?
No Answer is Posted For this Question
Be the First to Post Answer
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
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
What to do if dba lost the system password?
What is meant by recursive hints in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
Can a property clause itself be based on a property clause ?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is a data lock in oracle?
What is oracle data type?
Can objects of the same schema reside in different tablespace?