1. How many non cluster index we have use in one table?2. How we set the priority in the cluster index?3. What is co-releated sub query?
What is the literal meaning of SQL
Latest Answer: A literal in SQL mean any representation in string and the value should not be a key word in SQL.Hope this answers your question. ...
How can I copy the stucture of a table to a text file.
Latest Answer: You can copy the definition of objects to text file using dmbs_metadata package.This is the query to copy emp table definition to text file.spool textfilenameselect dbms_metadata.get_ddl('TABLE','EMP','CMSJAN') from dual;spool ...
How to copy a table with constraints and data to another table.
Latest Answer: Using the following query you may copy table structure and data but you can't copy constraints.Create table emp_copy as select * from emp; ...
List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number,
Latest Answer: SELECT a.customer_id FROM premium_user a, calls b WHERE a.customer_id=b.customer_id AND b.call_date NOT BETWEEN SYSDATE-7 AND SYSDATE AND TO_DATE(TO_CHAR(b.call_time_ended,'DD-MON-YYYY')) NOT BETWEEN SYSDATE-7 AND SYSDATE ...
What is difference between constraint and index? How do use them in SQL query?
Latest Answer: Constraint is used to restrict invalid and inconsistent data entry into the table.Index is used for faster retrieval of data.Both are entirely different concepts. ...
What is difference between unique index and simple index?is it possible, two rows can have the same unique index?
Latest Answer: Unique Index:If the index is for a primary or unique key then the owner, name, type, and columns cannot be modified. These properties are all derived from the key constraint. Changing the name of the key constraint will automatically change the name of ...
How can we view sysdate for n number of times
Latest Answer: select sysdate from dual; ...
How to fill Dataset from Datareader?
Latest Answer: by using datasetds = new dataset()sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)ad.fill(ds,tablename)DataReaderdr = new sqlDataReader()sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)dr = sqlcmd.executeReader();The datareader can be used ...
How to know the days or months or years between two employees in emp table.
Latest Answer: select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp; ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
