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 6151write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
3 6722ex: 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 4180take 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 10014have 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 11993Post New Zensar SQL PLSQL Interview Questions
what is event bubbling and event capturing in javascript?
List some array functions in php?
You have two tables-the first table has data about the users and their friends, the second table has data about the users and the pages they have liked. Write an SQL query to make recommendations using pages that your friends liked. The query result should not recommend the pages that have already been liked by a user.
Explain me what is the main function of multiplexed address/data bus?
How do I select multiple tabs?
How pointer is represented in go?
What do you mean by value field groups? : co-pa
What exactly is cardiovascular disease, and what are the risk factors?
What does gnu stand for?
How can I automatically locate a programs configuration files in the same directory as the executable?
Some animals have colors for protection. Which are they?
How to connect to an InterBase database using the BDE API?
Is machine learning jobs in demand?
What is a meta title?
What are the categories of avl rotations?