Difference between pre-select and pre-query
No Answer is Posted For this Question
Be the First to Post Answer
How to assign query results to variables?
Is it possible to enter only time value into a column of a table in sql?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to get a list of all background sessions in the database?
How to display the hierarchy of employee and managers without using connect by prior.
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
What is system global area (sga) in oracle?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to start a new transaction in oracle?
How many categories of data types?
Can group functions be used in the order by clause in oracle?
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