Latest Answer: For loading data files or flat files into DB, Unix utility SQL Loader is best suited. can load milions of records in just few secs. Easy to use and compatible with Unix, shell, PERL. Uses control file(.ctl) and parameter file(.par)to direct instructions. ...
Latest Answer: To add in above mentioned constraints for using functions in DML statements:- Called function should not end a transaction ...
How do find that your global temporary table is defined with "on commit preserve rows" or "on commit delete rows"?
How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable?
Latest Answer: Hi guys partitionings nothing but a huge table is divided into some meaningfull parts to do manipulations ,for easy maintainwe divide partitions while creating tables.mainly 3 types of partitions r therethey are1.List partitions2.Range partitions 3.Hash ...
Latest Answer: Theta joins are those joins that use any of the comparison operators(i.e. less than,less than or equal to,greater than,greater than or equal to) ...
Latest Answer: A column included in the definition of referential integrity which would refer to a referenced key. Referenced key is a primary key which is combination of UNIQUE+NOT NULL". ...
Latest Answer: Both are same....-Nikhil ...
How to Create Sequence and insert data using Alter command to a new column?
Latest Answer: ALTER SEQUENCE SEQUENCE_NAMEINCREMENT BY 10 ...
How to write a query to unsort while retrieving the data. it should be niether in ascending nor descending order
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
