Topics
Products
Follow Us:

Oracle Questions and Answers (Q&A)

John Smith
Answered: Mar 28, 2020
0

DECLARE l_parent_number NUMBER := 1; BEGIN DECLARE l_child_number NUMBER := 2; BEGIN -- l_parent_number and l_child_number are in scope ...Read More

1 Answer

204 views
John Smith
Answered: Mar 28, 2020
Sample solution 1 CREATE OR REPLACE FUNCTION date_as_mmyyyy ( p_date IN date ) RETURN varchar2 AS l_date VARCHAR2(6); BEGIN SELECT TO_CHAR(NVL(p_date,SYSDATE),MMYYYY) INTO...Read More

1 Answer

204 views
John Smith
Answered: Mar 28, 2020
The DATE datatype stores date values with a timestamp
VARCHAR2 can be a maximum size of 4,000 bytes; CHAR, 2,000 bytes

1 Answer

204 views
Muthuk
Answered: Mar 28, 2020
Cursor
Constant

1 Answer

203 views
Unrealvicky
Answered: Mar 28, 2020
SELECT TO_CHAR(SYSDATE, yyyy ) FROM dual;

1 Answer

203 views
John Smith
Answered: Mar 28, 2020
A new index is built using an existing index as the data source.
During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces.

1 Answer

202 views
Leonfrnnd
Answered: Mar 28, 2020
A. ‘03-jul-96’ + 7
B. ‘03-jul-96’ – 12
C. ‘03-jul-96’ + (12/24)

1 Answer

202 views
Timmy
Answered: Mar 28, 2020
Business tools

1 Answer

202 views
John Smith
Answered: Mar 28, 2020
2

Subinventories are unique physical or logic locations and you must define at least one subinventory. You can define two types of subinventories : Storage and Receiving Storage : Used...Read More

1 Answer

202 views
Timmy
Answered: Mar 28, 2020
Total function

1 Answer

201 views
John Smith
Answered: Mar 28, 2020
Insert into test values(10000.234);
insert into test values(1000.2345);
insert into test values(10000.2345);

1 Answer

200 views

Related Topics Of Oracle

Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.