2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
Answers were Sorted based on User's Feedback
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
Show code of a cursor for loop.
What are the types of functions in sql?
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 NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance
What is the difference between rollback and rollback to statements?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
What is sql and how does it work?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
what is a primary key? : Sql dba
What is the unique index?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what is innodb? : Sql dba