How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra
2 7388write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
3 8258ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
1 5125take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
9 12430have 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.
8 14717Post New Zensar SQL PLSQL Interview Questions
What is HDFS - Hadoop Distributed File System?
How long does a system restore take?
Write a program using mergesort technique.
What is ipa?
List advantages and disadvantages of dynamic memory allocation vs. static memory allocation.?
How to delete an existing column in a table?
How do I change the default settings in powerpoint?
What is the difference between framework and cms?
description about dry type transformers
Can you explain about screen object?
What is meant by gain-bandwidth product? What is its significance?
What is gpa user functions?
What does passport and windows authentication mean in ASP.NET?
for linear polarisation antenna how do u measure polarisation?
Tell me have you ever had to negotiate in order to get your way when working in a group? : insurance health