How to connect to oracle using service name instead of sid?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

what is the syntax of update command?

3 Answers   Semantic Space,


Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,


How many categories of data types in oracle?

0 Answers  


How to delete a column in an existing table?

0 Answers  


Explain an integrity constrains?

0 Answers  






You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,


How to create a stored program unit?

0 Answers  


How to export your connection information to a file?

0 Answers  


How to check the oracle tns settings?

0 Answers  


What is redo log?

0 Answers  


What is the max number of columns in an oracle table?

0 Answers  


what is the uses of cusor

3 Answers   Perot Systems,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)