What are the attributes of the cursor?
What is truncate oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is recovery manager(rman) backup in Oracle?
How to select all columns of all rows from a table in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain an exception?
What is the minimum client footprint required to connect c# to an oracle database?
Give the constructs of a package, function or a procedure.
What is dynamic proxy?
can u call user defined functions in select statements
Can we create more than one constraint to column ?
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