write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.3 5018
ex: 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 3301
how can stop the sequence with mention the max value and with out mention the max value1 4556
take 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 7636
suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?6 5371
how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 64 7033
Could you please provide oca (oracle 10g) dumps for my certification ?1 3811
Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
What are different types of refreshment techniques of materialised view2 6176
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....7 6769
write a query that returns first characters of each word in Oracel/Sql pl sql5 6727
What is crud diagram?
What is forward declaration in pl sql?
what is subquery? : Sql dba
What is sqlcontext?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What are analytic functions in sql?
How do you delete data from a table?
Does sqlite need a server?
Which table is left in join?
Explain select statements in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is pl/sql table? Why is it used?
Does a join table need a primary key?
Is full outer join same as cross join?
what is union, minus and interact commands? : Sql dba