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 5838How 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 13823What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 14456What 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 10686
How many types of triggers exist in pl/sql?
How to run sql commands in sql*plus?
What is the unique index?
Name some usages of database trigger?
What are the events on which a database trigger can be based?
what is the difference between $message and $$message? : Sql dba
What is nvarchar in sql?
Why select is used in sql?
Does user triggers have entry for trigger with compilation errors?
Explain the savepoint statement.
What is constant in pl sql?
How do you identify a primary key?
Can we use ddl statements in stored procedure sql server?
How many types of literals are available in pl sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?