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 7512write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
3 8352ex: 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 5182take 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 12608have 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 14907Post New Zensar SQL PLSQL Interview Questions
Why Black Rock?
PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS
Is primary key clustered index?
Are you smart?
How to create a base64 decoder in java8?
What is Generative AI, and how does it differ from traditional AI models?
Were you involved in any data conversion, which one?
sir/madam, i've applied for the post of section engineer. i shall highly be obliged if you could help me out with some sample papers.
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What are you passionate about?
What is current GDP of India?
Where did you travelled last time
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Please Provide me the link to download Testing Category questions and answers If some body has downloaded it pleae send it to me Pavan : Email pavan_cd@yahoo.com Quetion2 : Can any body Explain me about Testing thumb rules
HI..!! I THINK THIS SITE IS AN EXCELLENT SOURCE FOR YOUNG ENGINEERS, I READ THE POSTS REGARDING DIFFERENT PLACEMENT PAPERS IT WAS INDEED HELPUFL...BUT FRM WHR CAN I GET THE WHOLE APTITUTE PAPER FOR REFERENCE??