Search Results


2 years ago by Fischer

Whats the meaning of SELECT 1 SQL statement? I have come across this sql select * from category where exists ( select (1) from products where category.id = products.id ) . . .

  • 4
  • 0
  • 839

2 years ago by Binoy

I have a table with 3 columns, say col1, col2, col3 I want to copy all the data from col2 to col3, how can i do that? . . .

  • 0
  • 0
  • 483

2 years ago by gareth

I have a table with 3 columns - seq, field and data like below Seq Field Data 1 Continent Asia 1 Country India 1 Capital Delhi 1 Language  Hindi 2 Co . . .

  • 1
  • 0
  • 505

2 years ago by mamdouh

What is the SQL statement to insert multiple rows in to database table? INSERT INTO members (name, age, ID) VALUES ('aron',33,1000); INSERT INTO members (name, age, ID) VALUES ('ben',48,1000); INSE . . .

  • 0
  • 0
  • 476

2 years ago by guruprakash

What is purpose of ENABLE keyword in a CREATE TABLE SQL statement? When I check the DDL statement of an existing table in my Oracle database this is what I see CREATE TABLE T_EVENTS ( EVENT . . .

  • 1
  • 0
  • 1893

2 years ago by guruprakash

What does the MONITORING keyword do in a CREATE TABLE statement? . . .

  • 1
  • 0
  • 451