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;

What privilege is needed for a user to delete rows from tables in another schema?

1137

---

How to bring a tablespace offline?

1116

---

How to write text literals in oracle?

1118

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

---

What the is the diff between local index and global index. give some example.

1685

---

How to call a stored function in oracle?

1068

---

What are the arithmetic operations?

1152

---

Explain oracle left join with an example?

1064

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

How to revoke create session privilege from a user in oracle?

1068

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5378

---

How to update values in a table in oracle?

1079

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2230

---

Give the advantages and disadvantages of clusters.

1096

---

How to execute the package in oracle?

1135

---