How many clustered indexes can you have?
No Answer is Posted For this Question
Be the First to Post Answer
hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?
If a cursor is open, how can we find in a pl/sql block?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Can we create a trigger on view?
List different type of expressions with the example.
When sql appeared?
What is difference between function and trigger?
Why are cursors used?
Which one is faster ienumerable or iqueryable?
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
What are the datatypes available in pl/sql ?