Latest
Difference between RANK and DENSE_RANK
SYS_CONTEXT function and its usage
TO_DATE function explained with examples
10 must-know Oracle Interview questions
5 different ways to load flat file into Oracle table
Install R on Ubuntu
PLJSON – JSON extension for PL/SQL
DDL Triggers Oracle
High Water Mark Oracle
Most read
5 ways to delete duplicate records in Oracle
5 ways to test Oracle RefCursor results
Difference between Trunc and Round function
Ref Cursor examples
TO_CHAR function Oracle
Oracle interview questions and answers
Notepad++ – Tips and Tricks
Difference between DECODE and CASE in Oracle
Julian Date Oracle
Nth highest salary
TO_CHAR (number) function
Advertisements
create table library(sid number not null,bid number not null,tdate varchar2(40),rdate varchar2(40),constraint fk_lib foreign key library(sid,bid)references (student.sid,book.bid))
create table library(sid number not null,bid number not null,tdate varchar2(40),rdate varchar2(40),constraint fk_lib foreign key library(sid,bid)references (student.sid,book.bid))
i got error of ORA-00906: missing left parenthesis .how can i solve it
Foreign composite key cannot be with multiple tables. Also syntax is wrong
a table having duplicate records like 1,2,3,1,2,3,1,2,3,1,2,3,1,2,3….
i want keep unique records in same table and duplicate value should be inserted into another table.
How 2 find 1st or last row of a table
Using rownum, row_number (), rank ()
could you pls post some articles om SQL performance tuning
Sure. I am planning…
hi ,
You have given simple tool to debug the code.
Could you pls tell me how debug package using your simple tool .
Please provide me some example
how to create abstract data type in oracle ?
use types in oracle
when should I go for procedure or function in PL/SQL?
In short, when you need a return value to the caller and can be callable from sql( with some restrictions) use function. (This may not be true in all situations, but mostly)
thank u sir..when will you start perfrmance tuning sessins sir..please do asap sir,its my humble request to u sir
Please ! Can I get more articles on performance tuning and testing the code