Interested to Buy Any Domain ? << Click Here >> for more details...
display null value rows with out using null function?
- 8 Answers
- 10752 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / harinadh bolisetti
in case of integer data type column.
select * from emp
where nvl(deptno,1)=1
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
describe mysql connection using mysql binary. : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Is a table valued function object?
What is the reports view in oracle sql developer?
Explain how can you save or place your msg in a table?
How much does sql cost?
What is crud sql?
Can a trigger call a stored procedure?
Write the command to remove all players named sachin from the players table.
Why do we use %rowtype & %type in plsql?
How do I create a memory optimized filegroup?
What is schema in sql example?
What is scope of pl sql developer in future?
What is sql integrity?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
