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: SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL returns "Name of day padded with blanks to length of 9 characters"IF 'Tuesday ' = 'Tuesday' is not ture ...
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 cannot uninstall it is an inbuiltTool can uninstall ...
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: Procedure is a named PL/SQL block tht is stored in the database.Package is a collection of functions and procedures stored within the database. Pkg consists of 2 parts 1. Specification - declares types,functions,procedures,exceptions,cursors2. Body - ...
Latest Answer: Cold Backup- We can take the Backup while DB(eg. Oracle) is down.Hot Backup-We can take the Backup while DB(eg. Oracle) is running.Cold backup is a physical backup. During a cold backup the database is closed and not available to users. ...
Latest Answer: Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse SQL StatementA SQL statement is parsed only if an identical ...
Latest Answer: Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ...
View page [1] 2 3 4 5 Next >>

Go Top