1)what is the starting "oracle error number"?2)what is meant by forward declaration in functions?
Latest Answer: My 2 cents:Rowid contains hexa-decimal numberbits 1 to 32 (bytes 1 to 4): data object id (0-4294967295) bits 33 to 44 (byte 5 and half byte 6): file number inside the tablespace (0-4095) - file idbits 45 to 64 (half byte 6 and bytes 7 and 8): block number ...
What is difference b/w stored procedures and application procedures,stored function and application function..
Latest Answer: PL/SQL uses two types of cursors: implicit and explicit. PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including queries that return only one row. However, for queries that return more than one row, you must declare an ...
Latest Answer: Whenever we execute DML statements oracle assigns a work area called private sql area to store information. Cursors meachanism allows us to name that private sql area there by access information stored it.The main disadvantage of cursors is that ...
How to trace PL/SQL Package?How to trace PL/SQL procedures?How to trace SQL statement?what is DBMS_TRACE? How to use?SET AUTOTRACE ON; ?If anyone tell me how we can use trace and create log that would be great?
Latest Answer: You can useUSER_ERRORSorSHOW ERRORSYou may also use DBMS_OUTPUT.PUT_LINE ...
Latest Answer: The maximum parsed/compiled size of a PL/SQL block is 64K and the maximum code size is 100K. You can run the following select statement to query the size of an existing package or procedure. SQL> select * from dba_object_size where name = 'procedure_name' ...
Latest Answer: by making use of sql%rowfound. ...
#1 What are the advantages and disadvantages of using PL/SQL or JAVA as the primary programming tool for database automation.#2 Will JAVA replace PL/SQL?
View page << Previous 11 12 13 14 [15] 16 17 18 19 20 Next >>
Go Top
