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 7124write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
3 7950ex: 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 4942take 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 11849have 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 14093Post New Zensar SQL PLSQL Interview Questions
Is linux safer than windows?
What causes little rust pockets to pop through or off concrete cylinder blocks (home)?
What is devaluation and depreciation of currency?
If your expected value is ll0 and the standard deviation is l2, which of the following is true? A. There is approximately a 99 percent chance of completing this activity between 86 and 134 days. B. There is approximately a 68 percent chance of completing this activity between 98 and 122 days. C. There is approximately a 95 percent chance of completing this activity between 98 and 122 days. D. There is approximately a 75 percent chance of completing this activity between 86 and 134 days.
How do I use the thread pool?
What is testng and why is it better than junit?
How big is a gigabyte?
what are the integrations in netweaver?
How do you check data on pgadmin 4?
What are the different types of waits available in webdriver?
Explain the difference between abstract class and interface in java?
Tell us how you can create a static page with wordpress?
what is processor,what are the different processors available?
How do I insert blank rows in excel when values are changed?
Do threads share file descriptors?