- Maximum PK's and PI's How many Primary keys and Primary Indexes can we create on a table.
How many Foreign keys and Secondary indexes can we create on a table.
How many maximum columns can we create in a table
- Open a Excel File directly from SQL command lineHow to open an excel sheet directly from the SQL prompt?
- Select 10 Random RecordsHow to write a query in SQL 2005 in order to Select 10 random records from table?
- Date ConversionsHow to convert any kind of date that comes in any format from the user to 'yyyymmdd' in Oracle?
- Retrieve Names from TableHow to retrieve names from table starting with a particular character as a first letter, using with substring, instring without using LIKE function.
You must first Login or Register to view all 192 questions from this category.
Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.