Oracle PL/SQL Questions

Q

1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row chaining. 9. types of cursors.

✍: Srikanth

A

(This question has not been answered yet. If you know the answer, please share it in a comment below.)

2021-02-10, 7812👍, 1💬

💬 2021-02-10 Karthik: Hi, I just read your articles and we decided that we need backlinks from you so please go through the link for our article. Than...

What is "this" keyword?
What is "this" keyword? It refers to the current object. 2008-11-04, 4598👍, 0💬

What does undefined value mean in JavaScript?
What does undefined value mean in JavaScript? Undefined value means the variable used in the code doesn't exist or is not assigned any value, or the property doesnt exist. 2008-11-18, 4570👍, 0💬

What does the term sticky session mean in a web-farm scenario?
What does the term sticky session mean in a web-farm scenario? Why would you use a sticky session? What is the potential disadvantage of using a sticky session? Sticky session refers to the feature of many commercial load balancing solutions for web-farms to route the requests for a particular sessi... 2008-11-04, 4514👍, 0💬

How do you assign object properties?
How do you assign object properties? obj["age"] = 17 or obj.age = 17. 2008-10-28, 4481👍, 0💬

How to select an element by id and swapping an image?
How to select an element by id and swapping an image? ... <script language="JavaScript" type="text/javascript" > function setBeerIcon() { var beerIcon = document.getElementById("beerI con");beerIcon.src = "images/"+getSelectValue("beer ")+".jpg";} </script> ... <img border="0" s... 2008-11-18, 4430👍, 0💬

How do you create a new object in JavaScript?
How do you create a new object in JavaScript? var obj = new Object(); or var obj = {}; 2008-10-21, 4396👍, 0💬

To set all checkboxes to true using JavaScript?
To set all checkboxes to true using JavaScript? //select all input tags function SelectAll() { var checkboxes = document.getElementsByTagName( "input");for(i=0;i<checkboxes.le ngth;i++){ if(checkboxes.item(i).attribut es["type"].value== "checkbox") { checkboxes.item(i).checked = true; } } } 2008-11-11, 4375👍, 0💬

What’s a quick way to append a value to an array?
What’s a quick way to append a value to an array? arr[arr.length] = value; 2008-10-28, 4367👍, 0💬

You have an ASP.NET web application running on a web-farm ...
You have an ASP.NET web application running on a web-farm that does not use sticky sessions - so the requests for a session are not guaranteed to be served the same machine. Occasionally, the users get error message Validation of viewstate MAC failed. What could be one reason that is causing this er... 2008-11-11, 4358👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.