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 5849How 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 13918What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 14494What 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 10720
What is the use of desc in sql?
What is sql rowcount?
what are the t string functions available in tsql? : Transact sql
What are stored procedures used for?
Enlist some predefined exceptions?
What is the purpose of primary key?
How do I write a sql query in pgadmin 4?
what is the difference difference between procedure and packages
What plvcmt and plvrb does in pl/sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is on delete restrict?
Write a sql select query that only returns each name only once from a table?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What operating systems are supported by oracle sql developer?
What is execute immediate?