Oracle SQL FAQ

Questions: 187

Comments: 640

Oracle SQL FAQ Tags

—

Backup, RDBMS

Showing Questions 51-60 of 188 Questions

<< Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Sponsored Links

Oracle SQL FAQ

Sorting Options :

SQL Query help

Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname

Latest Answer: I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know. ...

Read Answers (3) | Asked by : harini

Answer Question Subscribe

How to find the difference between two dates omitting weekends and holidays?

Latest Answer: select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr')+level,'D') daysfrom dual connect by level ...

Read Answers (1) | Asked by : Haroon

Answer Question Subscribe

How to insert of only system time(hh:mi:ss) into table columnnot in the format of 'dd/mm/yyy hh:mi:ss'

How to insert of only system time(hh:mi:ss) into table columnnot in the format of 'dd/mm/yyy hh:mi:ss' only system time not date.

Read Answers (1) | Asked by : manoj jadaun

Answer Question Subscribe

How can we find the number of day's between any two given date's by using the dual table only?

Read Answers (4) | Asked by : Vishesh

Answer Question Subscribe

How to handle the exceptions in SQL like what to do when the data is not available?

View Question | Asked by : Manoranjan Sahoo

Answer Question Subscribe

How to add a primary key to a table that is not having any primary key?How to display the Date of birth

How to add a primary key to a table that is not having any primary key?How to display the Date of birth from a table in the dd-mm-yyyy format?

Read Answers (1) | Asked by : BagavathiSupriya

Answer Question Subscribe

What is Locking? Explain types of Locking? Explain example of Locking? What is database link? Explain

What is Locking? Explain types of Locking? Explain example of Locking? What is database link? Explain types of database link? Explain example of database link?

Read Answers (1) | Asked by : shailendra tawde

Answer Question Subscribe

How SQL Statment is processed?

Latest Answer: To process an SQL statement, a DBMS performs the following five steps: The DBMS first parses the SQL statement. It breaks the statement up into individual words, called tokens, makes sure that the statement has a valid verb and valid clauses, and so on. ...

Read Answers (1) | Asked by : prashant yavadruth

Answer Question Subscribe

How to use "CASE" keyword in SELECT statement?

Latest Answer: hi,select sno,sname,(case when total>50then 'good'when total>35 and total

Read Answers (2) | Asked by : Rajat Awasthi

Answer Question Subscribe

How to know the size of the table we created?

Latest Answer: SELECT BYTES/1024 FROM DBA_EXTENTS WHERE OWNER = 'SCOTT' AND SEGMENT_NAME = 'EMP'; This will return you size of table in Kilo Bytes. User is Scott and Table ...

Read Answers (1) | Asked by : Sreenivas

Answer Question Subscribe

View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Go Top

#	User Name	Count
1	krishnaindia2007	35
2	Imran_Javed	18
3	jagadeesh9	10
4	tariq_oracle	9
5	jamesravid	7
6	Waseem Mehmood	7
7	vishnu vardhan reddy	6
8	nis1981	6
9	rajakumar_na	6
10	ora.nachs	5

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX