Answer Posted / pari

declare
str varchar2(250);
str1 varchar2(250);
begin
select to_char(sysdate,'dd-mm-yyyy hh:mi:ss') into str from
dual;
dbms_output.put_line (str);
str1 := substr(str,instr(str,' ',1)+1 );
dbms_output.put_line (str1);
end;

Difference between the “verify” and “feedback” command?

1372

---

What to do if the startbd.bat failed to start the xe instance?

1087

---

Explain an exception and its types?

1081

---

Why do we need integrity constraints in a database?

1027

---

How many categories of data types in oracle?

1032

---

How to load excel data sheet to oracle database

1030

---

Explain a data segment?

1074

---

How can I get column names from a table in oracle?

1052

---

What is the difference between online and offline backups?

1062

---

How to test null values?

1112

---

What is using clause and give example?

1054

---

How to create a table interactively?

1097

---

What is parameterized cursor in oracle?

1157

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2316

---

How to create lov dynamically at runtime & attach to text field?

1209

---