Interested to Buy Any Domain ? << Click Here >> for more details...
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,
2135I 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 6380i 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 7550when 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.
19391) 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 6868how 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 4209two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
2 4853I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
1 4608Post New Oracle General Questions
How to use "out" parameter properly?
How to invoke the data pump import utility?
What is the string concatenation operator in oracle?
What is connection pooling in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to run the anonymous block again?
What is a tns service name?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to turn on or off recycle bin for the session?
What is recycle bin in Oracle?
What are the different types of trigger and explain its various uses and functions?
How do I call oracle stored procedures that take no parameters?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to define an anonymous procedure with variables?
