How to handle Null value in WHERE Condition?
Describe variable length record representation in files using byte string representation
How to get System time in SQL?
What are Pair Wise & Non-Pair Wise Columns?
What is soundx in SQL?
Latest Answer: This is Soundex Function is useful to select the data according to the sound of
the given value but not compare with the casing of that letters.For Example:
SQL> SELECT * FROM emp WHERE Soundex(Ename)=Soundex('Analyst');
It select all the Analyst ...
How many ref cursors can be dynamically opened in stored procedures for a session?
Latest Answer: more then one query open same cursor name at same time (use unlimited query) ...
How to use select statement in Case?
Latest Answer: SELECT e.emp_name, e.emp_id, CASE e.emp_id WHEN 1133 THEN ' The ...
How to secure SQL scripts so that they cannot be seen by others but can only be executed.
Latest Answer: Create a view and remove all the privilages except select on that view ...
What is use of lock query in SQL Plus? Give its syntax and implementation?
Latest Answer: Locking protect table when several users are accessing the same table.
Locking is a concurrency control technique in Oracle. It helps in data integrity
while allowing maximum concurrency access to data. Oracle offers automatic
locking whenever situation ...
How to retrieve odd and even number of rows from a table?
Latest Answer: select * from (select rownum as rwid, a.* from (SELECT empno,ename,job,mgr,hiredate,sal,comm,deptno from emp) a) where mod(rwid,2) = 1
This query will be helpful to find out the odd records for even records just change to mod(rwid,2) = 0
Thanks
Aditya ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
