-
-
-
-
-
-
-
-
-
-
How many null value a unique key constraint can have?
I think there can be only one null value for a unique key constraint but some say there can be more than one null value.
-
-
SQL Query help
Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person? ln phone----------------------------------john cubick 1223sam course 4556output:john course
Oracle long datatype
I'm using oracle9i to create a table which stores lyrics in long datatype. But if i store a long string of text and display it from the table, it displays only 80 chars. So someone help me how to store the whole lyrics txt file
Constraint and Index
What is difference between constraint and index? How do use them in SQL query?
What is a deadlock?
There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and every Zink? Please provide SQL.What is a deadlock?
Retrieve data from two tables
How to retrieve data from two tables of different servers
Tune SQL Query
How can you tune the query?
DOS command
How to execute DOS Commands from SQL prompt?
Export data from SQL to Excel
How to export data from a SQL table to MS Excel?
Ans