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 5580How 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 12794What is the use of cursor ? how cursor allocate context area for executing the sql statement?
HCL,
4 13886What 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 10113
Are stored procedures faster than dynamic sql?
Why we use stored procedure instead of query?
Can a select statement fire a trigger?
How many sql commands are there?
what is 'mysqld'? : Sql dba
Mention what are the benefits of pl/sql packages?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is sp_pkeys? : Transact sql
What is the maximum number of triggers, you can apply on a single table?
How do you pronounce sql?
what is dbms? : Sql dba
What is the difference between inner join and natural join?
How to pronounce postgresql?
What is the difference between sql and mysql?
What is sql architecture?
