Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
No Answer is Posted For this Question
Be the First to Post Answer
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
Explain oracle’s system global area (sga).
Explain self joins in oracle?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Differnce between view and index
how to handle exceptions in post production
What is the difference between substr & instr functions?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
WHAT IS ecc 6.0
What is Data Dictionary Cache in Oracle?
What is oracle server autotrace in oracle?
what is a cartition product?