1. How can I create an empty table emp with same structure as employees?
Create table emp as select * from employees where 1=2;
Create table emp as select * from employees where 1=2;
Popular Posts
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle sto...
-
Anonymous blocks In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in S... -
Pl -sql : Programming Concept. --WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100 DECLARE N NUMBER(3) :=0; BEGIN WHILE N<=100 LOO...
Most Trending
-
Pl -sql : Programming Concept. --WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100 DECLARE N NUMBER(3) :=0; BEGIN WHILE N<=100 LOO...
-
The WHERE CURRENT OF statement allows you to update or delete the record that was last fetched by the cursor.Using for update nowait will ...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle sto...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle stor...
-
An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using in O...
-
The delete command is used to remove rows from a Table. A where clause can be used to only remove some rows.if no where condition is specif...
-
--Write a PL_SQL block to insert numbers into student table Using For Loop First You need to create table student. sql> create table stu...
-
Anonymous blocks In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in S...
-
Trim :- Removes leading and /or trailing blanks(or other characters ) from a string. Syntax:- TRim([[<trim_spec >] char ] SQL> sele...
-
CREATING MANUAL DATABASE Create the following directories in a folder where u want to create database: -- c:\oracle\admin\dbname...
Popular Posts
-
Pl -sql : Programming Concept. --WRITE A PROGRAM TO PRINT EVEN NUMBERS FROM 1 TO 100 DECLARE N NUMBER(3) :=0; BEGIN WHILE N<=100 LOO...
-
The WHERE CURRENT OF statement allows you to update or delete the record that was last fetched by the cursor.Using for update nowait will ...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle sto...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, oracle stor...
-
An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using in O...
-
The delete command is used to remove rows from a Table. A where clause can be used to only remove some rows.if no where condition is specif...
-
--Write a PL_SQL block to insert numbers into student table Using For Loop First You need to create table student. sql> create table stu...
-
Anonymous blocks In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in S...
-
Trim :- Removes leading and /or trailing blanks(or other characters ) from a string. Syntax:- TRim([[<trim_spec >] char ] SQL> sele...
-
CREATING MANUAL DATABASE Create the following directories in a folder where u want to create database: -- c:\oracle\admin\dbname...