How to create a table in a specific tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
various types of joins
What is a package in oracle?
How to create a new oracle data file?
How do we switch from init.ora file to asp file?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How many data types are supported?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
What operating systems are supported by oracle database 10g xe?
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?
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
How to check the oracle tns settings?