Oracle General (1809)
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 17630Given 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 6101why should i declare foreign key constraint as self relation instead of binary relation in tables ?
2040What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
1 4566Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
2 4978I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad
2 8514Table1- 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 5432Table1- 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 5251
Is rowid unique in oracle?
How to create a new table in your schema?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is oracle archived redo log?
What are the functions of administration?
What is the most common database language that a db administrator needs to know?
How to rebuild an index in oracle?
Can we call procedure inside function in oracle?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
How can you determine if an index needs to be dropped and rebuilt?
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is the max number of columns in an oracle table?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Is oracle an open source?
What is the purpose of a staging area?