What is scalar data type in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
Is nosql faster than sql?
How to run pl/sql statements in sql*plus?
What are aggregate functions in sql?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
What is sql lookup?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
how to include numeric values in sql statements? : Sql dba
Explain clause in sql?
How do you remove duplicates without using distinct in sql?
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
How does postgresql compare to oracle/db2/ms sql server/informix?