What can you do with pl sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is sql lookup?
What is the difference between delete and truncate commands?
What is dynamic sql in pl sql?
What is trigger types of trigger?
table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.
What is indexing oracle sql?
what is oracle database ? : Sql dba
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How long does it take to learn pl sql?
Is trigger a stored procedure?