Latest Answer: Oracle Developed in C language. ...
Is there any syntactical diff between Oracle 9i & 10g or any change in which the Queries are used....It uses SQL isn't it?
Latest Answer: In 9i we does not have the facility to brign the table that is been dropped, but in 10g we have something like flashback and also in 10g they have added one extra regular expression ...
SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8
Latest Answer: Actually there is no sytactical error in this code. It just that the if condition always evaluates to false 'coz the query returns the day of the week with trailing spaces(except for Wednesday) and thus will never be equal to 'Tuesday'. ...
give the dbms_pipe commands in oracle of there execution,which are used to send & recieve messages what is the max size can sent at one go
Latest Answer: dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.
The important functions/procedures in this package are(1) CREATE_PIPE to create a new pipe ==> dbms_pipe.create_pipe(pipename) where pipename can be Oracle ...
This is odd and I fear I may be missing something basic. I am using the Oracle forms supplied pop up calendar widget. When I click on the calendar to select a date it returns a strange value. The year
What is the difference between the tools and utilities in Oracle 9i?
Latest Answer: Utility is something which comes along with software where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development. ...
Latest Answer: During the execution of an update statement, the server process looks into library cache whether same kind of query is recently executed or not i.e. explain plan is ready for execution or not in shared pool and then search for that record block ...
Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
Latest Answer: 1. Procedure Overloading and Function Overloading Possible in Package. This Overloading Concept Not Possible in Procedure.2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure. ...
Latest Answer: Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo files. Here we get consistent backup image.Hot backup ...
View page [1] 2 3 4 5 Next >>
Go Top
