How many column maximum we can add in one table and how many foreign key maximum we can use in one table?
1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name
Latest Answer: Select Columnname from Tablename Groupby Columnname Having Count*>1 ...
1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT
Latest Answer: SQL*Loader is strictly an ORACLE product. Most of not all vendors provide some kind of utility to load tables from flat files. It's not a question of comparison; you can't use SQL Loader in DB2, neither can you use the DB2 Load Utility in Sybase. ...
I need to set up a named set within a cube selecting only 2 members, can anyone out there provide me with a simple piece of MDX that will achieve this?
I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
What is the use of database index (apart from fast searching of records);What is use of composite key ?
Latest Answer: It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuning wizard to improve performance.Go to http://microsoft.msdn.com ...
Latest Answer: Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com ...
View page << Previous 3 4 5 6 [7] 8 9 10 Next >>
Go Top
