Answer / Praphull Kumar Yadav

SQL*Loader is a utility program provided by Oracle to load data into Oracle databases from external sources such as flat files, delimited text files, or even other databases. It allows you to transform and validate the data before loading it into the database.

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

What are user defined functions?

1 Answers  

---

how to create a new view in mysql? : Sql dba

1 Answers  

---

Can we change the table name in sql?

1 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What is the reports view in oracle sql developer?

1 Answers  

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

What is the function that is used to transfer a pl/sql table log to a database table?

1 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

What is the difference between partitioning and sharding?

1 Answers  

---