No Answer is Posted For this Question
Be the First to Post Answer
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
What is record variable?
Does truncate release storage space?
Types of cursors and explanation each of them ?
what is the difference between truncate and drop statements? : Sql dba
What is primary and foreign key?
What is pl/sql table? Why it is used?
What is materialised View?
What is the sql query to display the current date?