wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
Answer Posted / satya
simply greatest,least are rowlevel functions
max,min are the column level functions
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is clustered index in sql?
What are % type and % rowtype?
What is sql injection owasp?
What is partition in sql query?
What is cursor in pl sql with examples?
Why is %isopen always false for an implicit cursor?
What is the difference between sql, mysql and sql server?
Is sqlite good enough for production?
Is sql between inclusive?
What is sql engine in oracle?
What is sql query optimization?
what is bcp? When does it used? : Sql dba
Which command is used to call a stored procedure?
Is id a reserved word in sql?
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.