aak

• Sep 15th, 2016

No, You can add the proc in body and not declare it in the spec.. this is ok as it would mean that that proc is a private procedure but visa versa is not possible. It would give compilation error.

Sudhanshu

• Jul 26th, 2016

"oracle8 Create or replace package Test_pkg as 2 procedure Proc1; 3 end; 4 / Package created create or replace package body Test_pkg as 2 3 procedure proc1 is...

Answer Question  Select Best Answer

We have two type of constraints - Table Level and Column Level. Which is better and why..?

Mohit

• Oct 3rd, 2015

I think Table level contraints are imposed when we have to compare values in multiple columns,suppose delivery_date cannot be less than order_date..

abhilashnanupillai

 Profile Answers by abhilashnanupillai Questions by abhilashnanupillai

• Feb 20th, 2009

Constrains are the key word along with create table command. Different type of table constraints are primary key not null unique etc.

Answer Question  Select Best Answer

Select round(13.19,1) from dual will return 13.2Select round(13.19,-1) from dual ....what will be the output.....IN ORACLE

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 13th, 2008

SELECT ROUND(13.19,-1) FROM DUAL;RETURN result IS 10; WHEN you pass second argument AS "-1" , rounding takes place BEFORE the DECIMAL point.That IS the reason IN the above example it rounds 13 TO 10. IF you USE 15 OR more than 15 it will ROUND TO 20

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

SELECT ROUND(13.19,-1) FROM DUALRETURN RESULT IS 10;

Answer Question  Select Best Answer