Interested to Buy Any Domain ? << Click Here >> for more details...
-
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)
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
4 7827i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible
2391i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
IBM,
7 8967In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
2 6047T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
2 5072I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
1 3543A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
3 5686Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
IBM,
6 7658
What is a synonym? What are its various types?
What is user managed backup in Oracle?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What are the differences between char and nchar in oracle?
can we implement package in package?
How can we create the complete backup of data in the oracle.
How to uncatalog backup?
How to change program global area (pga) in oracle?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
How to convert a date to char in oracle? Give one example.
What are the types of trigger in oracle?
Explain the use of indexes option in imp command.
please explain.. DB architecture ...
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
What do you understand by the term 'system change number (scn)'?
