What is the usage of control file in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What are the ansi data types supported in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What are the components of Logical database structure of ORACLE database?
how to tune oracle sql queries pls tell me step by step. urgent pls
how to find out second largest value in the table
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to write numeric literals in oracle?
what are different types of deletes?
What is pragma autonomous transaction in oracle?
What is oracle database client?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000