Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
1 6584How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id
CGCI,
8 16302What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 16441What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
4 12134
how to load data files into tables with 'mysqlimport'? : Sql dba
What is meant by truncate in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
Why use triggers in sql?
What does <> sql mean?
What is a temporal data type?
What are the advantages of stored procedure?
List out the acid properties and explain?
Is sql harder than python?
Can you rollback after commit?
how to delete an existing column in a table? : Sql dba
Explain the steps needed to create the scheduled job?
What is the maximum rows in csv?
How to sort the rows in sql.
Which data type is a composite type?