Latest Answer: reuse ...
How to set time in pl/sql(Toad) JOB
How many columns you can create in table from this type "long raw"?
Latest Answer: only single column is allowed per a table of data type LONG or LONG RAW ...
How to find the max value in a Sequence?
Latest Answer: We can get the MAX value of a sequence by using the data dictionary view 'USER_SEQUENCES' .i.e. SELECT MAX_VALUE FROM USER_SEQUENCES WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE' ...
How to skip columns while loading data with SQLLDR
Latest Answer: specify Filler Load datatruncate into table empfields treminated by'|'(field1,field2 filler,field 3) ...
What are analytical functions and how are they used?
How do you create nested tables?
How to create temporary table? Give some example
Latest Answer: create table temp as select*from base table where 1=1; ...
Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode
What is the difference between Nested Table and Normal Table?
Latest Answer: Normal Table : It contain rows and columns.Each Row-Column represente only one value i.e intersection of Row-Columncreate table t1(col1 number(10), col2 varchar2(9));------>Creates normal tableNested Table : It contains some Row-Column as another ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
