Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) 1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
HP,
3 17798Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
2 6218why should i declare foreign key constraint as self relation instead of binary relation in tables ?
2094What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
1 4688Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
2 5090I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad
2 8676Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
HCL,
3 5586Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
HCL,
2 5387
How to convert characters to numbers in oracle?
What is a nested table and how is it different from a normal table?
Mention what is the difference between instance recovery and crash recovery?
Tell me step by step to enable Journalization?
What are the steps involved in instance recovery in oracle?
How to end the current transaction in oracle?
What do we mean by record group in oracle forms?
What to do if dba lost the system password?
How does oracle handle read consistency?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to define an oracle cursor variable?
20. Using a set operator, display the client number of all clients who have never placed an order.
I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?
What do you understand by row chaining?
Write a syntax for update query in oracle?