what is Table ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
A table is the basic unit of data storage in an ORACLE
database. The tables of a database hold all of the user
accessible data. Table data is stored in rows and columns.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anand
table is nothing but it is collection of row and column.
Is This Answer Correct ? | 0 Yes | 0 No |
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is a nested table?
How to load excel data sheet to oracle database
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
what is cartesian product?
What are the different types of database objects?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
After using set unused can we enable the column again to use? Please give me some answers....
what are the different types of cursors? explain?
What is a relational database management system?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?