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 6681ex: 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 4160take 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 9945suppose 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 6911how 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 6
4 8566Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
IBM,
13 15878i 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.....
8 9332
What does joining a thread mean?
How do I run a program in pl sql?
What is difference between my sql and sql?
How does sql developer connect to oracle database?
How to make a copy values from one column to another in sql?
What are sql ddl commands?
Name the different types of indexes in sql and define them.
What are the parts of a sql statement?
how to escape special characters in sql statements? : Sql dba
how many groups of data types? : Sql dba
What is rollback?
How many functions are there in sql?
How can I change database name in sql?
Why do we use partitions in sql?
What are triggers and its uses?