I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
IBM,
1682I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
4 5014i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
CGI,
4 6291when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
14601) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
2 5816how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
1 3457two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
2 4035I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
1 3927Post New Oracle General Questions
How will you write a query to get a 5th rank student from a table student_report?
What are the built-in functions used for sending Parameters to forms ?
How to create a stored procedure in oracle?
What is the difference between substr & instr functions?
What is the simplest tool to run commands on oracle servers?
How to assign values to data fields in record variables?
Explain the use of log option in exp command.
What do you mean by merge in oracle and how can we merge two tables?
How do I find my oracle client driver version?
What is open database communication (odbc) in oracle?
How to define an anonymous block?
What is the difference between Delete, Truncate and Drop in Oracle?
What is Data Dictionary Cache in Oracle?
How to export several tables together?
How to select all columns of all rows from a table in oracle?
