What are the varoius components of physical database structure of oracle database?
No Answer is Posted For this Question
Be the First to Post Answer
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are advantages fo Stored Procedures?
Please explain joins in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
Explain the use of record length option in exp command.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
what are actual and formal parameters?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is a procedure in oracle?
How to create lov dynamically at runtime & attach to text field?