What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
4 12009There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
2 6118There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
4 7948I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
3 6584Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
2118i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
2 5891Post New Microsoft Oracle General Interview Questions
At a shop of marbles, packs of marbles are prepared. Packets are named A, B, C, D, E …….. All packets are kept in a VERTICAL SHELF in random order. Any numbers of packets with these names could be kept in that shelf as in this example: bottom of shelf ---> [AAAJKRDFDEWAAYFYYKK]-----Top of shelf. All these packets are to be loaded on cars. The cars are lined in order, so that the packet could be loaded on them. The cars are also named [A, B, C, D, E,………….]. Each Car will load the packet with the same alphabet. So, for example, car ‘A’ will load all the packets with name ‘A’. Each particular car will come at the loading point only once. The cars will come at the loading point in alphabetical order. So, car ‘B’ will come and take all the packets with name ‘B’ from the shelf, then car ‘C’ will come. No matter how deep in the shelf any packet ‘B’ is, all of the ‘B’ packets will be displaced before the ‘C’ car arrives. For that purpose, some additional shelves are provided. The packets which are after the packet B, are kept in those shelves. Any one of these shelves contains only packets, having the same name. For example, if any particular shelf is used and if a packet with name X is in it, then only the packets having names X will be kept in it. That shelf will look like [XXXXXXX]. If any shelf is used once, then it could be used again only if it is vacant. Packets from the initial shelf could be unloaded from top only. Write a program that finds the minimum total number of shelves, including the initial one required for this loading process.
Explain what is the difference between view and partial view?
my english is not too good then what we apply for a php programer post
What are all the major components of a chart of accounts?
how to deploy tomcatserver to weblogic server? write d following steps?
How can I find the modification date and time of a file?
Are These Dff's Flexible?
Draw a binary Tree for the expression : A * B - (C + D) * (P / Q)
Are .txt files safe to open?
Differentiate between abap memory and sap memory?
Define configuration tab?
List type of relationships/ asociations supported by django?
What is data type in java?
Explain sap hybris payment module?
How many tabs are available to view your test in a test pane and what are they?