Answer Posted / pankajsharma

l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')

What is the difference between delete and truncate statement in sql?

1058

---

Is primary key is clustered index?

995

---

What is mutating table error?

1173

---

What are analytic functions in sql?

1019

---

How to create your own reports in sql developer?

1009

---

Is null operator in sql?

1020

---

Is crud a cuss word?

1027

---

Can we create view in stored procedure?

955

---

What is scalar data type in pl sql?

1059

---

Can we use having without group by in sql?

978

---

What is the difference between cross join and natural join?

1014

---

What are the different sql commands?

1063

---

what are the t string functions available in tsql? : Transact sql

1000

---

Do ddl statements need commit?

961

---

how to decrement dates by 1 in mysql? : Sql dba

1011

---