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 7160write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
3 7994ex: 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 4969take 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 11910have 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 14174Post New Zensar SQL PLSQL Interview Questions
When would you use a tuple?
What can you do if the expression contains more than one line?
How do I search for text in vi?
What is mapper in map reduce?
How can one copy a file into HDFS with a different block size to that of existing block size configuration?
What is difference between mvc and hmvc?
Explain the css box model and its different elements.
What is a thread pool and how are the threads within a thread pool managed?
What server versions of CVS are supported by Eclipse?
What is a clique?
How do I fix logonui exe in windows 10?
what is different when impergnated silica plates are used in separation of azo dyes using column chromatography?
VSS performance is extremely slow?
What are the cases when can you use different views for different requirements?
What are the parameters that we can pass through a stored procedure?