Answer / sudipta santra

to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')

Answer / rajgopal

select to_char(sysdate,'ddsp')||'-'||to_char(sysdate,'mon')||'-'||to_char(sysdate,'yyyysp') from dual

Answer / r98

select to_char(sysdate,'ddsp-month-yyyysp') from dual;

Answer / yogesh

Rajagopal answer is correct.

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

Why stored procedure is better than query?

0 Answers  

---

What are the uses of merge?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

What is the order of sql select?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

Is sql port 1433 encrypted?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

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.

0 Answers   Prodapt,

---

Who is the owner of mysql database?

0 Answers  

---

What is substitution variable in pl sql?

0 Answers  

---