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 6578How 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 16254What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 16409What 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 12116
What is the execution plan in sql?
What are the three pl sql block types?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
List out the acid properties and explain?
What is cte?
How will you distinguish a global variable with a local variable in pl/sql?
Which one is better subquery or joins?
What does a pl/sql package consist of?
What is sqlite used for?
What is varchar example?
Does pl/sql support create command?
What is pls_integer in pl sql?
How to assign sql query results to pl sql variables?
What is sqlservr exe?
what is the difference between where clause and having clause? : Sql dba