try with ALTER SEQUENCE and change the max val property or SET CYCLE property
Type: Posts; User: soorajsk_84; Keyword(s):
try with ALTER SEQUENCE and change the max val property or SET CYCLE property
parse binds executes fetch
this is the sequence of execution of any statement
SELF JOIN : joins are made on the same table this is in use when u need to create a report on basis of join cond of data in the same table
There are 2 types mainly used
RECORD TYPE:-stores single row
INDEX BY:-can hav multiple rows and column
We use it to handle more than one values at a time
THESE ARE USED MAINLY IN PL/SQL :)
It is not possible to create a index for a normal column at creation
but
Yes you can create for primary and unique key but its of no use the database define index for the 2 keys automaticly at...
use this condition
EXIT WHEN SQL%NOTFOUND
Are u trying to get the data in an out variable or could u please post the code
What exactly is your question do u want to insert data or get the information from the table
This a for a general employee table but this will not giv right result if the employeeid has a null value...
------------------------------------------------------------------
Select * from...
Try creating an INDEX for the table
IN oracle
& is used for dynamic sub
eg SELECT * FROM table
WHERE last_name=&name
VIEW is a virtual table by which we can create a virtual table with columns from diff tables
It makes retrival of data from diff table lot more easier
do u mean like creating a sructure like family tree
then use
START WITH
CONNECT BY PRIOR
this is supported by oracle
CREATE OR REPLACE VIEW table_view
AS
SELECT col1,rownum AS level FROM table
ORDER BY col1;
THIS query genertes col1 ordered by col1
and level wld 2 for 2nd higest value,
NOW
SELECT * FROM...
EXIST would a faster option because IN has return data from table where as EXIST needs to return only a literal which makes it much faster
No u cannot insert a new column in middle of table but to the last is possible with a alter command
CREATE TABLE tablename
AS
SELECT * FROM tablename
WHERE ( a cond that is returns 0 rows)
Between- It returns data between two sets of values
eg:between 10 AND 20 mean returns data between 10 and 20 inclucing 10 and 20
AND:and returns value when two conditions are satisfied