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 6583How 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 16300What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 16440What 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
What are the different types of triggers?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can we join more than 2 tables in sql?
how to include comments in sql statements? : Sql dba
Does sql full backup truncate logs?
What is cascade in sql?
How many types of cursors supported in pl/sql?
What is meant by <> in sql?
what are rollup and cube in t-sql? : Transact sql
How long does it take to learn pl sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Explain scalar functions in sql?
how to write date and time literals? : Sql dba
What is number function in sql?
Define commit?