Answer Posted / jacob

try this out
select to_char(sysdate,' Day "," DDsp"th " Month Year') from
dual

this gives the day,date,month,year of the current date

Which constraints we can use while creating database in sql?

617

---

What is sql and also describe types of sql statements?

567

---

What are the parameter modes supported by pl/sql?

534

---

What is a pdo connection?

519

---

Which command is used to call a stored procedure?

505

---

---

How can we optimize a sql query?

575

---

What are character functions in sql?

498

---

Can you join a table to itself?

544

---

What are the different types of sql commands?

599

---

What is the use of triggers?

545

---

What is package in pl sql?

579

---

What is primary and foreign key?

593

---

Can we rollback delete command?

514

---

How does rowid help in running a query faster?

970

---

What is the difference between cross join and natural join?

566

---